Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE TRIGGER TRG_INCRE_ENRL_NUM
- BEFORE INSERT ON ENROLLMENT
- DECLARE
- TOTAL NUMBER(4,0);
- BEGIN
- -- check if CURR_ENRL < MAX_ENRL
- -- if yes, continue with inserting into enrollment,
- -- if not, fire up error
- END;
Add Comment
Please, Sign In to add comment