Home » SQL & PL/SQL » SQL & PL/SQL » How to check does record exsist?
How to check does record exsist? [message #250070] Sat, 07 July 2007 10:06 Go to next message
majstoru
Messages: 68
Registered: October 2006
Location: Serbia
Member
Hi,

I have stored procedure on table1 which is edit data in table2.

This procedure made some changes on a table2 records which is depend on changes on table1, on of rules are that procedure check is that record exsist and edit it or insert new record.

How to check does record exsist into table and update it, or to insert new if not exsist?

Thanks in advance...
Re: How to check does record exsist? [message #250074 is a reply to message #250070] Sat, 07 July 2007 11:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use MERGE

Regards
Michel
Re: How to check does record exsist? [message #250086 is a reply to message #250070] Sat, 07 July 2007 15:29 Go to previous message
majstoru
Messages: 68
Registered: October 2006
Location: Serbia
Member
Cool Cool

Thanks a lot Michael...
Previous Topic: Function Help
Next Topic: How to transfer 500,000 records from 1 db to another
Goto Forum:
  


Current Time: Fri Dec 09 08:07:04 CST 2016

Total time taken to generate the page: 0.07231 seconds