Oracle Database 11g PLSQL Programming – Michael McLaughlin – 1st Edition


This is designed to be read from beginning to end by those new toPL/SQL. Part I covers PL/ fundamentals. Part II covers the backboneof the programming language; which consists of functions; ;packages; triggers; and large objects. Part III dives into some advancedtopics that should help you immediately with your development projects.
The appendixes in Part IV provide primers on Oracle DBA tasks; programming;PHP scripting; development; regular expressions; and wrapping PL/SQL. Introductoryprimers are provided to help you learn about the PL/ Hierarchical Profiler and PL/Scope.
There is also an appendix that reviews reserved words and built-in that supportyour programming tasks.

View more

Table of Contents

PART I PL/SQL Fundamentals
1 Oracle PL/SQL Overview
2 PL/SQL Basics
3 Language Fundamentals
4 Control Structures
5 Error Management

PART II PL/SQL Programming
6 Functions and Procedures
7 Collections
8 Large Objects
9 Packages
10 Triggers

PART III PL/SQL Advanced Programming
11 Dynamic SQL
12 Intersession Communication
13 External Procedures
14 Object Types
15 Java Libraries
16 Web Application Development

PART IV Appendixes
A Oracle Database Administration Primer
B Oracle Database SQL Primer
C PHP Primer
D Oracle Database Java Primer
E Regular Expression Primer
F Wrapping PL/SQL Code Primer
G PL/SQL Hierarchical Profiler Primer
H PL/Scope
I PL/SQL Reserved Words and Keywords
J PL/SQL Built-in Functions

Leave us a commentNo Comments

Inline Feedbacks
View all comments
Would love your thoughts, please comment.x