NEW_TIME returns the date and time in timt zone ‘tz2’ based on the time zone ‘tz1’ and the date argument ‘the_date’. Syntax: NEW_TIME(the_date, tz1, tz2) You must set the NLS_DATE_FORMAT parameter to a 24-hour format before you execute the NEW_TIME
Rpad – Oracle SQL Function
RPAD returns a VARCHAR2 string that is arg1 right padded with arg3 for a length of n. If arg3 is not provided Oracle will pad with blank spaces. Example: SELECT RPAD(’10 + spaces’,10,’+’) as RESULT from dual;
Next_day – Oracle SQL Function
NEXT_DAY returns the next day specified in the day_to_find argument from the date argument. day_to_find must be a string denoting a valid day of the week. Syntax: NEXT_DAY(date,day_to_find) Example: SELECT NEXT_DAY(’23-OCT-2004′,’FRIDAY’) AS RESULT FROM DUAL; RESULT —————- 29-OCT-2004 00:00:00
Log – Oracle SQL Function
LOG returns the log of the second argument with base of argument 1. The base can be any positive number except 0 or 1, and the second argument can be any positive integer. The arguments can be a numeric value
Soundex – Oracle SQL Function
SOUNDEX returns the phonetic representation of argument1. It is often used to do searching in a table to find words that sound the same as each other but are spelled differently. The argument arg1 can be a CHAR, VARCHAR2, NCHAR,
Sessiontimezone – Oracle SQL Function
SESSIONTIMEZONE returns the time zone of the current session. Example: SELECT SESSIONTIMEZONE as RESULT from DUAL; RESULT ————- -05:00
Mod – Oracle SQL Function
MOD returns the remainder of the first argument divided by the second argument. The arguments can be a numeric value or any type that can be implicitly converted to a numeric value. Oracle will determine the argument with the highest
Translate – Oracle SQL Function
TRANSLATE is similar to the REPLACE function. It differs in that is allows you to make several character replacements in one pass. TRANSLATE returns a VARCHAR2 string that is arg1 with all instances of characters in the match argument replaced
Sys_extract_utc – Oracle SQL Function
SYS_EXTRACT_UTC returns the Cordinated Universal Time from a datetime string including a time zone code or offset. Example: SELECT SYS_EXTRACT_UTC(TIMESTAMP ‘2004-10-23 10:25:00.00 EST’) as RESULT FROM DUAL; RESULT —————- 23-OCT-04 02.25.00.000000000 PM
Nanvl – Oracle SQL Function
NANVL is used to return an alternate value for a BINARY_FLOAT or BINARY_NUMBER that has a Nan (Not a Number) value. The number to check is the first argument, and the second argument is the replacement value if the 1st