Skip to Main Content
Forums

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!

Number vs Varchar2

MaahjoorNov 6 2012 — edited Nov 6 2012
Dear all,

i want to know the difference between NUMBER and VARCHAR2 datatypes such that;

storage difference:
if we store 'Alaska' in varcahar2(100) field, it will not occupy 100 byte of storage, just the length of 'alaska' will be occupy.

if we store 245 in number(10) field, will it be like varchar2? only space occupy by 245 will be taken or all the storage space for number(10) will be occupied?

Performance difference:
which one execute fast?

i will be very thankfull for your kind help.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 4 2012
Added on Nov 6 2012
#oracle, #sql
12 comments
9,089 views