i am having comm in emp table and i want to display 0 when
comm =null and -10 if comm= value
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
types of receipts and detail desription about recipts and tables effected by receipts?
How would you determine what sessions are connected and what resources they are waiting for?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
8. Supporting AP, AR and GL?
Difference between transaction type and transaction sources. : oracle accounts receivable
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
as a technical developer in oracle applications which type errors feced in your experience sofar
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
What are different types of transactions in ar? : oracle accounts receivable
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
What is chargeback invoice? How do we create it? : oracle accounts receivable
What is auto invoicing? : oracle accounts receivable