cancel
Showing results for 
Search instead for 
Did you mean: 

Finding LONG Datatypes

SOLVED
Go to solution
Scott Buckingham
Regular Advisor

Finding LONG Datatypes

I would like to identify all the tables within our database that contain the LONG datatype. Which table or view, if any, would be best to use?
Long time dabbler, first time Admin / DBA
2 REPLIES
A. Clay Stephenson
Acclaimed Contributor
Solution

Re: Finding LONG Datatypes

Hi Scott:

How about

select table_name, column_name from all_tab_columns where data_type = 'LONG';

If it ain't broke, I can fix that.
Scott Buckingham
Regular Advisor

Re: Finding LONG Datatypes

Perfect! Thank you!
Long time dabbler, first time Admin / DBA