Term: DELETING

Definition:
In Oracle PL/SQL, the DELETING 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;

/

Form more information on using the DELETING keyword, please see the TRIGGER entry.