Interested to Buy Any Domain ? << Click Here >> for more details...
i am having comm in emp table and i want to display 0 when
comm =null and -10 if comm= value
- 6 Answers
- 9912 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
i want to know about the javaBean.what is its purpose and how it can use in Forms.
difference of using cursor for loop and open,fetch,close.which one is better
What is an Oracle database Full Backup?
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
What is the difference between recovery and restoring of the oracle database?
What is the difference between oracle media recovery and crash recovery?
8. Supporting AP, AR and GL?
Can we modify approve purchase order?if yes what is navigation?
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
can we use lexical perameter in oracle plsql if yes how
