Tag: Oracle Database

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

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

Oracle Analytical functions take as an argument an SQL table, which represents a logical intermediate result of SQL-operator processing, where a reference to such a function is used, and return...

The Oracle/PLSQL VARIANCE function returns the dispersion of a set of numbers. Oracle/PLSQL syntax of the VARIANCE function VARIANCE(expression_id )where:expression_id - is a numeric...