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!

Size of Varchar2

Eslam_ElbyalyApr 16 2014 — edited Apr 16 2014

hi all ,

is there any diff between declaring a varchar2 variable of size (1000) and declaring it with size (9)

i am talking about the performance , or anything else .

i know that it is variable size , so , the memory allocates space as per the value stored in the variable , right ?

so , i think there is no diff ?

thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 14 2014
Added on Apr 16 2014
4 comments
1,055 views