www.BPODigest.com i-Vortal

SQL Query to find table/column data

SELECT TABLE_NAME,COLUMN_NAME,DATA_LENGTH,DATA_TYPE

FROM ALL_TAB_COLUMNS

WHERE DATA_LENGTH > 4000

AND DATA_TYPE = 'VARCHAR2'

This table gives you all the detail information about any table and the columns of the table. To be more specific, you can restrict your search criteria for a specific schema, like you can add WHERE OWNER = 'RAMDHAN' in the following query.