FROM_TZ is one of the vital Conversion functions of Oracle. It is used to convert a TIMESTAMP value to a TIMESTAMP WITH TIME ZONE value. The FROM_TZ function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i. Syntax: FROM_TZ ( timestamp_value, time_zone_value) Parameters: timestamp_value: It … Read more

FLOOR is one of the vital Numeric/Math functions of Oracle. It is used to get the smallest integer value which is either less than or equal to the mentioned number. The FLOOR function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: … Read more

FIRST_VALUE is one of the vital Analytic functions of Oracle. It is used to get the first value in an ordered set of values from an analytic window. The FIRST_VALUE function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i. Syntax 1: FIRST_VALUE (expression) [RESPECT … Read more

EXTRACT is one of the vital Date/Time functions of Oracle. It is used to extract a value from a date or interval value. The EXTRACT function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i. Syntax: EXTRACT ( { YEAR | MONTH | DAY | … Read more

EXP is one of the vital Numeric/Math functions of Oracle. It is used to get the value of the e raised to the nth power. Here e = 2.71828183 and n represents the number passed with the EXP function. The EXP function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle … Read more

EQUI JOIN The Oracle EQUI Join query always uses a comparison operator to check the matching columns of the associated tables, and then the matching columns of the two tables are displayed as the result. It is not mandatory to mention the JOIN keyword for this type of joining to take place. It also happens … Read more

EMPTY_CLOB is an advanced function that the Oracle database supports. It is used to initialize a LOB column to EMPTY in an INSERT or UPDATE statement. It can also be used to initialize a LOB variable. The EMPTY_CLOB function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, … Read more

EMPTY_BLOB is an advanced function that the Oracle database supports. It is used to initialize a LOB column to EMPTY in an INSERT or UPDATE statement. It can also be used to initialize a LOB variable. The EMPTY_BLOB function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, … Read more

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