DENSE_RANK is one of the vital Analytic functions of Oracle. It is used to get the rank of a row in a group of rows. It always results in the consecutive ranking of the rows. The DENSE_RANK function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and … Read more

DECOMPOSE is one of the vital string/char functions of Oracle. It is used to return a UNICODE string for a string. The DECOMPOSE function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i. Syntax: DECOMPOSE( string ) Parameters: string: It is used to specify the … Read more

DECODE is an advanced function that the Oracle database supports. It is used to work as an IF-THEN-ELSE statement. The DECODE function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i. Syntax: DECODE( expression, search, result, search, result… , default ) Parameters: expression: It is … Read more

DBTIMEZONE is one of the vital Date/Time functions of Oracle. It is used to get the database time zone. The result generated is either as a time zone offset or a time zone region name. The DBTIMEZONE function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and … Read more

CURRENT_TIMESTAMP is one of the vital Date/Time functions of Oracle. It is used to get the current date and time in the time zone of the current SQL session. The CURRENT_TIMESTAMP function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i. Syntax: CURRENT_TIMESTAMP Example 1: … Read more

CURRENT_DATE is one of the vital Date/Time functions of Oracle. It is used to get the current date in the time zone of the current SQL session. The CURRENT_DATE function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i. Syntax: CURRENT_DATE Example 1: Select CURRENT_DATE … Read more

CUME_DIST is one of the vital Analytic functions of Oracle. It is used to get a cumulative distribution of a value in a group of values. The CUME_DIST function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i. Syntax: CUME_DIST ( expr_1, expr_2, .. expr_n … Read more

CROSS JOIN The Oracle CROSS Join query joins all the rows of one table with all the rows of another table and then displays the result. For instance, if the FIRST table has x rows and the Second Table has y rows than the resultant table will have x*y rows. Thus this query is often … Read more

CREATE VIEW The view is a virtual table in Oracle with no physical existence as such and thus it does not store any data. The view is saved in the data dictionary of the Oracle and when called, it can be simply executed. Syntax: CREATE VIEW name AS SELECT column_1, column_2, column_3,…… FROM table WHERE … Read more

CREATE TABLE AS To create a table from an existent table, the CREATE TABLE AS statement is used. It copies the columns of the existing table to the new table. Syntax: For creating a table by copying all columns of another table. CREATE TABLE current_table AS (SELECT * FROM existing_table); Syntax: For creating a table … Read more