i am having comm in emp table and i want to display 0 when
comm =null and -10 if comm= value
Answer Posted / s.rajeshkumar
select nvl2(comm,0,-10) "New Comm" from employees;
Is This Answer Correct ? | 7 Yes | 6 No |
Post New Answer View All Answers
which one is currently in used software cmpanies.
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
What is the difference between oracle media recovery and crash recovery?
What is the mandatory setup in cyclecount ?
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
Why more redos are generated when the oracle database is in begin backup mode?
1. What is PO rate variance gain and loss?
where the dff data will be stored
What is the sql query to find the employee who has Nth maximum salary?
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
How to clone the database using RMAN back
what are the API of GL,PO,AP
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
What is autocashrule set? : oracle accounts receivable