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

the user should know to which database he is connected currently in oracle

3 Answers  

How client makes connection with server in client/server architecture?

1 Answers   CA,

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

0 Answers  

8. Supporting AP, AR and GL?

0 Answers   Oracle,

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

0 Answers   Infosys,

What is Restricted Mode of Instance Startup in Oracle?

0 Answers  

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.

0 Answers  

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

0 Answers  

What is difference b/w Credit memo and Adjustment in AR.

1 Answers   Oracle,

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,

Give two examples of referential integrity constraints.

1 Answers  

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

0 Answers