select case when comm is null then 0 else -10 end 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 / prajakta

Answer Posted / prajakta

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

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

2350

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

2276

key flexfield structure

2121

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1272

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

2025

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

2321

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2062

8. Supporting AP, AR and GL?

2268

What Are Cross Validation & Adi?

1101

What is an Oracle database Partial Backup?

1115

can u give guidance abt packages of plsql

2112

What is Restricted Mode of Instance Startup in Oracle?

1149

Difference between negative and positive adjustments : oracle accounts receivable

1019

Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

1109

how to write customizations in po

1566