Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DELETE FROM k_rent_books
- WHERE reader_id not in(select reader_id
- from k_reader where months_between(sysdate,valid_until) > 120);
- SELECT * INTO pom FROM k_reader
- where months_between(sysdate,valid_until) > 120);
- DELETE FROM k_reader
- where months_between(sysdate,valid_until) > 120);
- DELETE FROM k_person
- where person_id in (select person_id from pom);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement