i want to know the difference between NUMBER and VARCHAR2 datatypes such that;
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?
which one execute fast?
i will be very thankfull for your kind help.