ORACLE DISABLE TRIGGER As the name itself suggests, this type of trigger is used to disable an already existing or newly created trigger for a table from the database. To serve this purpose ALTER TRIGGER statement is used. Syntax: ALTER TRIGGER trigger_name DISABLE; Parameters: trigger_name: It is used to specify the name of the trigger … Read more
ORACLE DELETE To remove or delete a single record or multiple records from a table, Oracle DELETE statement is used. Syntax: To delete all rows from a table. DELETE FROM table_name Syntax: To delete specific rows from a table. DELETE FROM table_name WHERE conditions; Parameters: table_name: It is used to specify the name of the … Read more
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