KSDS is having the emp key, empname and join date. We want to add the bonus Rs. 10000/- those who join on Jan 1st 2008. How to do this ?
KSDS is having the emp key, empname and join date. We want to add the bonus Rs. 10000/- those who join on Jan 1st 2008. How to do this ?
Use the following query
UPDATE TABLENAME
SET BONUS = 10000
WHERE JOINDATE = TO_DATE('01/01/2008','DD/MM/YYYY')