VAR_SAMP is one of the vital Analytic functions of Oracle. It is used to get the sample variance of a set of numbers. The VAR_SAMP function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: VAR_SAMP ( expression ) Parameters: expression: It … Read more

VARIANCE is one of the vital Analytic functions of Oracle. It is used to get the variance of a set of numbers. The VARIANCE function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: VARIANCE ( expression ) Parameters: expression: It is … Read more

INSTR2 is one of the vital string/char functions of Oracle. It is used to get the location of a substring, where a substring is a part of a string. It works same as INSTR function with the only difference that it uses UCS2 code points. The INSTR2 function is supported in the various versions of … Read more

INSTR is one of the vital string/char functions of Oracle. It is used to get the location of a substring, where a substring is a part of a string. The INSTR function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: INSTR( … Read more

INNER Join is often called a SIMPLE Join as it is the simplest among all the kinds of joins and is also the most common one. When the join condition is met, the INNER Join returns all the rows from multiple tables. Syntax: SELECT expr_1, expr_2, … expr_n FROM table_1 INNER JOIN table_2 ON join_predicate; … Read more

INITCAP is one of the vital string/char functions of Oracle. It is used to set the first character in each word to UPPERCASE. The rest characters are set to lowercase. The INITCAP 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

HEXTORAW is one of the vital Conversion functions of Oracle. It is used to convert a hexadecimal value to a raw value. The HEXTORAW function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: HEXTORAW ( char ) Parameters: char: It is … Read more

GROUP_ID is an advanced function that the Oracle database supports. It is used to assign a number to each group resulting from a GROUP BY clause. The GROUP_ID function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i. Syntax: SELECT column1, column2, … column_n, GROUP_ID() … Read more

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