Originally posted by noor
Hello,

You can use the "vsize" fonction to have the number of bytes in the internal representation of your field.

try this : select vsize(sysdate) from dual;
Which will return you 8 instead of 7 (Oracle uses 7 bytes for storing dates)! We have just recently had two long threads about this isue in DBA forum...