SELECT NVL2(COMM,-10,0)AS Commission FROM emp

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

Question Posted / rupali

Answer Posted / rupali

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is Restricted Mode of Instance Startup in Oracle?

1233

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

2334

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

2336

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

1206

can we use lexical perameter in oracle plsql if yes how

2373

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

2565

What Are Cross Validation & Adi?

1204

Could you please let me know the interfaces in OM / FA??

2342

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

1864

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

2260

Explain about party and customer in ar : oracle accounts receivable

1270

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

2654

What is the mandatory setup in cyclecount ?

2807

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

2548

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

2248