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 after which the execution time is specified. The format is "HH: mm: SS ", the following is an example of a date not supported: ------ specify to execute beginwaitfor time '10: 00' select * From tablenameend ----- specify to wait for 1 hour and then execute beginwaitfor delay'1: 00 'select * From tablenameenddbms_lock.sleep (n) pause for n seconds. Generally, this package will be created after execution, but the permission is not granted by default; another important step is to grant the user the all on dbms_lock permission .. Grant execute on dbms_lock to username as DBA; put it 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
