ORACLE CURSOR In Oracle, there is a private SQL area which is used to store info about the processing of a SELECT or DML statement. A SELECT or DML statement can be an INSERT, UPDATE, DELETE, MERGE etc. A cursor is a pointer to this private SQL area. It can be understood as a mechanism … Read more

ORACLE BEFORE TRIGGER As the name itself suggests, before the INSERT, UPDATE or DELETE statement is issued, the Oracle database will fire this trigger, or in other words when an INSERT, UPDATE or DELETE statement is issued these triggers can be implicitly executed. On the basis of the Firing Point, it is named as the … Read more

ORACLE AFTER TRIGGER As the name itself suggests, AFTER the INSERT, UPDATE or DELETE statement is issued, the Oracle database will fire this trigger, or in other words when an INSERT, UPDATE or DELETE statement is issued these triggers can be implicitly executed. On the basis of the Firing Point, it is named as the … Read more

ROUND (numbers) is one of the vital Numeric/Math functions of Oracle. It is used to get a number rounded to a certain number of decimal places. The ROUND (numbers) function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: ROUND (number, decimal_places) … Read more

SEMI Join is used to return one copy of those rows from a table where at least one match is found in the values with the other mentioned table, and to serve this purpose, EXISTS construct is used instead of any JOIN keyword. The main advantage of this kind of Join query is that it … Read more

SIGN is one of the vital Numeric/Math functions of Oracle. It is used to get a value indicating the sign of a number. The SIGN function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: SIGN ( number ) Parameters: number: It … Read more

SIN is one of the vital Numeric/Math functions of Oracle. It is used to get the Sine of a number. The SIN function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: SIN ( number ) Parameters: number: It is used to … Read more

SINH is one of the vital Numeric/Math functions of Oracle. It is used to get the hyperbolic sine of a number. The SINH function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: SINH ( number ) Parameters: number: It is used … Read more

NTH_VALUE is one of the vital Analytic functions of Oracle. It is used to get a specific value in an ordered set of values from an analytic window. The NTH_VALUE function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c and Oracle 11g Release 2. Syntax: NTH_VALUE (measure_column, n) [FROM FIRST | … Read more

STDDEV is one of the vital Analytic functions of Oracle. It is used to get the standard deviation of a set of numbers. The STDDEV function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. It can be used both as an analytic … Read more