create table library(book_id number primary key,author_name varchar2(20),publisher varchar2(20),price number, collection varchar2(20));

insert into library values(1,'william','pearson',650,'4th');
insert into library values(2,'navathi','pearson',850,'3rd');
insert into library values(3,'baalguruswami','pearson',980,'6th');
insert into library values(4,'baalguruswami','tmh',550,'3rd');
insert into library values('5','punjit','tmh',430,'2nd');

select * from library