Oracle Database Discussions

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!

VARCHAR2 and it's actual storage

394745Feb 19 2004 — edited Feb 19 2004

Easy Question. For columns defined in Oracle as VARCHAR2 ... does Oracle only store the actual value or does it reserve space equal to definition?

Example: Column STR is VARCHAR2(10)
if I do an insert with STR='1' ... does oracle allocate space for just the '1' or does it allocate space in the database for potential 10?

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 18 2004

Added on Feb 19 2004

#general-database-discussions

4 comments

735 views