Re: Record Copy Help

From: Andrew Babb <andrewb_at_mail.com>
Date: Thu, 29 Apr 1999 07:25:03 +0800
Message-ID: <372798CF.4A2844ED@mail.com>

Hi,

You could use an INSERT INTO ... SELECT and have the 5 Temporary Tables joined as a UNION or UNION ALL command. Not sure if it is the fastest, but it should be the easiest.

Andrew

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 Wed Apr 28 1999 - 18:25:03 CDT