Tag: SQL

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...

To determine the size of tables in a database hosted on Microsoft SQL Server, you need to perform the following steps: 1. Connect to a database server using SQL Server Management Studio...

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(...

Oracle Databases - Many developers turn to databases for their outstanding high performance and ability to perform complex tasks.Oracle has built a reputation for delivering reliable performance...

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' ]...

Oracle/PLSQL TO_TIMESTAMP_TZ function converts a string into a value of TIMESTAMP type with TIMEZONE (time zone). Oracle/PLSQL syntax of TO_TIMESTAMP_TZ functions TO_TIMESTAMP_TZ( string1 , [...

The Oracle/PLSQL TO_SINGLE_BYTE function returns a character value in which all multibyte characters are converted to single-byte characters.To use this function, your database character set...

The Oracle/PLSQL TO_NUMBER function converts a string into a number. Oracle/PLSQL syntax of the TO_NUMBER function TO_NUMBER( string1, [ format_mask_id ], [ nls_language_id ] ) Parameters or...

The Oracle/PLSQL TO_NCLOB function converts the LOB value to the NCLOB value. Oracle/PLSQL syntax of TO_NCLOB function TO_NCLOB( expression_id ) Parameters or argumentsexpression_id -...