Quick Search:
 
 The Oracle INSERTING Keyword      [Return To Index] Jump to:  

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;
/


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

Related Links:

Related Code Snippets:
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org