SQRT returns the square root of the argument. The argument can be a numeric value or a type that Oracle can im,plicitly convert toa numeric value. SQRT returns a value that is the same type as the supplied argument. Example:
CURRENT_DATE – Oracle SQL Function
CURRENT_DATE returns the current date Example: SELECT CURRENT_DATE as RESULT FROM DUAL; RESULT —————- 05-SEP-05
Trunc – Oracle SQL Function
TRUNC returns the 1st argument truncated by the number of decimal places specified in the 2nd argument. The 2nd argument can be either be a positive integer to specify the right of the decimal point or a negative number to
CURRENT_TIMESTAMP – Oracle SQL Function
CURRENT_TIMESTAMP returns the cyrrent system timestamp. You can also specify an optional precision argument to control the precision of the seconds in the time. Example: SELECT CURRENT_TIMESTAMP AS RESULT FROM DUAL; RESULT ————————– 05-SEP-05 01.24.11.968000 PM -4:00
Ascii – Oracle SQL Function
ASCII returns the decimal representation of the character supplied in the 1st argument. If your database is set to ASCII, then this will be the ASCII code for the character. If your database is set to EBCDIC then it will
DBTIMEZONE – Oracle SQL Function
DBTIMEZONE returns the current database timezone Example: SELECT DBTIMEZONE FROM DUAL; DBTIME ———— +00:00
Instr – Oracle SQL Function
The instr function returns the location of a substring in a string. The syntax for the instr function is: instr ( string1 , string2 , [ start_position ], [ nth_appearance ]) string1 is the string to search. string2 is the
Median – Oracle SQL Function
MEDIAN returns the median value of the expression argument. Syntax: MEDIAN(expression) Example: SELECT MEDIAN(max_salary) as med FROM JOBS; MED —————- 10000
Floor – Oracle SQL Function
The floor functions allows you to round down any number to the nearest integer. For example: floor(6.02) would return 6 floor(7.789) would return 7 See Ceil to round numbers up to the nearest integer. See Round to round a number
Rank – Oracle SQL Function
RANK determines the rank of one or more of the expression exp within a result set. Syntax: RANK(expression…) WITHIN GROUP (ORDER BY expression) Example: SELECT RANK(10000) WITHIN GROUP (ORDER BY salary DESC) as RESULT FROM EMP; RESULT ——————- 16