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

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

2168

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

1239

How would you go about increasing the buffer cache hit ratio?

2560

A scenario for amount correction & how to use amount correction functionality in AP invoices

2106

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

2037

can we use lexical perameter in oracle plsql if yes how

2282

What is an Oracle database Full Backup?

1102

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

2187

What is auto invoicing? : oracle accounts receivable

1112

Difference between transaction type and transaction sources. : oracle accounts receivable

999

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

2112

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

2221

what is semphore explian it?

2775

What is db_recovery_file_dest in oracle? When do you need to set this value?

1093

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

2072