i am having comm in emp table and i want to display 0 when
comm =null and -10 if comm= value
- 6 Answers
- 9072 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / swati
update emp set comm =
case
when comm is null then 0
else
10
end
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What is the disk migration? what is the steps involved in oracle disk migration?
Are These Dff's Flexible?
What is autocashrule set? : oracle accounts receivable
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
What is the mandatory setup in cyclecount ?
where the dff data will be stored
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
What do you mean by Oracle MEDIA RECOVERY?
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
8. Supporting AP, AR and GL?
Explain how to close periods in ar. : oracle accounts receivable
What is the difference between recovery and restoring of the oracle database?
can u give guidance abt packages of plsql
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
