1

Topic: Dynamic from different tables

Good afternoon, prompt please.
Is at me tab1, tab2. tabn, from them it is necessary to receive columns comprising for example %date %.
As on one to make I understand, in a cycle to transfer tables, to receive from dba_tab_columns the necessary fields in an array and then from a title to concatenate for dynamic .
And as though as a result one request with UNION to receive, that on the basis of its finite structure to generate a cap and to fill sheet Excel.

2

Re: Dynamic from different tables

leprechaun;
Not at once it is visible that is required. Can eat an example for descriptive reasons?

3

Re: Dynamic from different tables

leprechaun wrote:

to receive from dba_tab_columns the necessary fields in an array

4

Re: Dynamic from different tables

leprechaun;
If in one table 10 of fields %date % in second two - as you has to look union?

5

Re: Dynamic from different tables

Well tables + / - are similar, distinctions I will be in several fields.
Type such as a result to have, at first it is dynamic received it is admissible 3 arrays with names of columns, and then somehow it to arrange and interpose null values
1,2, null, null, null
union
null, null, 3, 4, null
union
null, 2, 3, null, null
Well it is possible probably on one  to go, only then not transparently what value in what column Excel falls. Total Union would be better

6

Re: Dynamic from different tables

leprechaun;
Then make the own reference manual of columns