Re: Help, SQL Problem!!!

Hi Valeri.

You can try to use dynamic SQL using the dbms_sql package. For example, you can create a procedure
and inside it with a loop you create the select for each table and parse/execute it using dbms_sql.

Hope this help you.

Albert Borrull
<aborrull_at_sgosoft.com>
SGO. Software, S.L.

Valerie St Esteve <val22.se_at_btinternet.com> escribió en artículo <35CF90B4.D1BECF6C_at_btinternet.com>...
> Hi
>
> I hope this doesn't seem like a silly question but I'm new to all this.
> Is there any way to dynamically alter the FROM part of a select
> statement either in SQL or PL/SQL.
>
> My requirement is this: I have to gather data from 52 tables all of
> which have an identical structure. They are only differentiated by their
> names. The first is called sales_00001, the next sales_00002 and so on.
> All the data has to be spooled into a single text file in one go.
> Apart from coding a query that has 52 selects all unioned together with
> hardcoded table names for each of the tables, is there any way of having
> a single select statement, say within some kind of loop that has its
> from part dynamically altered for each iteration of the loop. If so, how
> do I achieve this? I can't find out how it is done anywhere.
>
> Thanks in advance
>
> Val
>
>
Received on Tue Aug 11 1998 - 05:18:26 CDT