I would like to load a txt file into an Oracle 8i table but like the Oracle 9i merge functionality.
e.g INSERT the new records
UPDATE the old records if it is needed
This is needed to maintain old records that have been inserted into the table but are not in the file now.
Some time ago I found a PL/SQL block that accomplished this but I lost the link.
e.g INSERT the new records
UPDATE the old records if it is needed
This is needed to maintain old records that have been inserted into the table but are not in the file now.
Some time ago I found a PL/SQL block that accomplished this but I lost the link.