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
Employee
- 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.
Regards,
Indranil.
