Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Trigger on System Date
Trigger on System Date [message #76226] Tue, 06 November 2001 03:14 Go to next message
Vishal Raj
Messages: 1
Registered: November 2001
Junior Member
I 've to fire some trigger on insertion on Table A that Table B be updated after 24 hrs at the time of insertion on Table A. Please let me know how it can be done.

----------------------------------------------------------------------
Re: Trigger on System Date [message #76242 is a reply to message #76226] Fri, 23 November 2001 08:38 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Use the trigger to submit a procedure for execution in DBMS_JOB.

----------------------------------------------------------------------
Previous Topic: Opening text file in PL/SQL
Next Topic: Re: ORACLE CERTIFIED PROFESSIONAL TEST EXAM
Goto Forum:
  


Current Time: Mon Nov 25 18:53:40 CST 2024