Question

a. Write Data type and constraint for the above fields. b. Write SQL Command for inserting following data in the table. Book_ID Book_Name Product_Price B001 Physics 275.00 B002 Info Technology 395.00 B003 English 185.00 c. Write SQL command for displaying the Book the price of which is greater than 200.00 d. Write the SQL command for displaying the Book whose ID is “B003” e. Write the SQL command for displaying all records.

Answer 1

Answer:

a.) book_id varchar2(10) primary key

book_name varchar2(20) not null

book_price number(10) not null

Explanation:

b) insert into books values('B001', 'physics', 275.00);

insert into books values('B002', 'info technolgy', 395.00);

insert into books values('B003', 'english',185.00);

c) select book_name, book_price from books where book_price>200.00;