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
Chr – Oracle SQL Function
CHR returns the character specified by the code passed in the 1st argument. The returned character depends on the underlying code set that Oracle is using for character data. The argument must be a value that Oracle can implicitly convert
EXTRACT – Oracle SQL Function
EXTRACT allows you to extract parts of a date expression. You may want to extract the year from a date string, or minute value in a date-time expression. Valid extractions include YEAR, MONTH, DAY,HOUR, MINUTE,SECOND,TIMEZONE_HOUR, TIMEZONE_MINUTE, TIMEZONE_REGION and TIMEZONE_ABBR Example:
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
Ceil – Oracle SQL Function
The ceil functions allows you to round up any number to the next integer. For example: ceil(6.02) would return 7 ceil(7.59) would return 8 See Round to round numbers to a particular decimal place See Floor to round a number
Stddev – Oracle SQL Function
STDDEV returns the sample standard deviation of the expression. STDDEV will return zero when it has only one row of input data. Syntax: STDDEV(expression) Example: SELECT STDDEV(COMMISSION_PCT) FROM EMP; STDDEV(COMMISSION_PCT) ——————————————– .0857432345