Re: Error with DBMS_SQL
From: joel garry <joel-garry_at_home.com>
Date: Wed, 20 Mar 2013 08:30:55 -0700 (PDT)
Message-ID: <aeb03740-2e01-4d67-a44b-647c0a1c0508_at_m3g2000pba.googlegroups.com>
On Mar 20, 7:20 am, carlino..._at_gmail.com wrote:
Date: Wed, 20 Mar 2013 08:30:55 -0700 (PDT)
Message-ID: <aeb03740-2e01-4d67-a44b-647c0a1c0508_at_m3g2000pba.googlegroups.com>
On Mar 20, 7:20 am, carlino..._at_gmail.com wrote:
> Now I would like to add a few lines to check if the record exists then update then insert otherwise, according to the case.
Sounds like a job for merge. http://www.oracle-base.com/articles/10g/merge-enhancements-10g.php
jg
-- _at_home.com is bogus. http://www.theregister.co.uk/2013/03/19/gartner_virtualisation_market_overview/Received on Wed Mar 20 2013 - 16:30:55 CET