Finding MAX length of the data in DB column

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.

[My Video Promotion]
Tagged , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.