3 Replies Latest reply: Nov 6, 2012 1:24 AM by Marwim RSS

    Number vs Varchar2

    Maahjoor
      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.

      Regards