PRAGMA foreign_keys = ON;
CREATE TABLE AUTHOR (
AUTHOR_ID NUMBER(5) PRIMARY KEY,
AUTHOR_NAME VARCHAR2(18)
);
INSERT INTO AUTHOR (AUTHOR_ID, AUTHOR_NAME) VALUES (1234, 'MC GRAW HILL');
INSERT INTO AUTHOR (AUTHOR_ID, AUTHOR_NAME) VALUES (1235, 'J K ROLLING');
INSERT INTO AUTHOR (AUTHOR_ID, AUTHOR_NAME) VALUES (1236, 'WILLAM');
INSERT INTO AUTHOR (AUTHOR_ID, AUTHOR_NAME) VALUES (1237, 'SHAKESPEAR');
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 (10003, 'TO BE OR NOT TO BE', 1237);
INSERT INTO BOOK (BOOK_ID, BOOK_NAME, AUTHOR_ID)
VALUES (10004, 'PROJECT MANAGEMENT', 1234);
DELETE FROM AUTHOR WHERE AUTHOR_ID = 1234;
Select * from book ;
Select * from author ;
UFJBR01BIGZvcmVpZ25fa2V5cyA9IE9OOwoKQ1JFQVRFIFRBQkxFIEFVVEhPUiAoCkFVVEhPUl9JRCBOVU1CRVIoNSkgUFJJTUFSWSBLRVksCkFVVEhPUl9OQU1FIFZBUkNIQVIyKDE4KQopOwoKSU5TRVJUIElOVE8gQVVUSE9SIChBVVRIT1JfSUQsIEFVVEhPUl9OQU1FKSBWQUxVRVMgKDEyMzQsICdNQyBHUkFXIEhJTEwnKTsKSU5TRVJUIElOVE8gQVVUSE9SIChBVVRIT1JfSUQsIEFVVEhPUl9OQU1FKSBWQUxVRVMgKDEyMzUsICdKIEsgUk9MTElORycpOyAgICAKSU5TRVJUIElOVE8gQVVUSE9SIChBVVRIT1JfSUQsIEFVVEhPUl9OQU1FKSBWQUxVRVMgKDEyMzYsICdXSUxMQU0nKTsKSU5TRVJUIElOVE8gQVVUSE9SIChBVVRIT1JfSUQsIEFVVEhPUl9OQU1FKSBWQUxVRVMgKDEyMzcsICdTSEFLRVNQRUFSJyk7CgpDUkVBVEUgVEFCTEUgQk9PSyAKKApCT09LX0lEIE5VTUJFUig1KSBQUklNQVJZIEtFWSwKQk9PS19OQU1FIFZBUkNIQVIyKDE1KSwKQVVUSE9SX0lEIE5VTUJFUig1KSwKQ09OU1RSQUlOVCBhdXRob3JfZmsKRk9SRUlHTiBLRVkgKEFVVEhPUl9JRCkgUkVGRVJFTkNFUyBBVVRIT1IoQVVUSE9SX0lEKQpPTiBERUxFVEUgQ0FTQ0FERQopOwoKSU5TRVJUIElOVE8gQk9PSyAoQk9PS19JRCwgQk9PS19OQU1FLCBBVVRIT1JfSUQpIAogICAgVkFMVUVTICgxMDAwMSwgJ1NPRlRXQVJFIERFVkVMT1BFTUVOVCcsIDEyMzQpOwpJTlNFUlQgSU5UTyBCT09LIChCT09LX0lELCBCT09LX05BTUUsIEFVVEhPUl9JRCkgCiAgICBWQUxVRVMgKDEwMDAyLCAnSEFSUlkgUE9UVEVSJywgMTIzNSk7CklOU0VSVCBJTlRPIEJPT0sgKEJPT0tfSUQsIEJPT0tfTkFNRSwgQVVUSE9SX0lEKSAKICAgIFZBTFVFUyAoMTAwMDMsICdUTyBCRSBPUiBOT1QgVE8gQkUnLCAxMjM3KTsKSU5TRVJUIElOVE8gQk9PSyAoQk9PS19JRCwgQk9PS19OQU1FLCBBVVRIT1JfSUQpIAogICAgVkFMVUVTICgxMDAwNCwgJ1BST0pFQ1QgTUFOQUdFTUVOVCcsIDEyMzQpOwoKREVMRVRFIEZST00gQVVUSE9SIFdIRVJFIEFVVEhPUl9JRCA9IDEyMzQ7CgpTZWxlY3QgKiBmcm9tIGJvb2sgOwoKU2VsZWN0ICogZnJvbSBhdXRob3IgOw==