| Using decode [message #1606] |
Wed, 15 May 2002 20:27  |
Dave
Messages: 92
Registered: August 1999
|
Member |
|
|
I need help with something. I am just trying to figure out how to give a 10%raise to employees who have been with a company for one year or more.
This is what I have, what am I missing?
select ename "Name",sal "Salary",
DECODE(months_betweensysdate,hiredate),'',sal*1.10, sal)
New_Salary
from emp
|
|
|
|
| Re: Using decode [message #1608 is a reply to message #1606] |
Wed, 15 May 2002 21:51  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
Your select should read:
The sign function determines whether there are more months between sysdate and hiredate than 120. If so, the decode will replace the salary by salary * 1.1SELECT ename "Name"
, sal "Salary"
, DECODE(sign(months_between(sysdate, hiredate)-120), +1,sal*1.1,sal) New_Salary
FROM emp
But, you're only performing a select, you're not doing an actual update. I believe that, to give a raise, you should do an update.
HTH,
MHE
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
