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.