|
-
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
J Gangadhar
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|