Tutorial Downloads .com

Home

Mastering Oracle PL/SQL: Practical Solutions - pdf tutorial

This book offers a wealth of tips, techniques, and complete strategies for maximizing the benefits of PL/SQL within your organization. By the end of this book, youíll be as convinced as we are that PL/SQL isnít just a useful toolóitís an integral part of any Oracle application youíll ever develop.

Contents of this Oracle PL/SQL tutorial

Chapter 1 Efficient PL/SQL . . . . . 1
Why Use PL/SQL?.1
What is Efficient PL/SQL?. . .4
Achieving Efficiency . . . . .13
Conclusion . .56
Chapter 2 Package It All Up . 59
Basic Benefits of Packages.59
Standalone Procedures and the Dependency Crisis .65
Breaking the Dependency Chain . . . . . . . .75
Enabling Recursion . . . . . . .90
Why Have People Avoided Packages? . . .91
When Not to Use Packages. . .96
Delivered Packages . . . .99
Summary . . . . .115
Chapter 3 The Vexed Subject of Cursors 117
Implicit vs. Explicit Cursors . . . . . . .117
Cursor Management Across Architectures . . . . . . . . . . .132
Summary . . . . .143
Chapter 4 Effective Data Handling . . . . . . . . 145
Taking Control of Your Datatypes . . .145
From Fields to Rows—Using %ROWTYPE .155
From Records to Objects162
The Motivation for Collections in PL/SQL . . . . . . . .176
Bulking Up with Collections . . . . . . . . . .180
Passing Variables Between PL/SQL Programs . . . . . . .197
Transaction Processing in PL/SQL . . . .212
Autonomous Transactions218
Summary . . . . .228
Chapter 5 PL/SQL Optimization Techniques. 229
Minimizing Parsing and Memory Consumption . . . . . . .229
Data Types: Tips and Techniques . . . . .254
Calling PL/SQL . . . . . . . . . . .267
SQL Within PL/SQL . . . . . . .287
Summary . . . . .306
Chapter 6 Triggers. . . 307
Trigger Concepts . . . . . . . . .307
DML Triggers. . .319
Instead-of Triggers . . . . .324
Mutating Tables . . . . . . . . . .326
Data Auditing.336
Table Versioning . . . . . . . . .339
Oracle Streams . . . . . . . . . . .342
Job Queue (Temporal Event Triggers)349
DDL Triggers. . .355
Database Event Triggers359
Logon Triggers . . . . . . . . . . .359
Don’t Re-Invent the Wheel.363
Summary . . . . .366
Chapter 7 DBA Packages . . . . . . . . 367
Alert File Package . . . . . .368
Notification Package . . . .394
Proactive Monitoring Package . . . . . . . . .399
Historical Data Package406
Summary . . . . .413
Chapter 8 Security Packages . 415
Design Considerations415
Triggers for Security440
Protecting the Source453
Summary .462
Chapter 9 Web Packages . . . . . . . 463
PL/SQL Web Toolkit Basics . . . . . . . . . . .463
The htp and htf Packages . . . . . . . . . . .468
Using Environment Variables . . . . . . . .470
Cookies .476
Managing Files . . . . . . . .478
Managing Tables Through the Web . . .484
HTTP from the Database. .495
Summary .503
Chapter 10 PL/SQL Debugging . . 505
Defensive Coding . . . . . .505
Tools . . . .512
A Custom DEBUG Utility. .540
Summary .558
Appendix A Building DEBUG . . . . 559
Database Design and Setup . . . . . . . . . .559
Package Layout . . . . . . . .562
Implementation . . . . . . . .564
Troubleshooting DEBUG586
Index . . . 587

READ / DOWNLOAD this Oracle PL/SQL tutorial


Resource: http://www.oracle.com/technology/books/pdfs/sample2174ch2.pdf
Posted By : Oracle Brain
On date : 09.25.09

Most used ORACLE Database Tutorials

