i am having comm in emp table and i want to display 0 when
comm =null and -10 if comm= value
- 6 Answers
- 8186 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
can we use lexical perameter in oracle plsql if yes how
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
Difference between negative and positive adjustments : oracle accounts receivable
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
what are the tools used for oracle 10g in real time.
what are basic modules required to implement oracle application in any oraganisation?
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
What are different types of receipt reversals ? Explain them : oracle accounts receivable
what are the API of GL,PO,AP
Explain about party and customer in ar : oracle accounts receivable
default triggers available for reports
What is Tax Categories?
What are different types of transactions in ar? : oracle accounts receivable
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
What is auto invoicing? Explain : oracle accounts receivable
