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 lecturesnippets....

[@rafatmuizmahmud2698]

best explanations that I've seen. Plain and simple. Thanks.

[@theodorehagan8732]

This is one of the best explanations that I've seen. Plain and simple. Thanks.

[@fatimaanamkanok7632]

Yes, u r right

[@zephyrs5]

Elaborate and helpful. Thank you!

[@saiful021107]

thanks for your nice presentation

[@lukki7ster]

thanks! straight forward

[@XcodySyringe]

awesome!!! thanks man!!!

[@mohitnarvariya7961]

is there any shortcut to rum query by keyboard???????????

[@sergepuhoff6419]

thank you

[@mramkumardit]

same sql quary i am using but is show some error (invaild char) please help mew

[@kaka-tc4pp]

Good

[@ti_solution]

hyi....!!
have any Body Oracle Presentation in Power Point..>..>?????

[@ahmedmastor2363]

thanks

[@GodEmperorSuperStar]

Did you used to work as a librarian?

[@pratikshajadhav6086]

Not seeing properly its blur

[@wise4501]

unable to database login what shout i do

[@mehdi1875]

can we , show tables in oracle 10g , i mean real tables , like those in microsoft acces ?????

[@peacemekka]

If you want to display the table you can use " select * from table_name" without quotation marks. It should print the table in tabular form with all the borders and stuff. It will print coloumns in the order of creation though.

[@abiqan]

when i am typing VARCHAR, it shows an error...
ORA-00904: : invalid identifier
What should I do

[@pranathipalli2086]

Try varchar2

[@kazialhasan5988]

THANKS A LOT!!
BUT HAVING A PROBLEM!!
USED THE SAME CODE BUT IT SAYS---
"ORA-00907 MISSING RIGHT PARANTHESIS"
CAN U HELP!! PLEASE

[@minahzain8381]

Same😭

[@prernagarg2203]

@@minahzain8381 meri toh ho gyi problem solve out okk

[@prernagarg2203]

@@minahzain8381 dubara sai same to same banakar dekho koi error nhi ayegi meri toh nhi jbh mainai dubara karkai dekha same to same okk

[@cristophervega]

ORA-00902 it throw this error!

[@parthgandhi2550]

Delete

[@ankitsharma7545]

thanks