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

Oracle - SQL - Create Table

206 ratings | 49152 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 (25)
Rishabh varshney (1 month ago)
after the empid number, how we go to shift the line or change the line to add different content ?
Shomerful (2 months ago)
why cant u make smaller tables to get it running.... seedhe mahabharata chapke kya faeda
张翌庸 (4 months ago)
I need the auto-subtitles pls!
OsamaHD (4 months ago)
Good video, thank you for your great explanation and proper speaking!
sneha dubey (5 months ago)
from when did we start using " int" data type in oracle?
Abhiruchi Zope (1 day ago)
Same doubt
Rehana Farihal (8 months ago)
Hi sir can u pls give complete information regarding "types of datatypes " in sql
Prem Chand Yadav (8 months ago)
Thanks sir
Pristine Animation (10 months ago)
thank u sir
Govinda Moorthy (9 months ago)
Govinda Moorthy (9 months ago)
Any Java vacancy sir
Onkar Malawade (10 months ago)
How you should make columns.Enter 2 error comes
Biswajeet Behera (11 months ago)
Enter user-name: SYS Enter password: ERROR: ORA-12543: TNS:destination host unreachable
Prashant Rastogi (1 month ago)
Just remove the @ symbol from your password it will work fine
dilkash .786 (9 months ago)
after starting oracle services there is still a problem in entering password
La beaute du pagne (10 months ago)
I am having the same problem
BossySmaxx Hex (11 months ago)
whats the command to see my created table
EqualConnect Coach (9 months ago)
there are multiple ways one of the "desc table name" #equalConnectCoach
Dhananjay Panage (10 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 (1 year ago)
why we use a varchar2
EqualConnect Coach (9 months ago)
whenever we want to store long string in our database column then we user varchar2 #equalConnectCoach
Dhananjay Panage (10 months ago)
varchar supports 2000 characters where varchar2 supports 4000 character.
Dhananjay Panage (10 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 (11 months ago)
char supports only 255 characters where varchar2 supports 2000 characters, varchar used for another version of SQL such as MySql
Anadi Sharma (1 year 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.