You are currently browsing the articles from Techno Oracle written in the month of
In Oracle PL/SQL SIN function returns mathematical sine value of the input provided n.The input provided must be of an angle and should be expressed in radians Syntax SIN(angle) Example SELECT SIN(30 * 3.14159265359/180) “Sine value of 30” From Dual Sine of 30 degrees —————— .5
Written by admin on July 29th, 2010 with no comments.
Read more articles on Built-In Functions.
LOOPS in PL/SQL allow us to execute a sequence of statements repeatedly. Three types of loops are Simple Loops FOR Loops WHILE Loops Simple Loops This is the most basic kind of loop.They include LOOP, END LOOP, and some method of EXIT.We use the simple loop when we want the body of the loop to [...]
Written by admin on July 28th, 2010 with no comments.
Read more articles on Oracle PL/SQL.
In Oracle PL/SQL CEIL function returns the smallest integer greater than or equal to input. Syntax ——– CEIL() Example SQL> select CEIL(4.8) from dual; CEIL(4.8) ———- 5
Written by admin on July 26th, 2010 with no comments.
Read more articles on Oracle PL/SQL.
In Oracle PL/SQL AVG function Returns average value of n. Syntax AVG(n) Example SELECT AVG(salary) “Avg_Sal” FROM emp; Average ———- 2077.21429
Written by admin on July 19th, 2010 with no comments.
Read more articles on Built-In Functions.
IF-THEN The most basic conditional evaluation is an IF-THEN statement. IF a condition is satisfied, THEN do the action. Implicit with this logic is IF a condition is not met, skip the code that follows and continue with the rest of the program. The syntax for an IF-THEN statement is IF condition THEN action; END [...]
Written by admin on July 16th, 2010 with 4 comments.
Read more articles on Home.
SQL stands for Structured Query Language.SQL is a standard computer language for accessing and manipulating databases. SQL is short for Structured Query Language and is a widely used database language, providing means of data manipulation (store, retrieve, update, delete) and database creation.SQL can execute queries,can retrieve data,insert,delete or update records in a database. SQL is [...]
Written by admin on July 15th, 2010 with 3 comments.
Read more articles on SQL tutorials.
In Oracle PL/SQL LOG function returns the logarithm, base m, of n. The base m can be any positive number other than 0 or 1 and n can be any positive number. Syntax LOG(m, n) Example SELECT LOG(10,100) “Log base 10 of 100″ FROM DUAL; Log base 10 of 100 —————— 2
Written by admin on July 7th, 2010 with 2 comments.
Read more articles on Built-In Functions.
In Oracle PL/SQL AVG function Returns average value of n. Syntax AVG(n) Example SELECT AVG(salary) “Avg_Sal” FROM emp; Average ———- 2077.21429
Written by admin on July 7th, 2010 with no comments.
Read more articles on Built-In Functions.
In Oracle PL/SQL ATAN2 function Returns the arc tangent of n and m. Inputs are in an unbounded range, and outputs are in the range of -pi to pi, depending on the signs of n and m, and are expressed in radians. ATAN2(n,m) is the same as ATAN2(n/m) Syntax ATAN(n, m) Example SELECT ATAN2(.3, .2) [...]
Written by admin on July 7th, 2010 with 3 comments.
Read more articles on Built-In Functions.
In Oracle PL/SQL ATAN Function Returns the arc tangent of n. Inputs are in an unbounded range, and outputs are in the range of -pi/2 to pi/2 and are expressed in radians. Syntax ATAN(n) Example SELECT ATAN(.3) “Arc-Tangent” FROM DUAL; Arc-Tangent ———- .291456794
Written by admin on July 7th, 2010 with no comments.
Read more articles on Built-In Functions.