i am having comm in emp table and i want to display 0 when
comm =null and -10 if comm= value
- 6 Answers
- 9162 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shaik
select e.*,decode(comm,null,0,-10) new_comm
from emp e
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / siva
select nvl2(comm,-10,0) "New Comm" from employees;
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / prajakta
select case when comm is null then 0 else -10 end from emp
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / s.rajeshkumar
select nvl2(comm,0,-10) "New Comm" from employees;
| Is This Answer Correct ? | 7 Yes | 6 No |
Answer / swati
update emp set comm =
case
when comm is null then 0
else
10
end
| Is This Answer Correct ? | 1 Yes | 4 No |
HOW TO SPOT AHIERARCHY?
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
Olap tools
pl help me, i want oracle HRMS training institute address,in chennai
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
how to create an user in oracle 10g.please give me an example..
HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
What is the difference between conversions and interfaces? : oracle accounts receivable
What do you mean by hz_ in customer tables? : oracle accounts receivable
hi iam looking for HRMS(functional) training inst or person in hyderbad. plz help me its urgent
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?
Oracle General 
