Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Who is wasting space ??? Char or Varchar2??

AK111Sep 20 2006 — edited Sep 20 2006
if I have a following :-

create table tchar(text1 char(10), text2 varchar2(10))
insert into tchar values('ABC','EFG')

In this case, I am saving string with 3 characters. According to table structure, who is wasting space??

Please reply.

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 18 2006
Added on Sep 20 2006
15 comments
1,583 views