I am creating an Oracle Developer form which will take the query created by the user and specified runtime (also by user) and saves it in two columns of a Oracle table. Is there a facility in oracle which can trigger off the saved query when the sysdate becomes equal to specified runtime?
The DBMS_JOB package should do the trick. See documentation on Oracle Supplied PL/SQL Packages and Types Reference for details on parameter requirements.
Last Wiki Answer Submitted: July 11, 2006 10:59 am by L902suedoe0 pts.