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 is Restricted Mode of Instance Startup in Oracle?

1143

How do you create a credit note against an invoice? : oracle accounts receivable

1028

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

2168

Difference between negative and positive adjustments : oracle accounts receivable

1017

what is semphore explian it?

2745

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2208

What is the disk migration? what is the steps involved in oracle disk migration?

1177

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

2420

What is Tax Categories?

2050

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

2343

as a technical developer in oracle applications which type errors feced in your experience sofar

2277

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2013

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2060

How many segment are present in Oracle Manufacturing

2262

difference of using cursor for loop and open,fetch,close.which one is better

1736