Creating Oracle 8 database applications involves more than just banging out SQL code. Skills like creating efficient stored procedures, designing robust exception handlers, and debugging SQL and PL/SQL (Oracle's SQL extensions) must all be mastered, and that is the mission of this book. The CD-ROM features all project code and easily accessible demonstration databases, plus SQL scripts, automation tools, templates, and optimizing database design resources.PL/SQL provides two distinct uses of the PRAGMA statement: exception_init and restrict references. The exception_init ... In this example, the ORA-00942 error is renamed to a user-defined exception xTABLE- DOESNOTEXIST: DECLAREanbsp;...
|Title||:||High Performance Oracle Database Automation|
|Publisher||:||Coriolis Group - 1997|