Can I Query which tables have columns with a CLOB data type? 1

[Giddygoat]

Hi

I need to know which of the tables in my database have CLOB columns.
Any ideas anyone?

Thanks

John

 

[spenglerr]

Try

SELECT DISTINCT table_name
FROM user_tab_columns
WHERE data_type = 'CLOB';

That will give you the results.

 

[Giddygoat]

Great stuff.

Thanks

John