i am having comm in emp table and i want to display 0 when
comm =null and -10 if comm= value
- 6 Answers
- 8201 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
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
types of receipts and detail desription about recipts and tables effected by receipts?
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
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 the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
default triggers available for reports
Give two methods you could use to determine what DDL changes have been made.
What is auto invoicing? : oracle accounts receivable
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
Could you please let me know the interfaces in OM / FA??
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
What is Tax Categories?
