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 find (A+B)/C from a single row when we assign grades to them
How can I protect my PL/SQL source code?
Can one use dynamic SQL within PL/SQL?
Is there a limit on the size of a PL/SQL block?
Why is a Where clause faster than a group filter or a format trigger?