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
Treat – Oracle SQL Function
TREAT allows you to change the declared type of the expr argument. This function comes in handy when you have a subtype that is more specific to your data and you want to convert the parent type to the more
Sysdate – Oracle SQL Function
SYSDATE returns a DATE that represents the date and time set on the operating system of the machine Oracle is installed on. The format of SYSDATE is controlled by the NLS_DATE_FORMAT session parameter. Example: SELECT SYSDATE FROM DUAL; SYSDATE ——————-