Below is the query which shows the way to update the date in Oracle
select count(*) from employee where DOB='08-JUN-2012';
update employee set DOB='12-JUN-2012' where DOB='08-JUN-2012';
select count(*) from employee where DOB='08-JUN-2012';
update employee set DOB='12-JUN-2012' where DOB='08-JUN-2012';
No comments:
Post a Comment