SQL with Oracle 10g XE - Using CREATE TABLE to Build a Table
In this video I use the CREATE TABLE command to create three tables: Books, Publisher, and Author. I use these three tables as sample data. The code I entered in is:
CREATE TABLE BOOK
(
BOOK_ID VARCHAR(4) PRIMARY KEY,
ISBN_10 VARCHAR(10),
ISBN_13 VARCHAR(13),
TITLE VARCHAR(50),
CATEGORY VARCHAR(15),
PRICE DECIMAL(6,2),
BINDING VARCHAR(1),
PUB_DATE VARCHAR(4),
AUTHOR_ID SMALLINT,
PUBLISHER_ID SMALLINT
);
CREATE TABLE PUBLISHER
(
PUBLISHER_ID SMALLINT PRIMARY KEY,
PUBLISHER_NAME VARCHAR(40)
);
CREATE TABLE AUTHOR
(
AUTHOR_ID SMALLINT PRIMARY KEY,
AUTHOR_LAST VARCHAR(25),
AUTHOR_FIRST VARCHAR(20)
);
I have to create each table individually in the SQL commands window.
This video is part of a series of videos with the purpose of learning the SQL language. For more information visit Lecture Snippets at http://lecturesnippets.com.