Varchar | Varinder Sandhu

SQL – Char vs. Varchar

Varinder Sandhu Oracle, Oracle-Tips and Tricks, Varinder Sandhu

Memory allocation is static for char data type variables but in case of varchar memory allocation is dynamic. This is the basic difference between char and varchar. Example create table test1 ( name1 char(10), name2 varchar(10) ); Insert into test1 values ('Varinder','Varinder'); select * from test1; I hope this will

» Read more

Char, difference between char and varchar, SQL, Varchar