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:
Concat – Oracle SQL Function
CONCAT returns 1st argument concatenated with 2nd argument. The arguments can be CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB or NCLOB. If the two arguments are of the same data type, then CONCAT returns a string of that type. If they are
FROM_TZ – Oracle SQL Function
FROM_TZ converts a timestamp and time zone value into a TIMESTAMP WITH TIMEZONE value. Syntax: FROM_TZ(timestamp, timezone) Example: SELECT FROM_TZ(TIMESTAMP ‘2004-10-24 06:00:00’, ‘2:00’) as RESULT FROM DUAL; RESULT ————– 24-Oct-04 06.00.00 AM +2:00
Length – Oracle SQL Function
LENGTH returns an integer that is the length of the 1st argument. The 1st argument can be a CHAR, VARCHAR2,NCHAR,NVARCHAR2,CLOB or NCLOB datatype. Example: SELECT LENGTH(‘How long is this?’) as RESULT FROM DUAL; RESULT —————- 17
LAST_DAY – Oracle SQL Function
LAST_DAY returns the last day of the month specified in argument1. Argument1 can be a DATE value or a string that can resolve to a DATE datatype. Example: SELECT LAST_DAY(’12-OCT-04′) as RESULT from DUAL; RESULT ————— 31-OCT-04
Round – Oracle SQL Function
The round functions allows you to round up any number to a certain number of decimal places. For example: round(6.02,1) would return 6.0 round(6.789,2) would return 6.79 See Ceil to round numbers up to the nearest integer. See Floor to
Variance – Oracle SQL Function
VARIANCE returns the variance of the values in expression. Syntax: VARIANCE(expression) Example: SELECT VARIANCE (COMMISSION_PCT) FROM EMP; VARIANCE(COMMISSION_PCT) ———————————————– .00726303
Replace – Oracle SQL Function
The replace functions allows you to replace all occurences of one string with another. The syntax for the replace function is: replace ( string , search_string, change_to) string is the source string. search_string is the character or set of characters
Abs – Oracle SQL Function
ABS returns the absolute value of a numeric argument. It takes a numerics value, or any value that can be implicitly converted to a numeric value, as its argument and returns the absolute value as a numeric value. The return