You are currently browsing the articles from Techno Oracle matching the category
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.
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.
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.
In Oracle PL/SQL SINH unction returns Hyperbolical Sine value of the input provided n.The input provided must be of an angle and should be expressed in radians Syntax SINH(angle) Example SELECT SINH(1) “Hyperbolic sine value” FROM DUAL; Hyperbolic sine of 1 ——————– 1.17520119
Written by admin on July 2nd, 2010 with 8 comments.
Read more articles on Built-In Functions.
In Oracle PL/SQL FLOOR function Returns largest integer equal to or less than num. Syntax FLOOR(NUM) Example SELECT FLOOR(24.7) “Floor” FROM DUAL; Floor ———- 24
Written by admin on July 1st, 2010 with no comments.
Read more articles on Built-In Functions.
In Oracle PL/SQL ADD_MONTHS function Returns the date d plus n months. The argument n can be any integer. If d is the last day of the month or if the resulting month has fewer days than the day component of d, then the result is the last day of the resulting month. Otherwise, the [...]
Written by admin on July 1st, 2010 with no comments.
Read more articles on Built-In Functions.
In Oracle PL/SQL ACOS Function Returns the arc cosine of input . Inputs are in the range of -1 to 1, and outputs are in the range of 0 to pi and are expressed in radians. Syntax ACOS(NUM) Example SELECT ACOS(.3)”ArcCosine” FROM DUAL; ArcCosine ———- 1.26610367
Written by admin on July 1st, 2010 with no comments.
Read more articles on Built-In Functions.