Friday, September 12, 2008
Find min, max value for similar columns across a shema
SELECT 'SELECT '''
|| table_name
|| ''', '''
|| column_name
|| ''', MIN(LENGTH('
|| column_name
|| ')) AS MIN, MAX(LENGTH('
|| column_name
|| ')) AS MAX FROM '
|| table_name
|| ' UNION ALL' AS "--QUERY"
FROM all_tab_cols
WHERE owner = 'OWNER' AND column_name LIKE 'COL%'
AND table_name NOT LIKE 'VIEW_%'
|| table_name
|| ''', '''
|| column_name
|| ''', MIN(LENGTH('
|| column_name
|| ')) AS MIN, MAX(LENGTH('
|| column_name
|| ')) AS MAX FROM '
|| table_name
|| ' UNION ALL' AS "--QUERY"
FROM all_tab_cols
WHERE owner = 'OWNER' AND column_name LIKE 'COL%'
AND table_name NOT LIKE 'VIEW_%'
# posted by DW Helpdesk : 8:02 AM
Subscribe to Posts [Atom]