HomeОбразованиеRelated VideosMore From: Lecture Snippets

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

180 ratings | 101356 views
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.
Html code for embedding videos on your blog
Text Comments (19)
yaswanth kumar (2 months ago)
i am getting "ORA-00911: invalid character"; what to do
Serge Puhoff (1 year ago)
thank you
Metta Crawler (2 years ago)
Did you used to work as a librarian?
Rafat Muiz Mahmud (2 years ago)
best explanations that I've seen. Plain and simple. Thanks.
Theodore Hagan (2 years ago)
This is one of the best explanations that I've seen. Plain and simple. Thanks.
L Thommas (3 years ago)
thanks! straight forward
Saiful Islam (3 years ago)
thanks for your nice presentation
mehdi 20 (4 years ago)
can we , show tables in oracle 10g , i mean real tables , like those in microsoft acces ?????
Waqar YousufZai (4 years ago)
hyi....!! have any Body Oracle Presentation in Power Point..>..>?????
Shane McGrath (4 years ago)
when i am typing VARCHAR, it shows an error... ORA-00904: : invalid identifier What should I do
Ankit Sharma (5 years ago)
thanks
ahmed mastor (5 years ago)
thanks
Avril Lavigne (5 years ago)
Awkward moment when you watch so many IT-related instructional videos that you can recognize this guy's voice...
Abdul Rauf (5 years ago)
lov u man its awesome
Kazi Al Hasan (5 years ago)
THANKS A LOT!! BUT HAVING A PROBLEM!! USED THE SAME CODE BUT IT SAYS--- "ORA-00907 MISSING RIGHT PARANTHESIS" CAN U HELP!! PLEASE
Xcody Toribio (6 years ago)
awesome!!! thanks man!!!
cristopher vega (6 years ago)
ORA-00902 it throw this error!
Mram Kumar (6 years ago)
same sql quary i am using but is show some error (invaild char) please help mew
Zep (6 years ago)
Elaborate and helpful. Thank you!

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.