Re: Oracle Merge Statement -sample query
Date: Tue, 20 May 2008 05:39:56 -0700 (PDT)
On May 20, 4:59 am, idey <dey.indra..._at_gmail.com> wrote:
> Hi All,
> I have a simple question but i am in a fix coz of it.
> This is regarding Oracle Merge statement.
> The question is:
> I have a table say
> - Name varchar2(20)
> - ID pk number
> - salary number
> I want to check whether ID = 20 exists or not. If yes, then update
> salary = salary +10000;
> else insert the row with default values.
> Can someone give me the SQL for this? I have tried all the seemingly
> normal approaches.
Then show us what you've tried, as this appears to be an assignment for school. We won't do your homework for you , but we WILL offer assistance when we see what you've tried.
David Fitzjarrell Received on Tue May 20 2008 - 07:39:56 CDT