Share
Create bookmark
Oracle PL/SQL Programming
Notes
Please login to add notes
- Table of Contents
-
+
Preface
- Part I
-
+
Introduction to PL/SQL
- What Is PL/SQL?
- + The Origins of PL/SQL
- + So This Is PL/SQL
-
+
About PL/SQL Versions
-
+
Oracle Database 10g New Features
- Optimized compiler
- Compile-time warnings
- Conditional compilation
- Support for nonsequential collections in FORALL
- Improved datatype support
- Backtrace an exception to its line number
- Set operators for nested tables
- Support for regular expressions
- Programmer-defined quoting mechanism
- Many new built-in packages
-
+
Oracle Database 10g New Features
- + Resources for PL/SQL Developers
- + Some Words of Advice
- + Creating and Running PL/SQL Code
-
+
Language Fundamentals
- Part II
-
+
Conditional and Sequential Control
-
+
Iterative Processing with Loops
- + Exception Handlers
- Part III
- + Working with Program Data
-
+
Strings
-
+
Numbers
-
+
Dates and Timestamps
-
+
Records
-
+
Collections
- + Miscellaneous Datatypes
- Part IV
- + DML and Transaction Management
-
+
Data Retrieval
- + Dynamic SQL and Dynamic PL/SQL
- Part V
- + Procedures, Functions, and Parameters
-
+
Packages
- + Triggers
-
+
Managing PL/SQL Code
-
+
Managing Code in the Database
- + Using Native Compilation
-
+
Using the Optimizing Compiler and CompileTime Warnings
- The Optimizing Compiler
- + Compile-Time Warnings
-
+
Warnings Available in Oracle Database 10g
- PLW-05000: mismatch in NOCOPY qualification between specification and body
- PLW-05001: previous use of 'string' (at line string) conflicts with this use
- PLW-05003: same actual parameter(string and string) at IN and NOCOPY may have side effects
- PLW-05004: identifier string is also declared in STANDARD or is a SQL built-in
- PLW-05005: function string returns without value at line string
- PLW-06002: unreachable code
- PLW-07203: parameter 'string' may benefit from use of the NOCOPY compiler hint
- PLW-07204: conversion away from column type may result in sub-optimal query plan
-
+
Conditional Compilation
- + Testing PL/SQL Programs
-
+
Debugging PL/SQL Programs
-
+
Tuning PL/SQL Programs
- Analyzing Performance of PL/SQL Code
-
+
Optimizing PL/SQL Performance
- Use the most aggressive compiler optimization level possible
- Use BULK COLLECT when querying multiple rows
- Use FORALL when modifying multiple rows
- Use the NOCOPY hint when passing large structures
- Use PLS_INTEGER for intensive integer computations.
- Use BINARY_FLOAT or BINARY_DOUBLE for floating-point arithmetic
- Group together related programs in a package
- Pin into shared memory large and frequently executed programs.
- + Protecting Stored Code
-
+
Managing Code in the Database
-
+
I/O and PL/SQL
- Part VI
-
+
Application Security and PL/SQL
- + Inside PL/SQL
- + Globalization and Localization in PL/SQL
- + Object-Oriented Aspects of PL/SQL
- + Calling Java from PL/SQL
- + External Procedures
- + Regular Expression Metacharacters and Function Parameters
- Number Format Models
- Date Format Models
- Index
For the past ten years, O'Reilly's Oracle PL/SQL Programming has been the bestselling book on PL/SQL, Oracle's powerful procedural language. Packed with examples and helpful recommendations, the book has helped everyone--from novices to experienced developers, and from Oracle Forms developers to database administrators--make the most of PL/SQL. The fourth edition is a comprehensive update, adding significant new content and extending coverage to include the very latest Oracle version, Oracle Database 10g Release 2. It describes such new features as the PL/SQL optimizing compiler, conditional compilation, compile-time warnings, regular expressions, set operators for nested tables, nonsequential collections in FORALL, the programmer-defined quoting mechanism, the ability to backtrace an exception to a line number, a variety of new built-in packages, and support for IEEE 754 compliant floating- point numbers. The new edition adds brand-new chapters on security (including encryption, row-level security, fine-grained auditing, and application contexts), file, email, and web I/O (including the built-in packages DBMS_OUTPUT, UTL_FILE, UTL_MAIL, UTL_SMTP, and UTL_HTTP) and globalization and localization. Co-authored by the world's foremost PL/SQL authority, Steven Feuerstein, this classic reference provides language syntax, best practices, and extensive code, ranging from simple examples to complete applications-- making it a must-have on your road to PL/SQL mastery. A companion web site contains many more examples and additional technical content for enhanced learning.
Test the closed alpha on paperc.com
Book Details
Authors
Steven Feuerstein and Bill Pribyl
Categories
Computers > Programming Languages > SQL
Publishers
Publication year : 2005
License: All rights reserved ©
Times read: 1,429
