Question

Create table BOOK

BOOK ID Char (4)

Bname Varchar (15)

Author Varchar (20)

Price Decimal

Answer 1

create table book (BOOK ID char (4),Bname varchar (15),Author varchar (20),Price decimal);

Answer 2

Answer :-

Create table is use to define a table in oracle.

CREATE TABLE BOOK (

   BookId char (4) NOT NULL ,

   Bname Varchar (15),

   Author Varchar (20)),

   Price Number (5,2)

CONSTRAINT book_pk PRIMARY KEY (BookId)

);

In the above example BookId has a NOT NULL constraint. Also BookId is the primary key assuming it will be unique for each book.