how to update a column daily? 1

[huchen]

Hello,

I am looking for a simple way to achieve this:

I need to run this query at 7:00am daily:
update tab_1 set flag ='Y' where modifed_date > sysdate -2;

What are the options I have to achieve this?

Thank you!

 

[LKBrwnDBA]

Try using DBMS_SCHEDULER or DBMS_JOB packages.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb