Re: Search in all Tables in Oracle 8i

From: Andrew Simkovsky <asimkovsky_at_email.msn.com>
Date: Tue, 17 Apr 2001 14:51:55 -0400
Message-ID: <#3JMi52xAHA.352@cpmsnbbsa07>

SELECT table_name, column_name
FROM dba_tab_columns
WHERE column name like 'foo%'

Andrew Simkovsky
OCP DBA
www.auctionworks.com

"Kai Niebergall" <kniebergall_at_heiler.com> wrote in message news:3adbf55f$0$511$4dbef881_at_businessnews.de.uu.net...
> Hello,
>
> I'm needing your Help. I've to search all tables in the DB for an entry
> (something like: "find all collumns containing 'foo'"). Is there any
> possibility to do that without make for each table an sql query?
>
>
>
> Thanks
>
>
>
> Kai
>
>
Received on Tue Apr 17 2001 - 13:51:55 CDT