-
Contributing Member
Query with a command in DBMS
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.
-
Junior Member
Re: Query with a command in DBMS
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);
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