Home » Developer & Programmer » Designer » Actual Space taken by Varchar2
Actual Space taken by Varchar2 [message #90518] Wed, 14 January 2004 10:27 Go to next message
cws
Messages: 2
Registered: January 2004
Junior Member
Will Oracle allocate the maximum size for a column (and blank fill) defined as varchar2. Or will each row only be allocated the space to support the actual number of characters entered into the varchar2 column ?
Re: Actual Space taken by Varchar2 [message #90519 is a reply to message #90518] Thu, 15 January 2004 08:04 Go to previous messageGo to next message
Michael Dinh
Messages: 7
Registered: January 2004
Junior Member
MDINH@test> desc t;
Name Null? Type
----------------------------------------- -------- ----------------------------
ID VARCHAR2(4000)

MDINH@test> select id, vsize(id) from t;

ID VSIZE(ID)
-------------------- ----------
a 1
ab 2
abcdefg 7

Only the acutual size used.
Why would you want to use VARCHAR2 to store number?
Re: Actual Space taken by Varchar2 [message #90524 is a reply to message #90519] Mon, 19 January 2004 08:57 Go to previous message
cws
Messages: 2
Registered: January 2004
Junior Member
Thanks Michael. Not sure where you got the idea I was planning on storing number in VARCHAR2. No plan to do this.
Previous Topic: Oracle 9i Designer - Journal Tables
Next Topic: function based indexes error in oracle 8.1.7
Goto Forum:
  


Current Time: Fri Sep 18 09:31:06 CDT 2020