Most mysql useres will miss the "replace into" feature on oracle. So here is a way to generate a PL/SQL Package from a given table for doing upsert/"replace into". As an improvement you will get back the new or updated primary key (if one is used).

Project Activity

See All Activity >

Follow Oracle replace into

Oracle replace into Web Site

Other Useful Business Software
Custom VMs From 1 to 96 vCPUs With 99.95% Uptime Icon
Custom VMs From 1 to 96 vCPUs With 99.95% Uptime

General-purpose, compute-optimized, or GPU/TPU-accelerated. Built to your exact specs.

Live migration and automatic failover keep workloads online through maintenance. One free e2-micro VM every month.
Try Free
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of Oracle replace into!

Additional Project Details

Registered

2010-10-11
Report inappropriate content