The SQL statement WaitFor can be written to a stored procedure and executed again: waitFor {Delaytime | Timetime} the Time after Delay is the Delay Time. The Time after the execution Time is the specified execution Time. The formula is HH: MM: SS. The date example is not supported: ------ specify to execute Beginwaitfortime10: 00se
The SQL statement WaitFor can be written to a stored procedure and executed again: waitFor {Delay 'time' | time' time} the Time after Delay is the Delay time. The Time after the execution time is the specified Time. The formula is HH: MM: SS, the following is an example of a date not supported: ------ Begin waitfor time '10: 00' se is executed.
The SQL statement WaitFor can be written to a stored procedure and executed again.
Syntax: WaitFor {Delay 'time' | time' time}
The time after Delay is the Delay time for execution.
The Time after Time is the specified execution Time in the format of "HH: MM: SS". The date is not supported.
Example:
------ Specify for execution
Begin
Waitfor time '10: 00'
Select * from tablename
End
----- Specify to wait 1 hour before execution
Begin
Waitfor delay '1: 00'
Select * from tablename
End
Dbms_lock.sleep (n) is paused for n seconds and then executed
Generally, this package is created, but the permission is not granted by default. Another important step is to grant the user the all on dbms_lock permission ..
As a DBA
Grant execute on dbms_lock to USERNAME;
Stored in the storage process
1. WAITFOR
-- WAITFOR
-- For example, the SELECT statement is executed after 1 hour, 2 minutes, and 3 seconds.
Waitfor delay '01: 02: 03'
Select * from employee
-- For example, the SELECT statement will not be executed until PM.
Waitfor time '23: 08: 00'
Select * from employee