update emp set comm = case when comm is null then 0 else 10 end

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

Question Posted / swati

Answer Posted / swati

update emp set comm =
case
when comm is null then 0
else
10
end

Is This Answer Correct ?

1 Yes

4 No

Please Help Members By Posting Answers For Below Questions

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

1196

Explain the use of table functions.

2488

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

2061

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

2224

Explain about party and customer in ar : oracle accounts receivable

1211

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

2327

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

1295

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

2297

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

2401

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

2472

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

3582

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

1776

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2072

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.

2193

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2223