How to give sleep command in pl/sql ? I heard like there are many ways but not known. Please let me know which one is better if we have many options. Thank you.
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Answer by Dwayne King · Feb 03, 2010 at 04:28 PM
You can use the built-in package DBMS_LOCK.
SQL> exec dbms_lock.sleep(10);
The unit of measurement is seconds.
Answers Answers and Comments
No one has followed this question yet.
Can we skip certain columns while loading data ?
how to find (A+B)/C from a single row when we assign grades to them
Can we call a stored function in the constraint of a table ?
How does one load multi-line records?
What are the various types of parameter modes in a procedure ?