Advertisement
Guest User

Untitled

a guest
May 29th, 2016
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. DELETE FROM k_rent_books
  2. WHERE reader_id not in(select reader_id
  3. from k_reader where months_between(sysdate,valid_until) > 120);
  4.  
  5. SELECT * INTO pom FROM k_reader
  6. where months_between(sysdate,valid_until) > 120);
  7.  
  8. DELETE FROM k_reader
  9. where months_between(sysdate,valid_until) > 120);
  10.  
  11. DELETE FROM k_person
  12. where person_id in (select person_id from pom);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement