Results 1 to 2 of 2

Thread: Query with a command in DBMS

  1. #1
    Contributing Member
    Join Date
    May 2006
    Answers
    71

    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.


  2. #2
    Junior Member
    Join Date
    Oct 2006
    Answers
    24

    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
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact