HomeОбразованиеRelated VideosMore From: Kishan Mashru

DIFFERENCE BETWEEN CHAR AND VARCHAR2 DATATYPE IN ORACLE SQL

25 ratings | 3173 views
This video tutorial explains the difference between similar looking and used char datatype and varchar2 datatypes with an simple example. This video will answer the question such as how is the data internally stored differently for char and vacchar2 datatype. Also why is varchar2 much better option to be used than char data type is explained. If you want more such videos of exciting and amazing 'difference between' concepts, check out the links below : union and union all : https://youtu.be/n9FqQOd8liY replace and translate : https://youtu.be/HKYF77BGzOE procedure and function : https://youtu.be/q3LmOenL120 in and exists : https://youtu.be/REX4IjRYlFw rank and dense_rank : https://youtu.be/WGSX998hZ9M delete and truncate : https://youtu.be/u76wMm2byXo %type and %rowtype : https://youtu.be/MlLUFeZ_3eM
Html code for embedding videos on your blog
Text Comments (15)
Google engineer (27 days ago)
Thank you sir :) easy way to understand
Alwin J (1 year ago)
Thank you
Kishan Mashru (1 year ago)
Welcome!!! Hope you have liked the video and subscribed to our channel!!!
Subrata Kumer Paul (1 year ago)
Thanks brother >>
Subrata Kumer Paul (1 year ago)
ok
Kishan Mashru (1 year ago)
Welcome bro, hope you have liked the video and subscribed to our channel.
Vinayak Vemula (1 year ago)
thank you kishan your video helped me to understand diff betn VARCHAR2 &CHAR PLS can u provide your email id i have some doubts about oracle i am a student of oracle class
Kishan Mashru (1 year ago)
sure, you can reach me on [email protected]
Dogs Are the Best (1 year ago)
I used the same test but it didn't work for me.  The value returned was equal to the number of characters inserted when I used char or vchar.  I'm using SQL Server Studio.  Does this matter?
Kishan Mashru (1 year ago)
Yes Michael, Microsoft SQL Server and Oracle are much different from each other, the database I used for this video is Oracle 11g.
RTR KINGS (2 years ago)
very useful
Kishan Mashru (2 years ago)
Thanks!!! I am glad you enjoyed it!!!
Balaji onceagain (2 years ago)
thanks for the video Sir. Nice explanation. What is the difference between Varchar and Varchar2 data type it is same like Char and Varchar2 ?
Balaji onceagain (2 years ago)
+Kishan Mashru thanks sir .. for the explanation
Kishan Mashru (2 years ago)
varchar datatype does not exist as of now :) !!! Varchar2 datatype is ANSI standard defined, and it seems oracle has kept varchar reserved and may or may not introduce it in future!!!

Would you like to comment?

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