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 Are Cross Validation & Adi?

0 Answers   Oracle,

When a user process fails, what background process cleans up after it?

1 Answers  

Explain the payment term in ar. : oracle accounts receivable

0 Answers  

whats the difference between join command and Cartesian product using example?

1 Answers  

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

0 Answers  

what is the difference b/w oracle8i and oracle9i

3 Answers   iGate,

A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?

7 Answers   TCS,

can u give guidance abt packages of plsql

0 Answers   Mphasis,

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

3 Answers   HP,

A scenario for amount correction & how to use amount correction functionality in AP invoices

0 Answers  

8. Supporting AP, AR and GL?

0 Answers   Oracle,

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

3 Answers