DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: time based triggers

  1. #1
    Join Date
    Feb 2001
    Location
    Master Control
    Posts
    86
    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.

  2. #2
    Join Date
    Aug 2000
    Posts
    462
    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]


  3. #3
    Join Date
    Feb 2001
    Location
    Master Control
    Posts
    86

    Talking 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
  •  


Click Here to Expand Forum to Full Width