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

Answer Posted / siva

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

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

676

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

1988

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

1824

What are different types of receipt reversals ? Explain them : oracle accounts receivable

723

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

619

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

726

types of receipts and detail desription about recipts and tables effected by receipts?

1629

Explain how to close periods in ar. : oracle accounts receivable

707

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

1651

What do you mean by hz_ in customer tables? : oracle accounts receivable

644

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

1700

which one is currently in used software cmpanies.

1661

can u give guidance abt packages of plsql

1646

what is difference between inner join & nested query or subqueries

2484

What view would you use to determine free space in a tablespace?

1781