Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: need help with a query, please
Why don't you UNION the tables if they all have the same structure. You could do it with a VIEW and that would make your select statement look exactly like the one you already wrote below. Mike
"Joe Driscoll" <joed_at_icoms.com> wrote in message
news:39747826.9B158BFE_at_icoms.com...
>
> 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
>
Received on Wed Jul 19 2000 - 00:00:00 CDT