Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Dynamic table and column identifiers?
dd <dd.ss_at_ss.no> wrote in message
news:BS3S3.14790$7G2.96247_at_news1.online.no...
> I want to
>
> select count(*)
> from {all tables that have a column named my_special_column}
> where {the table's owner}=my_special_user
Using dynamic SQL, use a cursor to select table names... i.e.
CURSOR my_special_cur IS
SELECT table_name, column_name, owner
FROM all_tab_columns
WHERE column_name = 'MY_SPECIAL_COLUMN';
...then build up a string which you would parse and execute using DBMS_SQL.
> Also, I would like to
>
> select {n first columns}
> from {all tables that have a column named my_special_column}
> where {the table's owner}=my_special_user
> and my_special_column='my_special_value'
Similarly to above.
Using
> Can somebody please rewrite pseudo-parts into SQL or show me another way
to
> achieve this?
>
> Regards Dag
>
> STARTADDRESSdpedeATonlineDOTnoENDADDRESS
Received on Thu Oct 28 1999 - 18:47:29 CDT