SIGN returns a NUMBER that specifies the sign of the 1st argument. The possible return values are: -1 if the number is 0 -1 if the number is aBINARY_FLOAT or BINARY_DOUBLE and is = 0 or is Nan Example: SELECT
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,
LAST_DAY – Oracle SQL Function
LAST_DAY returns the last day of the month specified in argument1. Argument1 can be a DATE value or a string that can resolve to a DATE datatype. Example: SELECT LAST_DAY(’12-OCT-04′) as RESULT from DUAL; RESULT ————— 31-OCT-04
Sqrt – Oracle SQL Function
SQRT returns the square root of the argument. The argument can be a numeric value or a type that Oracle can im,plicitly convert toa numeric value. SQRT returns a value that is the same type as the supplied argument. Example:
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
LOCALTIMESTAMP – Oracle SQL Function
LOCALTIMESTAMP returns a TIMESTAMP value. You can specify an optional integer argument to specfiy the precision of the second field. Example: SELECT LOCALTIMESTAMP FROM DUAL; LOCALTIMESTAMP —————————- 13-SEP-05 03.02.49.407000 PM
Trunc – Oracle SQL Function
TRUNC returns the 1st argument truncated by the number of decimal places specified in the 2nd argument. The 2nd argument can be either be a positive integer to specify the right of the decimal point or a negative number to
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
MONTHS_BETWEEN – Oracle SQL Function
MONTHS_BETWEEN returns an integer specfiying the number of months between two dates. The result can be either positive or negative depending on which date is greater. Example: SELECT MONTHS_BETWEEN(10-JAN-2036′, ’10-JAN-2004′ ) AS RESULT FROM DUAL; RESULT ——————- 384
Ascii – Oracle SQL Function
ASCII returns the decimal representation of the character supplied in the 1st argument. If your database is set to ASCII, then this will be the ASCII code for the character. If your database is set to EBCDIC then it will