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
$300 Free Credits to Build on Google Cloud Icon
$300 Free Credits to Build on Google Cloud

New customers can spin up VMs, build with AI, and query data at no cost.

Put your $300 in credit toward real workloads, then keep building with free monthly usage for 20+ products. No commitment and no charge until you upgrade.
Start 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