Term: UPDATING

Definition:
In Oracle PL/SQL, the UPDATING 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 UPDATING keyword, please see the TRIGGER entry.