Custom Search
www.rocket99.com : Technical Guides
Sybase
Oracle
UNIX
Javascript
Technical Guides
Sybase
Oracle
UNIX
Javascript
Of Interest
Be responsible for your future
Enter the USA legally!
Visa, Green Card, Citizenship, Passport
Consultation Services
Oracle » PL-SQL » Coding »
Sleep and Wait
Sometimes it is necessary to delay the execution of commands, for debugging,
or batch runs.
/* Sleep 60 seconds */
execute dbms_lock.sleep(60);
/* Sleep one hour */
execute dbms_lock.sleep(3600);
Oracle : Related Topics
Oracle : PL-SQL : Creating a stored procedure
Oracle : PL-SQL : Displaying output
Oracle : PL-SQL : Output variables
Oracle : PL-SQL : Arrays and structures
Oracle : PL-SQL : Conditionals
Oracle : PL-SQL : Looping in PL-SQL
Oracle : PL-SQL : Packages
Oracle : PL-SQL : Exception Handling
Oracle : PL-SQL : Date Manipulation
Oracle : PL-SQL : Parallel Query Processing
Oracle : PL-SQL : Exit if error, in a SQL script
Oracle : PL-SQL : Cursors
Oracle : PL-SQL : Complex IF/THEN Processing
Oracle : PL-SQL : Creating triggers
Oracle : PL-SQL : Ranking Data
Oracle : PL-SQL : How to do an outer join in Oracle
Oracle : PL-SQL : Loops in PL-SQL : Hierarchy
Sybase Web Site
Sybase iAnywhere Mobile Web Site
Oracle Enterprise Web Site
Get the latest Rocket99 news and tech tips via
Site Index
About this Guide to Sybase, Oracle, and UNIX
Contact Us
Advertise on this site
Copyright © 2019
Stoltenbar Inc
All Rights Reserved.
