|
[oracle-l]
||
[Date Prev]
[07-2005 Date Index]
[Date Next]
||
[Thread Prev]
[07-2005 Thread Index]
[Thread Next]
RE: Finding LOB columsn
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <cemail_219@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 1 Jul 2005 15:09:50 -0400
How about:
select * from DBA_tab_columns
where data_type like '%LOB%'
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of J. Dex
Sent: Friday, July 01, 2005 3:07 PM
To: oracle-l@xxxxxxxxxxxxx
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
|
|
