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
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;
Cume_dist – Oracle SQL Function
CUME_DIST returns the relative position of a row within a group meeting certain criteria. You can specify one or more expressions to pass as arguments to the function. Syntax: CUME_DIST(expression1,… WITHIN GROUP (ORDER BY) Example: SELECT CUME_DIST(5000,103) WITHIN GROUP (ORDER