Can someone tell me about the command DBMS_LOCK.SLEEP. Is this command useful for making the system wait for certain time? If so will the time be in seconds or milliseconds. An example to understand the concept would be helpful.
Printable View
Can someone tell me about the command DBMS_LOCK.SLEEP. Is this command useful for making the system wait for certain time? If so will the time be in seconds or milliseconds. An example to understand the concept would be helpful.
The SLEEP procedure suspends the session for the number of seconds specified in the seconds parameter. Sleep periods can be specified with accuracy down to the hundredth of a second (e.g., 1.35 and 1.29 are recognized as distinct sleep times). Here's the example:
DBMS_LOCK.SLEEP
(seconds IN NUMBER);