Oracle DBMS_UTILITY package- How to use – learn with example
Oracle dbms_utility is a powerful built-in package that can be used to perform several tasks from pl/sql programs. Learn here with loads of example.
|
| |||
Oracle, SQL, PL/SQL, Microsoft SQL Server and T-SQL related Tips and Techniques |
|
Oracle dbms_utility is a powerful built-in package that can be used to perform several tasks from pl/sql programs. Learn here with loads of example.
Learn about Oracle DBMS_LOCK package: DBMS_LOCK is an Oracle supplied in-built package which provides interface to Oracle’s Lock management services. Using this package you can lock an object in specific mode, give a name to the lock and release it when lock is no more required.
However the subject of this posting is not locks but Seep procedure in the DBMS_LOCK package.
A simple but very useful guide on Oracle DBMS_SCHEDULER package. The examples will show you how to use the package to schedule a job and how to maintain the scheduled jobs in Oracle databases.
Released with Oracle 10g this package replaces DBMS_JOB which was avalable with previous version of Oracle databases. DBMS_JOB still runs in Oracle 10g and even in 11g but that is used only for backward compatibility and should not be used in developing new solutions.
Example of using UTL_FILE to write data to an operating system file. This package is supplied by Oracle and is used to read an operating system file or write to an operating system file.
Easy to understand example of reading operating system file using UTL_FILE package of Oracle.