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
10141 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 do you resize a data file?

2 Answers

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

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

i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

0 Answers HCL,

What does coalescing a tablespace do?

2 Answers

can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )

1 Answers IBM, Oracle,

Explain about party and customer in ar : oracle accounts receivable

0 Answers

What are the mandatory setups in setting up a PO in oracle

1 Answers Silicon,

I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?

1 Answers Oracle,

i want to know about the javaBean.what is its purpose and how it can use in Forms.

0 Answers Logisoft,

how can we send a concurrent program output to the clients through mail or fax give me example.

1 Answers Cap Gemini,

How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

0 Answers Cap Gemini,

For more Oracle AllOther Interview Questions Click Here