+ Reply to Thread
Results 1 to 2 of 2

Hybrid View

  1. 01-22-2003 09:29 PM #1
    vas
    vas is offline Junior Member
    Join Date
    Jan 2003
    Location
    ssss
    Posts
    1

    how to fire trigger depending on system time

    For each 12 hours i have to perform insert operation automatically
    how to write trigger for this .
    Reply With Quote Reply With Quote
  2. 01-22-2003 10:25 PM #2
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Use DBMS_JOB.
    http://www.pinnaclepublishing.com/OP...2568F00065982B

    HTH
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"
    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