Advertisement
Guest User

Untitled

a guest
Jan 17th, 2019
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. CODE:
  2. drop trigger Validation_volunteer;
  3. create or replace trigger Validation_volunteer
  4. before insert on v_project for each row
  5. declare
  6. v_count number;
  7. begin
  8. select count(v_id)
  9. into v_count
  10. from v_project
  11. where pro_id = :new.pro_id;
  12.  
  13.  
  14. if (v_count > 50) then
  15. raise_application_error(-20000, 'ERROR!! Validation is for inserting the number of volunteers , which will be 50');
  16. end if;
  17. end;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement