Guest User

Untitled

a guest
May 23rd, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.22 KB | None | 0 0
  1. CREATE OR REPLACE TRIGGER TRG_INCRE_ENRL_NUM
  2. BEFORE INSERT ON ENROLLMENT
  3. DECLARE
  4. TOTAL NUMBER(4,0);
  5. BEGIN
  6. -- check if CURR_ENRL < MAX_ENRL
  7. -- if yes, continue with inserting into enrollment,
  8. -- if not, fire up error
  9. END;
Add Comment
Please, Sign In to add comment