When you writing code in PL/SQL , you some times need to have logics for the application to sleep before the next processing.
In PL/SQL you can use the below syntax for this Syntax
dbms_lock.sleep(
no_of_seconds);
Conditions
User should be granted with execute priviledge to dbms_lock package directly by SYS (Not via role)
grant execute on dbms_lock to user;