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

Categories >> Software >> Databases >> Oracle >> Oracle AllOther
Suggest New Category

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

Question Posted / malli

6 Answers
9947 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / shaik

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

Is This Answer Correct ?

11 Yes

1 No

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

Answer / rupali

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

Is This Answer Correct ?

5 Yes

0 No

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

Answer / siva

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

Is This Answer Correct ?

4 Yes

0 No

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

Answer / prajakta

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

Is This Answer Correct ?

3 Yes

1 No

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

Answer / s.rajeshkumar

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

Is This Answer Correct ?

7 Yes

6 No

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

Answer / swati

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

Is This Answer Correct ?

1 Yes

4 No

Post New Answer

More Oracle AllOther Interview Questions

How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun

8 Answers

WHAT IS CARTESIAN PRODUCT?

2 Answers

Name a tablespace automatically created when you create a database.

3 Answers HCL,

What is index? How many types of indexes?

2 Answers HCL,

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,

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

0 Answers

Describe what redo logs are.

1 Answers

What is autocashrule set? : oracle accounts receivable

0 Answers

what are important reports in HRMS,GL,AP,AR in oracle apps?

3 Answers IBM, Pathway Technologies, Satyam, Techtimer, Wipro,

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

0 Answers Polaris,

key flexfield structure

0 Answers Infosys,

what is sql*loader parameters and where we will use it.

1 Answers Accenture,

For more Oracle AllOther Interview Questions Click Here