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

oracleoracle-10goracle-10g-r2

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

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

select max(vsize(mycolumn)) from mytable;