The following query can be used to find the current maximum length of data that is stored in any column, currently. UR is used just for performance.
select max (length(trim (my_column))) from my_table with UR
UR= Uncommitted Read
WITH UR can be specified only if the result table is read-only.
Originally posted 2008-07-15 17:47:10.