Tag: PL/SQL

The SQLCODE function returns the error number associated with an exceptional situation. This function can only be used in the exception handling section of your code. SQLCODE function...

Oracle/PLSQL NVL2 function extends the functionality of the NVL function. It replaces the value when a Null value is encountered and also when a non-Null value is encountered. Oracle/PLSQL...

Oracle/PLSQL NVL function allows you to replace the value when there is a Null value. Oracle/PLSQL syntax of NVL functions NVL( string1_id, replace_with_id ) Parameters or arguments...

Oracle/PLSQL NULLIF function compares expr1 and expr2. If expr1 and expr2 are equal, the function NULLIF returns NULL. Otherwise, it returns expr1. Oracle/PLSQL syntax of the function...

The Oracle/PLSQL NANVL function allows you to replace a value for a floating point number such as BINARY_FLOAT or BINARY_DOUBLE when Nan (Not a number) is encountered. This is most often used to...

Oracle/PLSQL LNNVL function is used in the WHERE SQL query sentence to evaluate the state when one of the operands may contain the value NULL. Oracle/PLSQL syntax of LNNVL function LNNVL(...

Oracle/PLSQL GROUP_ID function assigns a number to each group as a result of GROUP BY operator. GROUP_ID function is most often used to identify duplicate groups in query results. Syntax of...

Oracle PLSQL EMPTY_CLOB function can be used to initialize empty LOB columns in INSERT or UPDATE operators or it can be used to initialize LOB variable. Oracle/PLSQL syntax of EMPTY_CLOB...

Oracle/PLSQL EMPTY_BLOB function can be used to initialize empty LOB columns in INSERT or UPDATE operators or it can be used to initialize LOB variable. Oracle/PLSQL syntax of EMPTY_BLOB...

Oracle/PLSQL DECODE function has functionality of IF-THEN-ELSE operator. Oracle/PLSQL syntax of the DECODE function DECODE( expression_id , search_id , result_id [, search , result]... [,...

Oracle PL SQL function COALESCE returns the first non-zero expression from the list. If all expressions are defined as Null, the COALESCE function will return Null. Oracle PL/SQL syntax of...

Oracle/PLSQL function CARDINALITY returns the number of elements in the nested table. Oracle/PLSQL syntax of the CARDINALITY function CARDINALITY( nested table column_id ) Parameters or...

The Oracle/PLSQL BFILENAME function returns the BFILE locator corresponding to the name of the operating system's physical file filename. Syntax of the BFILENAME function BFILENAME(...

Conversions:Function DescriptionBIN_TO_NUM The Oracle/PLSQL function BIN_TO_NUM converts the vector to the corresponding decimal number.CAST The Oracle/PLSQL CAST function...

Oracle/PLSQL function TO_YMINTERVAL converts a string into a value of NTERVAL type from YEAR to MONTH. Oracle/PLSQL syntax of the TO_YMINTERVAL function TO_YMINTERVAL( character_id...

The Oracle/PLSQL TO_TIMESTAMP function converts a string to the TIMESTAMP value. Function Oracle/PLSQL TO_TIMESTAMP syntax TO_TIMESTAMP( string1, [ format_mask_id ] [ 'nlsparam_id' ]...