G
Guest
Hi, I have 50 files that i have read in to 50 tables from an external
location --
They are all of the same following structure
TABLENAME_YYYMMDD_HHMNSS
column1 Date ,column2 Date ,column3 TEXT ,column4 LONG ,column5 LONG
,column6 LONG
The question is
I would like to get all of the data in these tables and put into one table
called TABLENAMECONSOLIDATION
i have searched and searched for a script that can do this to no avail, and
i have tried writing code to do this using various methods but its just not
happening.
can anybody help please.
location --
They are all of the same following structure
TABLENAME_YYYMMDD_HHMNSS
column1 Date ,column2 Date ,column3 TEXT ,column4 LONG ,column5 LONG
,column6 LONG
The question is
I would like to get all of the data in these tables and put into one table
called TABLENAMECONSOLIDATION
i have searched and searched for a script that can do this to no avail, and
i have tried writing code to do this using various methods but its just not
happening.
can anybody help please.