Tag: Oracle SQL

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

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

Oracle/PLSQL VAR_SAMP function returns selective dispersion of a set of numbers. Oracle/PLSQL syntax of VAR_SAMP function VAR_SAMP(expression_id)expression_id - is a numeric...

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