Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create or replace trigger update_qty
- after update of boi_ordernum on bookorderitem
- begin
- update bookorderitem
- set boi_qty = 6
- where boi_qty > 1;
- end;
- select *
- from bookorderitem;
- update bookorderitem
- set boi_ordernum = 1425
- where boi_ordernum = 1111;
- select *
- from bookorderitem;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement