select nvl2(comm,0,-10) "New Comm" from employees;

i am having comm in emp table and i want to display 0 when
comm =null and -10 if comm= value

Question Posted / s.rajeshkumar

Answer Posted / s.rajeshkumar

Is This Answer Correct ?

7 Yes

6 No

Please Help Members By Posting Answers For Below Questions

How would you determine what sessions are connected and what resources they are waiting for?

2127

How to clone the database using RMAN back

2244

what is semphore explian it?

2816

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

1154

please send me oracle pl/sql exp resume. and also faqs...

2495

what is the link between suppliers and banks in ap module in oracle apps? And also query?

2472

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

2280

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1777

What is auto invoicing? Explain : oracle accounts receivable

1127

Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1277

Are These Dff's Flexible?

1175

Is there any link between pr form(purchse requisition)and po form(purchase order)

2729

What is the difference between oracle media recovery and crash recovery?

1176

what is difference between inner join & nested query or subqueries

3040

which one is currently in used software cmpanies.

2156