+ Reply to Thread
Results 1 to 3 of 3
  1. 03-11-2001 04:33 PM #1
    tron
    tron is offline Swollen Memeber
    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.
    Reply With Quote Reply With Quote
  2. 03-11-2001 05:08 PM #2
    kmesser
    kmesser is offline Senior Member
    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]

    Reply With Quote Reply With Quote
  3. 03-11-2001 08:53 PM #3
    tron
    tron is offline Swollen Memeber
    Join Date
    Feb 2001
    Location
    Master Control
    Posts
    86

    Talking thanks

    thanks for the help, i got exactly what i needed via the link!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

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