Term: INSERTING

Definition:
In Oracle PL/SQL, the INSERTING keyword is used in conjunction with the TRIGGER statement, as shown below.

Example Usage:

DECLARE

 vMsg VARCHAR2(30) := 'Statement Level Trigger Fired';

BEGIN

  IF INSERTING THEN

    dbms_output.put_line(vMsg || ' When Inserting');

  ELSIF UPDATING THEN

    dbms_output.put_line(vMsg || ' When Updating');

  ELSIF DELETING THEN

    dbms_output.put_line(vMsg || ' When Deleting');

  END IF;

END statement_level;

/

• Oracle Table Triggers

• Inserting into SELECT statement - You can use a select-statement within an INSERT statement to ins...