book.sql

set serveroutput on;

create table book(accno number primary key,
    title varchar(30),
    author varchar(30),
    publisher varchar(30),
    edition_ varchar(20),
    no_of_copies number);

create or replace trigger book_modified
    after insert or update or delete
    on book 
    declare
    nos number;
    begin
        select count(*) into nos from book;
        dbms_output.put_line('modified>>> Tuple count['||nos||']');
    end;
/

begin
   INSERT INTO book VALUES (112, 'Introduction to Algorithms', 
   'Thomas H. Cormen', 'MIT Press', '3/E', 10);
    INSERT INTO book VALUES (113, 'Operating Systems: 
    Three Easy Pieces', 'Remzi H. Arpaci-Dusseau', 'Arpaci-Dusseau', '1/E', 15);
    INSERT INTO book VALUES (114, 'Database Management Systems', 
    'Raghu Ramkrishnan', 'McGraw Hill', '2/E', 8);
    update book set no_of_copies=20 where accno=112;
    delete from book where accno=114;
    delete from book;
    commit;
end;
/
    
drop table book;