Oracle SQL Developer 1.5.5 download and installation
To install Oracle SQL Developer 1.5.5 download the file and unzip into an empty folder. Select the "Use folder names" checkbox when unzipping the file. A Check for Updates facility is available to install third-party database drivers, if required.
Oracle Tutorials ( Ebooks , pdf's )
Oracle 8i the Complete ReferenceMcGrawHill-Oracle_Database_10g_New_Features.chm Database.10g..High.Availablity.with.RAC.Flashback.&.Data.Guard McGraw Hill - Oracle Database 10g, A Beginner's Guide.chm
Mastering Oracle PL/SQL: Practical Solutions - pdf tutorial
This book offers a wealth of tips, techniques, and complete strategies for maximizing the benefits of PL/SQL within your organization. By the end of this book, youíll be as convinced as we are that PL/SQL isnít just a useful toolóitís an integral part of any Oracle application youíll ever develop.
Oracle 10g Database PL/SQL User's Guide and Reference study material - pdf tutorial
Anyone developing PL/SQL-based applications for Oracle should read this book. This book is intended for programmers, systems analysts, project managers, database administrators, and others who need to automate database operations. People developing applications in other languages can also produce mixed-language applications with parts written in PL/SQL.
Oracle interview questions and answers
These are some common oracle interview questions with answers.
Oracle Database SQL Quick Reference tutorial
This quick reference contains a high-level description of the Structured Query Language (SQL) used to manage information in an Oracle database.
New Features in Oracle Database 10g
This tutorial provides the details of New Features in Oracle Database 10g
Oracle SQL Parallel Execution tutorial
This Oracle tutorial focuses on SQL parallel execution only, which consists of parallel query, parallel DML (Data Manipulation Language) and parallel DDL (Data Dictionary Language). While this pdf study material focuses on Oracle Database 11g, the information in this paper also applies to Oracle Database 10g and higher, unless explicitly stated.
Oracle SQL Developer Data Modeler tutorial and reference
Oracle SQL Developer Data Modeler is a new, graphical data modeling tool that facilitates and enhances communication between data architects, database administrators, application developers and users, and simplifies the data modeling development process itself.
Oracle Rdb 7 Guide to SQL Programming - pdf tutorial
This manual describes how to design and develop host language application programs that use SQL (structured query language) to store, modify, and retrieve data from Oracle Rdb databases.
Oracle TimesTen In-Memory database Extension for Oracle SQL Developers - pdf tutorial
Oracle TimesTen In-Memory database Extension for Oracle SQL Developers is a free extension to Oracle SQL Developer, a graphical tool that enhances productivity and simplifies database development tasks.
Oracle Database SQL Developer Installation Guide - pdf tutorial
This Oracle SQL installation guide is helpful for those who plan to download SAL Developer kit (.zip ) file and install it as a freestanding tool
SQL Apply Best Practices: Oracle Data Guard 10g study guide and reference
With Oracle Data Guard SQL Apply in Oracle Database 10g, Oracle is addressing the requirements of the business community for an online disaster-recovery solution that also provides a means to offload reporting and decision support operations from he primary database
Oracle SQL Model Clause version 10g - study guide and reference tutorial
Oracle Database 10g introduces an innovative approach to complex SQL calculations: the SQL Model clause.
Best Practices for Minimal Downtime Migration to ASM Oracle 10g tutorial
This oracle tutorial describes procedures to dramatically reduce downtime during the process of migrating Oracle databases residing on raw partitions, volumes or conventional file systems to Automatic Storage Management (ASM) by using Oracle Recovery Manager (RMAN) and Oracle Data Guard.

Latest added ORACLE Database Tutorials

New Features in Oracle Database 10g
This tutorial provides the details of New Features in Oracle Database 10g
Oracle Rdb 7 Guide to SQL Programming - pdf tutorial
This manual describes how to design and develop host language application programs that use SQL (structured query language) to store, modify, and retrieve data from Oracle Rdb databases.
Oracle interview questions and answers
These are some common oracle interview questions with answers.
Oracle SQL Developer Data Modeler Naming Standardization reference guide
SQL Developer Data Modeler provides and uses different elements when applying naming standards to models. You can define and then apply these standards to the different models available in SQL Developer Data Modeler.
Oracle SQL Developer 1.5.5 download and installation
To install Oracle SQL Developer 1.5.5 download the file and unzip into an empty folder. Select the "Use folder names" checkbox when unzipping the file. A Check for Updates facility is available to install third-party database drivers, if required.
Oracle SQL Model Clause version 10g - study guide and reference tutorial
Oracle Database 10g introduces an innovative approach to complex SQL calculations: the SQL Model clause.
SQL Apply Best Practices: Oracle Data Guard 10g study guide and reference
With Oracle Data Guard SQL Apply in Oracle Database 10g, Oracle is addressing the requirements of the business community for an online disaster-recovery solution that also provides a means to offload reporting and decision support operations from he primary database
Oracle Database SQL Developer Installation Guide - pdf tutorial
This Oracle SQL installation guide is helpful for those who plan to download SAL Developer kit (.zip ) file and install it as a freestanding tool
Best Practices for Minimal Downtime Migration to ASM Oracle 10g tutorial
This oracle tutorial describes procedures to dramatically reduce downtime during the process of migrating Oracle databases residing on raw partitions, volumes or conventional file systems to Automatic Storage Management (ASM) by using Oracle Recovery Manager (RMAN) and Oracle Data Guard.
Oracle SQL Developer Data Modeler tutorial and reference
Oracle SQL Developer Data Modeler is a new, graphical data modeling tool that facilitates and enhances communication between data architects, database administrators, application developers and users, and simplifies the data modeling development process itself.