Insert into master table
select * from temp_table_1
union all
select * from temp_table_2, etc
gnuc@my-dejanews.com wrote:
I have a master Table and 5 (kind of)temp tables
(same structure).
Every night I have to copy all records from temp tables to the master
table.
Is there an easy and a fast way to do this with just one command without
going through PL/Sql and doing Inset on each record separately?
Thanks.
(I am using Oracle 8)
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/
Search, Read, Discuss, or Start Your Own
Received on Thu Apr 29 1999 - 02:34:21 CDT
