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

Could you please let me know the interfaces in OM / FA??

0 Answers Oracle,

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

0 Answers

What is the difference between the SQL*Loader and IMPORT utilities?

1 Answers

types of receipts and detail desription about recipts and tables effected by receipts?

0 Answers

as a technical developer in oracle applications which type errors feced in your experience sofar

0 Answers HCL,

How do you add a data file to a tablespace?

1 Answers

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

0 Answers Pathway Technologies,

HOW TO SPOT AHIERARCHY?

0 Answers

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

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

Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?

4 Answers

default triggers available for reports

0 Answers

key flexfield structure

0 Answers Infosys,

For more Oracle AllOther Interview Questions Click Here