Tag: PLSQL

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

The Oracle/PLSQL TO_MULTI_BYTE function returns a character value from all single-byte characters and converts it into multi-byte characters. To use this function, your database character set...

The Oracle/PLSQL TO_LOB function converts LONG or LONG RAW values to LOB values. Syntax of the Oracle/PLSQL TO_LOB function TO_LOB( long_column_id ) Parameters or argumentslong_column_id...

The Oracle/PLSQL TO_DSINTERVAL function converts the string to INTERVAL DAY TO SECOND. Syntax of the Oracle/PLSQL TO_DSINTERVAL function TO_DSINTERVAL( character [ nls_parameter_id ] )...

Oracle/PLSQL TO_CLOB function converts character data of CLOB type Syntax of the Oracle/PLSQL TO_CLOB function TO_CLOB(expression_id) Parameters or argumentsexpression_id - can accept...

The Oracle/PLSQL RAWTOHEX function converts a RAW value into a hexadecimal character representation. Syntax of the Oracle/PLSQL RAWTOHEX function RAWTOHEX( raw_id ) Parameters or arguments...

The Oracle/PLSQL NUMTOYMINTERVAL function converts a numerical value into a value of type INTERVAL YEAR TO MONTH. Function Oracle/PLSQL NUMTOYMINTERVAL syntax NUMTOYMINTERVAL( number_id,...

The Oracle/PLSQL NUMTODSINTERVAL function converts a numeric value into a value of INTERVAL DAY TO SECOND type. Syntax of the Oracle/PLSQL NUMTODSINTERVAL function: NUMTODSINTERVAL( number_id,...

The Oracle/PLSQL HEXTORAW function converts a string representing a hexadecimal number into a RAW value. Syntax of the Oracle/PLSQL HEXTORAW function HEXTORAW( char_id ) Parameters or...

The Oracle PLSQL FROM_TZ function converts the TIMESTAMP value to TIMESTAMP with the time zone value. Oracle/PLSQL FROM_TZ function syntax FROM_TZ( timestamp_value_id, time_zone_value_id...

The Oracle/PLSQL DECOMPOSE function takes a string and returns a Unicode string. Oracle/PLSQL DECOMPOSE function syntax DECOMPOSE( string_id ) Parameters or argumentsstring_id - a string...

The Oracle/PLSQL CONVERT function converts a string from one character set to another. CONVERT function syntax CONVERT( string1_id , char_set_to_id , [ char_set_from_id ] ) Parameters or...

The SQL SELECT operator is used to extract records from one or more tables in a SQL database. Syntax of the SELECT operator SELECTexpressions_id FROM tabs [WHERE conds] Parameters or...