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
Upper – Oracle SQL Function
UPPER returns a VARCHAR2 string that contains all the characters of argument1 in uppercase. The argument1 can be a CHAR, VARCHAR2,NCHAR,NVARCHAR2,CLOB or NCLOB data type. Example: SELECT UPPER(‘oracle rocks’) as RESULT from DUAL; RESULT —————— ORACLE ROCKS
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
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
ADD_MONTHS – Oracle SQL Function
ADD_MONTHS returns a DATE which is argument1 plus num, or number of months. The argument1 can be a DATE or any type that can be implicitly converted to a DATE. The num argument can be a NUMBER, or any type
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
Sessiontimezone – Oracle SQL Function
SESSIONTIMEZONE returns the time zone of the current session. Example: SELECT SESSIONTIMEZONE as RESULT from DUAL; RESULT ————- -05: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
CURRENT_DATE – Oracle SQL Function
CURRENT_DATE returns the current date Example: SELECT CURRENT_DATE as RESULT FROM DUAL; RESULT —————- 05-SEP-05
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