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

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2325

how to write customizations in po

1606

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

3567

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2062

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

1216

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

2588

3. Steps in UAT?

2425

default triggers available for reports

2204

How would you determine what sessions are connected and what resources they are waiting for?

2121

What is chargeback invoice? How do we create it? : oracle accounts receivable

1326

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

1190

What is the difference between conversions and interfaces? : oracle accounts receivable

1197

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1767

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

1303

Differentiate between transaction type and transaction source? : oracle accounts receivable

1108