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
9920 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

why r u using etl tool.

2 Answers

how to write customizations in po

0 Answers Ernst Young,

what is the difference between TRUNCATE and DELETE command in SQL

23 Answers ICICI, Saama Tech, SkyTech, TCS,

What is auto invoicing? : oracle accounts receivable

0 Answers

I need a Technical evaluation between Oracle and SAP ? please do a need ful.

0 Answers

Are These Dff's Flexible?

0 Answers Oracle,

what is diff between pre insert,on insert,post insert triggers?

1 Answers IRISA,

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

1 Answers

Name two files used for network connection to a database.

1 Answers

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

3 Answers

What is $FLEX$ and $PROFILES$?

2 Answers

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

0 Answers

For more Oracle AllOther Interview Questions Click Here