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.
You can use the built-in package DBMS_LOCK.
SQL> exec dbms_lock.sleep(10);
The unit of measurement is seconds.
No one has followed this question yet.
How to transpose columns to rows in below scenario.
What is Pragma Init Exception in oracle?
Difference between case and code statements in oracle?
What are the uses of Data Dictionary ?