RE: Get max length of data for a column

>> 'select '''||table_name||'.'||column_name||''', max(length('||column_name||'))

Limitation on the combined dynamic idea: there is a maximum size text you can pass through to execute immediate and a lot of columns combined could easily exceed that size.

Roger S.


________________________________
This communication, including any attached documentation, is intended only for the person or entity to which it is addressed, and may contain confidential, personal and/or privileged information. Any unauthorized disclosure, copying, or taking action on the contents is strictly prohibited. If you have received this message in error, please contact us immediately so we may correct our records. Please then delete or destroy the original transmission and any subsequent reply.