LeonelSanchezJr
Programmer
I need the syntax to update a record in a table if the record exists, else insert it into table.
Thanks,
Leo ;-)
Thanks,
Leo ;-)
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Update a Record if it Exists ELSE Insert into Table
- Thread starter LeonelSanchezJr
- Start date
- Status
SantaMufasa
Technical User
Leonel,
What you want is the Oracle MERGE command (<-- click here for an example.)
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]
What you want is the Oracle MERGE command (<-- click here for an example.)
Mufasa(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]
- Status
Similar threads
