PL/SQL Update and Insert into Table using a lookup

From: Mark Regan <mark.regan_at_bskyb.com>
Date: 15 May 2003 03:10:47 -0700
Message-ID: <c00c1cf6.0305150210.290ce007_at_posting.google.com>



Hi,

[Quoted] [Quoted] I am relatively new to PL/SQL and am trying to create a script that [Quoted] will update a table with new records from another table or insert the record if no record currently exists. The records contain a unique identifier that will be used to check if the record already exists on the table.

However the unique identifier does not have an index built on it on this table.

Any ideas how I would write this?

Thanks Received on Thu May 15 2003 - 12:10:47 CEST

Original text of this message