Re: Want to know size in bytes taken by each dataType Oracle supports.
Does Vsize(..) function return the actual bytes used for storage internally by oracle.
For eg. for column 'id' of type 'NUMBER', for following values, vsize(..) returns variable result.
Does this mean that NUMBER type data is also stored internally as per the actual size like varchar
or there will be some fix storage area assigned for NUMBER internally.
Originally posted by andrewst
Use the VSIZE function: