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 type of index should you use on a fact table?

1 Answers  

1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

0 Answers   Cap Gemini,

how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.

1 Answers   Alshaya,

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

0 Answers   Pathway Technologies,

can we use lexical perameter in oracle plsql if yes how

0 Answers  

What is $FLEX$ and $PROFILES$?

2 Answers  

How do you create a credit note against an invoice? : oracle accounts receivable

0 Answers  

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

0 Answers  

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

6 Answers   IBM,

WHAT IS CARTESIAN PRODUCT?

2 Answers  

What is Tax Categories?

0 Answers  

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

0 Answers   Accenture,