HomeОбразованиеRelated VideosMore From: Tutorials Point (India) Pvt. Ltd.

Oracle - SQL - Create Table

65 ratings | 16204 views
Oracle - SQL - Create Table Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
Html code for embedding videos on your blog
Text Comments (18)
Rehana Farihal (2 days ago)
Hi sir can u pls give complete information regarding "types of datatypes " in sql
indian talent (3 days ago)
Thanks sir
Pristine Animation (1 month ago)
thank u sir
Govinda Moorthy (1 month ago)
Govinda Moorthy (1 month ago)
Any Java vacancy sir
Onkar Malawade (2 months ago)
How you should make columns.Enter 2 error comes
Biswajeet Behera (2 months ago)
Enter user-name: SYS Enter password: ERROR: ORA-12543: TNS:destination host unreachable
dilkash .786 (27 days ago)
after starting oracle services there is still a problem in entering password
La beaute du pagne (2 months ago)
I am having the same problem
BossySmaxx Hex (3 months ago)
whats the command to see my created table
EqualConnect Coach (1 month ago)
there are multiple ways one of the "desc table name" #equalConnectCoach
Dhananjay Panage (2 months ago)
WRITE: SELECT * FROM tabs; It will show you all the tables from the data base (system created and also user created). If you see a dollar ($) sign in a table name then its a system table else it's created by the user.
Aakriti Saxena (4 months ago)
why we use a varchar2
EqualConnect Coach (1 month ago)
whenever we want to store long string in our database column then we user varchar2 #equalConnectCoach
Dhananjay Panage (2 months ago)
varchar supports 2000 characters where varchar2 supports 4000 character.
Dhananjay Panage (2 months ago)
If you look deep into it, it is for saving memory. If you write varchar(30) and entered just 10 character all the remaining character will be set as NULL characters it will not be deleted or freed. On the other hand, if you declare varchar2(30) and entered just 10 characters all the remaining characters will be deleted or freed.
BossySmaxx Hex (3 months ago)
char supports only 255 characters where varchar2 supports 2000 characters, varchar used for another version of SQL such as MySql
Anadi Sharma (4 months ago)
There's no difference between varchar and varchar2. It's just in oracle there's a versioning in varchar2.

Would you like to comment?

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