Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
Query with a command in DBMS
This is a discussion on Query with a command in DBMS within the SQL forums, part of the Databases category; 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. ...
|
|||||||
07-23-2006
|
|||
|
|||
|
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.
|
| Sponsored Links |
|
10-01-2006
|
|||
|
|||
|
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);
|
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Query with a Command in UNIX operating system | RyanJames | Unix/Linux | 2 | 07-23-2006 12:39 PM |
| Help me with the command | joel | SQL | 1 | 07-23-2006 12:29 PM |
All times are GMT -4. The time now is 03:12 AM.
