diff b/n char and varcha2
Hi,
Could any one briefly explain me what is the diff b/n char and varchar2 everyone says char is fixed length varchar2 is valiable length i need meore explanation.
sql>create table a(name vachar2(20),grade char(3));
table created;
Explain me how the memory is allocated/used for the above columns
sql>insert into a values('Ganga','A');
one row created;
Though i have declared varchar2(10),char(3) entered only 5 char(string) name and one char grade . Now how the memory is used for above one row insertion.
Tks in advance
Gangu