DUMP is one of the vital string/char functions of Oracle. It is used to return a VARCHAR2 value for an expression. The value returned specifies the datatype code, along with the length of the expression (in bytes), and the internal representation of the passed expression. The DUMP function is supported in the various versions of … Read more
DROP TABLE To move a table to recycle bin or to completely delete a table from the Oracle database, Oracle DROP TABLE statement is used. Syntax: DROP TABLE schema_name.table_name [CASCADE CONSTRAINTS | PURGE]; Parameters: schema_name: It is used to specify the name of the schema that owns the table to be removed. It is necessary … Read more
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