| Actual Space taken by Varchar2 [message #90518] |
Wed, 14 January 2004 10:27  |
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  |
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?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
