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
- 9919 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rupali
SELECT NVL2(COMM,-10,0)AS Commission FROM emp
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
i want to know about the javaBean.what is its purpose and how it can use in Forms.
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
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 are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
What is supporting issues GL AP and AR?
What is chargeback invoice? How do we create it? : oracle accounts receivable
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
How many segment are present in Oracle Manufacturing
Where in the Oracle directory tree structure are audit traces placed?
