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
Corr – Oracle SQL Function
CORR returns the coefficient of a pair of numbers. Syntax: CORR(expression1, expression2) Both expressions can NUMBER values or any value that can be converted to a NUMBER. e.g. SELECT id, CORR(list_price, min_price) as RESULTS FROM product_info GROUP BY supplier_id NOTE:
Count – Oracle SQL Function
COUNT returns the number of rows returned by the query where the expression is not NULL. Syntax: COUNT([DISTINCT] expression) If you pass the count function the (*) wildcard then it will return the count of all rows, including the rows
Covar_pop – Oracle SQL Function
COVAR_POP returns the population covariance of a pair of numbers. Syntax: COVAR_POP(expression1, expression2) Example: SELECT id, COVAR_POP(list_price,min_price) as RESULT FROM product_information GROUP BY id;
Covar_samp – Oracle SQL Function
COVAR_SAMP returns the sample covariance of a pair of numbers. Syntax: COVR_SAMP(expression1, expression2) Example: SELECT id, COVAR_SAMP(list_price,min_price) as RESULT FROM product_information GROUP BY id;