RE: Finding LOB columsn

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Fri, 1 Jul 2005 15:09:50 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF16E77E@EXCNYSM0A1AJ.nysemail.nyenet>

How about:

select * from DBA_tab_columns
where data_type like '%LOB%'

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of J. Dex Sent: Friday, July 01, 2005 3:07 PM
To: oracle-l_at_freelists.org
Subject: Finding LOB columsn

Is there an easy way to find all of the tables in the database that have LOB
columns regardless of who owns them?

---

Don't just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Fri Jul 01 2005 - 15:15:18 CDT