SQL & PL/SQL

Hi,

I want to convert progress editor query to Oracle query.

In the below query we need to run this on every saturday(04-July-09) at 3:30 PM.

FOR EACH sector WHERE sector.latest-dep-date >= 06/25/09
AND sector.latest-dep-date <= 07/03/09 NO-LOCK :
FIND uobj-tag WHERE uobj-tag.parent-obj-id = sector.obj-id
AND uobj-tag.tag-name = 'Fuel Consumption'
NO-ERROR.
IF NOT AVAIL(uobj-tag) THEN DO :
CREATE uobj-tag.
ASSIGN uobj-tag.parent-obj-id = sector.obj-id

uobj-tag.tag-name = 'Fuel Consumption'.
END.
END.

I want to run this script automatically using Oracle query.


Please advise.




Thanks & Regards
Nihar