Re: select for tables?

Take a look at the Dynamic SQL section in the PL/SQL guide, with a special notice to the necessary syntax for table_name variables. It is very possible, because I do it on a regular basis, but it's not the simplest thing in the world.

Barth

Gregory Bloom wrote:

> Pie-eyed newbie question of the week:
>
> Is there a way to find all tables that have a particular column with a
> particular value?
> Something like "select tablename from * where customer_id='12345'" which,
> let's pretend, would give a list of all tables which have customer_id as a
> column and which satisfy customer_id='12345'.
>
> Is this possible? Or do we really have to know all the tables having
> customer_id and search each of them individually?
Received on Tue May 02 2000 - 00:00:00 CDT