i am a bit new to oracle, but i have a pretty good understanding of pl/sql and i am trying to figure out how i would update a given table (or do some routine action) once a day.
Printable View
i am a bit new to oracle, but i have a pretty good understanding of pl/sql and i am trying to figure out how i would update a given table (or do some routine action) once a day.
tron,
research the DBMS_JOB package. You'll need to use the DBMS_JOB.SUBMIT procedure. See "Oracle 8i Advanced PL/SQL Programming", pp 306-320.
http://technet.oracle.com/docs/produ.../jobq.htm#8312
thanks for the help, i got exactly what i needed via the link!