HPE Community
Operating System - HP-UX
1835307 Members
2238 Online
110078 Solutions
New Discussion

Re: Finding LONG Datatypes

 
SOLVED
Go to solution
Scott Buckingham
Regular Advisor

‎01-09-2002 12:55 PM

‎01-09-2002 12:55 PM

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
0 Kudos
Reply
2 REPLIES 2
A. Clay Stephenson
Acclaimed Contributor

‎01-09-2002 01:12 PM

‎01-09-2002 01:12 PM

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.
Reply
Scott Buckingham
Regular Advisor

‎01-09-2002 01:17 PM

‎01-09-2002 01:17 PM

Re: Finding LONG Datatypes

Perfect! Thank you!
Long time dabbler, first time Admin / DBA
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.