PRAGMA foreign_keys = ON;
 
START TRANSACTION ;
CREATE TABLE AUTHOR (
AUTHOR_ID NUMBER(5) PRIMARY KEY,
AUTHOR_NAME VARCHAR2(18)
) ;
 
 
---------------------------------
CREATE TABLE BOOK 
(
BOOK_ID NUMBER(5) PRIMARY KEY,
BOOK_NAME VARCHAR2(15),
AUTHOR_ID NUMBER(5),
CONSTRAINT author_fk
FOREIGN KEY (AUTHOR_ID) REFERENCES AUTHOR(AUTHOR_ID)
ON DELETE CASCADE
) ;
 
INSERT INTO BOOK (BOOK_ID, BOOK_NAME, AUTHOR_ID) 
    VALUES (10001, 'SOFTWARE DEVELOPEMENT', 1234);
INSERT INTO BOOK (BOOK_ID, BOOK_NAME, AUTHOR_ID) 
    VALUES (10002, 'HARRY POTTER', 1235);
INSERT INTO BOOK (BOOK_ID, BOOK_NAME, AUTHOR_ID) 
    VALUES (10004, 'PROJECT MANAGEMENT', 1234);
 
COMMIT ;
 
 
select b.*, a.* 
from book b left join author a on a.author_id = b.author_id ;
 

UFJBR01BIGZvcmVpZ25fa2V5cyA9IE9OOwoKU1RBUlQgVFJBTlNBQ1RJT04gOwpDUkVBVEUgVEFCTEUgQVVUSE9SICgKQVVUSE9SX0lEIE5VTUJFUig1KSBQUklNQVJZIEtFWSwKQVVUSE9SX05BTUUgVkFSQ0hBUjIoMTgpCikgOwoKCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQpDUkVBVEUgVEFCTEUgQk9PSyAKKApCT09LX0lEIE5VTUJFUig1KSBQUklNQVJZIEtFWSwKQk9PS19OQU1FIFZBUkNIQVIyKDE1KSwKQVVUSE9SX0lEIE5VTUJFUig1KSwKQ09OU1RSQUlOVCBhdXRob3JfZmsKRk9SRUlHTiBLRVkgKEFVVEhPUl9JRCkgUkVGRVJFTkNFUyBBVVRIT1IoQVVUSE9SX0lEKQpPTiBERUxFVEUgQ0FTQ0FERQopIDsKCklOU0VSVCBJTlRPIEJPT0sgKEJPT0tfSUQsIEJPT0tfTkFNRSwgQVVUSE9SX0lEKSAKICAgIFZBTFVFUyAoMTAwMDEsICdTT0ZUV0FSRSBERVZFTE9QRU1FTlQnLCAxMjM0KTsKSU5TRVJUIElOVE8gQk9PSyAoQk9PS19JRCwgQk9PS19OQU1FLCBBVVRIT1JfSUQpIAogICAgVkFMVUVTICgxMDAwMiwgJ0hBUlJZIFBPVFRFUicsIDEyMzUpOwpJTlNFUlQgSU5UTyBCT09LIChCT09LX0lELCBCT09LX05BTUUsIEFVVEhPUl9JRCkgCiAgICBWQUxVRVMgKDEwMDA0LCAnUFJPSkVDVCBNQU5BR0VNRU5UJywgMTIzNCk7CiAgICAKQ09NTUlUIDsKCgpzZWxlY3QgYi4qLCBhLiogCmZyb20gYm9vayBiIGxlZnQgam9pbiBhdXRob3IgYSBvbiBhLmF1dGhvcl9pZCA9IGIuYXV0aG9yX2lkIDsK