Sams Teach Yourself Pl/SQL in 21 Days

by Gennick, Jonathan; Luers, Tom

• ISBN13: 9780672317989
• ISBN10: 0672317982
• Edition: 2nd
• Format: Paperback
• Copyright: 1999-12-22
• Publisher: Sams Publishing

Summary

Sams Teach Yourself PL/SQL in 21 Days, Second Edition, quickly empowers you to create your own Oracle solutions with PL/SQL. Completely revised to cover Oracles 8i, the book provides guidance and direction, leading you through a progression of topics that begin with the basic building blocks of PL/SQL, and ending with in-depth discussions of the more commonly used advanced features of Oracle's database programming environment. New topics include extended dynamic SQL within PL/SQL, Dynamic SQL within PL/SQL, use of invoker's rights, autonomous transactions, interfacing PL/SQL with Java, PL/SQL Bulk Binds, parameter passing by reference, and advanced Querying.

Author Biography

Jonathan Gennick is a professional developer with over seven years of experience working with relational database technology. As the lead database administrator for the utilities group of KPMG, Jonathan¿s duties include assisting programmers who need to write stored procedures and database triggers using Oracle PL/SQL. A member of MENSA, Jonathan holds a degree in Information & Computer Science from Andrews University in Berrien Springs, Michigan. His writing career began in 1997, when co-authored Teach Yourself PL/SQL in 21 Days. Since then he has been involved with four other book projects, serving as technical editor for Oracle8 Server Unleashed, the development editor for Sams Teach Yourself Access 2000 in 24 Hours, a technical reviewer for Oracle Database Administration, The Essential Reference, and the author of SQL*Plus, the Definitive Guide.

Table of Contents

Introduction	1	(4)
Week 1 At a Glance	5	(212)
Learning the Basics of PL/SQL	7	(26)
Writing Declarations and Blocks	33	(30)
Writing PL/SQL Expressions	63	(36)
Using Functions, IF Statements, and Loops	99	(28)
Implementing Loops and Gotos	127	(28)
Using Oracle's Built-In Functions	155	(34)
Procedures, Packages, Errors, and Exceptions	189	(28)
Week 1 In Review	217	(2)
Week 2 At a Glance	219	(214)
Using SQL	221	(24)
Manipulating Data with Cursors	245	(20)
Collections	265	(28)
Writing Database Triggers	293	(40)
Using Oracle8i Objects for Object-Oriented Programming	333	(38)
Debugging Your Code and Preventing Errors	371	(30)
Leveraging Large Object Types	401	(32)
Week 2 In Review	433	(2)
Week 3 At a Glance	435	(178)
Managing Transactions and Locks	437	(14)
Generating Dynamic SQL	451	(32)
Writing to Files and the Display	483	(26)
Managing Database Jobs	509	(22)
Alerting and Communicating with Other Procedures: The DBMS_ALERT and DBMS_PIPE Packages	531	(28)
PL/SQL and Java	559	(26)
Advanced Queuing	585	(28)
Week 3 In Review	613	(46)
A Answers	615	(44)
Index	659