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
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
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?
1. What is PO rate variance gain and loss?
What is the disk migration? what is the steps involved in oracle disk migration?
how to write customizations in po
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
A scenario for amount correction & how to use amount correction functionality in AP invoices
can we use lexical perameter in oracle plsql if yes how
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
How would you go about increasing the buffer cache hit ratio?
What are different types of receipt reversals ? Explain them : oracle accounts receivable
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
Explain prerequisites and post activities of oracle database installation