Re: Record Copy Help

write a sql script file

insert into master as
select * from temp_table1;
insert into master as
select * from temp_table2;
commit;

gnuc_at_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 Mon May 10 1999 - 08:56:31 CDT