i am having comm in emp table and i want to display 0 when
comm =null and -10 if comm= value
- 6 Answers
- 9013 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / siva
select nvl2(comm,-10,0) "New Comm" from employees;
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
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
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
what are basic modules required to implement oracle application in any oraganisation?
Differentiate between transaction type and transaction source? : oracle accounts receivable
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
What Are Cross Validation & Adi?
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
How would you determine what sessions are connected and what resources they are waiting for?
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?
How to clone the database using RMAN back
What is chargeback invoice? How do we create it? : oracle accounts receivable
What is the difference between recovery and restoring of the oracle database?
