DIFFERENCE BETWEEN CHAR AND VARCHAR2 DATATYPE IN ORACLE SQL

Опубликовано: 24 Январь 2025
на канале: Kishan Mashru
7,785
69

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 :    • UNION AND UNION ALL SET OPERATOR IN O...  
replace and translate :    • Replace and Translate in sql  
procedure and function :    • Difference between Procedure and Func...  
in and exists :    • IN VS EXISTS VS JOIN, performance  
rank and dense_rank :    • Row Number, Rank and Dense Rank in sq...  
delete and truncate :    • Difference between Delete and Truncat...  
%type and %rowtype :    • type and rowtype PL/SQL | difference ...  

Subscribe to the channel :    / @kishanmashru  

Other Playlists:
Data Warehousing Concepts:    • Data Warehousing Concepts  

Python and Database:    • Python | How to Install python packages  

SQL and PL/SQL Interview Questions:    • SQL AND PL/SQL INTERVIEW QUESTIONS  

SQL and PL/SQL concepts:    • SQL and PLSQL  

Content and video created by : Kishan Mashru