Re: need help with a query, please

Execute the below query and then, edit and execute lst_tab.sql. SPOOL LST_TAB.sql
[Quoted] [Quoted] select 'select orderid, tracenumber, username from '||table_name||

       ' where orderid = ''963262260741'';'    from all_tables where table_name like '%_transaction'; SPOOL OFF Good luck.

In article <39747826.9B158BFE_at_icoms.com>,   Joe Driscoll <joed_at_icoms.com> wrote:
>
> I have some 250 tables that have the same structure and I need to
 search
> each one for a specific entry. here is the query that I have to check
> just one table:
>
> select orderid, tracenumber, username
> from sp236_transaction
> where orderid = '963262260741'
>
> the sp236 is the only thing that changes in the table name and this
> query. Is there a way I can loop through all 250 tables?
>
> TIA
>
> Joe
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jul 18 2000 - 00:00:00 CEST