Answer / shaik

select e.*,decode(comm,null,0,-10) new_comm
from emp e

Answer / rupali

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

Answer / siva

select nvl2(comm,-10,0) "New Comm" from employees;

Answer / prajakta

select case when comm is null then 0 else -10 end from emp

Answer / s.rajeshkumar

select nvl2(comm,0,-10) "New Comm" from employees;

Answer / swati

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

what is domain in database and its benefits?

0 Answers  

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

1 Answers  

What is store procedure?and how do u take the values from database and run in scripts?

2 Answers   Polaris,

Difference between negative and positive adjustments : oracle accounts receivable

0 Answers  

Difference between transaction type and transaction sources. : oracle accounts receivable

0 Answers  

For web applications from which version of Oracle is suitable?

1 Answers  

What is db_recovery_file_dest in oracle? When do you need to set this value?

0 Answers  

What command would you use to create a backup control file?

1 Answers  

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

0 Answers   Infosys,

How many segment are present in Oracle Manufacturing

0 Answers   Oracle,

Can anybody tell which is the best training institute for learning Oracle in chennai...? And i also i want placement assurance

1 Answers  

You have just compiled a PL/SQL package but got errors, how would you view the errors?

1 Answers