How to determine the biggest float value (in terms of used bytes) with SQL in Oracle


I would like to know how to check out what is the biggest float value in terms of used bytes in a specific column.

Oracle DB Version is 10.2.

Best Answer


VSIZE returns the number of bytes in the internal representation of expr.

select max(vsize(mycolumn)) from mytable;