-
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.
[url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76956/jobq.htm#8312[/url]
-
thanks
thanks for the help, i got exactly what i needed via the link!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|