Oracle Merge Statement -sample query
Date: Tue, 20 May 2008 02:59:26 -0700 (PDT)
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.
Indranil. Received on Tue May 20 2008 - 04:59:26 CDT