Advertisement
Guest User

Untitled

a guest
Aug 19th, 2017
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. create or replace trigger update_qty
  2. after update of boi_ordernum on bookorderitem
  3. begin
  4. update bookorderitem
  5. set boi_qty = 6
  6. where boi_qty > 1;
  7. end;
  8.  
  9. select *
  10. from bookorderitem;
  11.  
  12. update bookorderitem
  13. set boi_ordernum = 1425
  14. where boi_ordernum = 1111;
  15.  
  16. select *
  17. from bookorderitem;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement