Mega Code Archive

 

Categories / Oracle PLSQL / Table

 

A create-table statement with the attributes of ISBN, title, author, and publisher The primary key is the ISBN attribute

SQL> SQL>   CREATE TABLE Book   2    (isbn      VARCHAR2(10)  NOT NULL,   3     title     VARCHAR2(100),   4     author    VARCHAR2(100),   5     publisher VARCHAR2(50),   6     PRIMARY KEY (isbn)); Table created. SQL> SQL>  drop table book; Table dropped.