Tag: Oracle

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

Oracle PIVOT operator allows you to cross-request a table to those who started using Oracle 11g. This means that you can combine your results and rotate rows into columns. Syntax for the PIVOT...

Oracle function is a subprogram that calculates a value. CREATE FUNCTION As with other programming languages, you can create your own functions in Oracle. Syntax CREATE [OR REPLACE]...

In Oracle PL/SQL TRIM method removes all items from any collection type. This operation immediately frees up the memory allocated to the items to be removed. Syntax of TRIM collection method in...

DELETE method in Oracle PL/SQL, removes all elements from any collection type. This operation immediately frees up the memory allocated to the items to be removed. Syntax of the DELETE method in...

The Oracle/PLSQL CHARTOROWID function converts a character, varchar2_Id, NCHAR or NVARCHAR2 to ROWID. Syntax of the Oracle/PLSQL CHARTOROWID function CHARTOROWID( value1_Id )where:...

The Oracle/PLSQL CAST function converts (converts) one data type into another. Oracle/PLSQL CAST function syntax CAST ( { expr | ( subquery_id ) | MULTISET ( subquery_id ) } AS type_name_id...

The Oracle/PLSQL BIN_TO_NUM function converts the vector to the corresponding decimal number. Function Oracle/PLSQL syntax BIN_TO_NUM BIN_TO_NUM( expr1_id, expr2_id, ......