By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
dbms_output:
Book 1:
TITLE: First book
AUTHOR: Me
SUBJECT: Simple Ones
BOOK_ID: 94321
FIRST_PUBLISHED: 1970-01-01 00:00:00
Book 2:
TITLE: Second book
AUTHOR: You
SUBJECT: Intermediate Ones
BOOK_ID: 55555
FIRST_PUBLISHED: 2020-01-01 00:00:00
Book 3:
TITLE: Third book
AUTHOR:
SUBJECT: Advanced Ones
BOOK_ID: 77777
FIRST_PUBLISHED: 2099-12-31 23:59:59