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.
Related examples in the same category