USER is an advanced function that the Oracle database supports. It is used to get the user_id from the current Oracle session. The USER function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: USER Example: SELECT USER INTO test_user_id FROM dual;SELECT … Read more
VAR_POP is one of the vital Analytic functions of Oracle. It is used to get the population variance of a set of numbers. The VAR_POP 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_POP ( expression ) Parameters: expression: It … Read more
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