GREATEST is one of the vital Numeric/Math functions of Oracle. It is used to get the greatest value from a list of expressions. The GREATEST function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: GREATEST( expr_1, expr_2, … expr_n ) Parameters: … Read more
GLOBAL TEMP TABLES Temporary tables are much like an ordinary table, with an only vital difference of not having foreign keys related to other tables. It contains all the attributes of a table including information about rows and block, triggers, join cardinality, etc. Syntax: To create a Global Temporary Table with a single column. CREATE … Read more
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