select nvl2(comm,-10,0) "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 / siva

6 Answers
9910 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

Please Help Members By Posting Answers For Below Questions

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

2070

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?

2099

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1258

key flexfield structure

2111

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2273

I need a Technical evaluation between Oracle and SAP ? please do a need ful.

1956

What is chargeback invoice? How do we create it? : oracle accounts receivable

1281

What are different types of transactions in ar? : oracle accounts receivable

1217

what are basic modules required to implement oracle application in any oraganisation?

2147

1. What is PO rate variance gain and loss?

2834

What is the mandatory setup in cyclecount ?

2695

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

2647

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

2142

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2464

can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2313