1748180 Members
4182 Online
108759 Solutions
New Discussion юеВ

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 2
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