SQL with Oracle 10g XE - Using CREATE TABLE to Build a Table

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 https://ift.tt/LDlJ64.
via Youtube at https://youtu.be/M0p62V6mIog

from Scholars Globe https://ift.tt/2QspCUK
via IFTTT

• Twitter
• Facebook
• Google
• Tumblr
• Pinterest