Your Ad Here

advanced code snippet search

Posted By

indianocean on 05/05/08


Tagged

sql Oracle PLSQL sp


Versions (?)

Simple Oracle Trigger

 / Published in: SQL
 
Expand | Embed | Plain Text 
  1. CREATE OR REPLACE
  2. TRIGGER T_INSERT_REGION
  3.  AFTER INSERT ON LOCATION 
  4. FOR EACH ROW 
  5. DECLARE
  6.   new_region varchar2(200);
  7.   has_region number;
  8. BEGIN
  9.   new_region := :new.region;
  10.  
  11.   SELECT count(*) INTO has_region FROM lu_region WHERE region = new_region;
  12.  
  13.   IF (has_region = 0) then
  14.     INSERT INTO lu_region (region) VALUES (new_region);
  15.   end IF;
  16. END;

Report this snippet  

You need to login to post a comment.