Easy Oracle PL/SQL Programming

Get Started Fast with Working PL/SQL Code Examples - Includes Oracle 10g

John Garmany - Collection Easy Oracle Series

200 pages, parution le 01/01/2006

Ajouter à une liste

Indisponible

Résumé

Easy Oracle PL/SQL provides you with the tools you need to create, debug and execute PL/SQL code. The example driven methodology will have you coding basic PL/SQL blocks by the end of the first chapter. Each chapter will build on previous concepts, introducing you to increasingly more complex PL/SQL coding, while always focusing on readability and manageability. Each concept is introduced using multiple examples and each chapter has exercises to test your knowledge. With Easy Oracle PL/SQL you will be able to put the incredible power of the Oracle Database to use with your application.

Key Features:

Learn PL/SQL basics, anonymous blocks, stored procedures and functions.
Implement Best Practices to make your code readable and maintainable.
Understand PL/SQL variable including user defined and abstract datatypes.
Learn PL/SQL language structures including if/then/else and loops.
Become skilled at handling exceptions.
Learn to effectively use Cursors and Ref Cursors.
Begin working with Collections, Arrays, and PL/SQL Tables.
Improve performance with Bulk Collects and Loads.
See the power of packages including creating and using packages.
Call PL/SQL procedures and functions from applications.
Run PL/SQL from a script or database job.
Learn how to use triggers to react to database events

L'auteur - John Garmany

John Garmany is a Senior Oracle DBA with Burleson Consulting. A graduate of West Point, an Airborne Ranger and a retired Lt. Colonel with 20+ years of IT experience. John is an OCP Certified Oracle DBA with a Master Degree in Information Systems, a Graduate Certificate in Software Engineering, and a BS degree (Electrical Engineering) from West Point. A respected Oracle expert and author, John serves as a writer for Oracle Internals, DBAZine and SearchOracle and SELECT Magazine. John is also the author of four bestselling Oracle books by Rampant TechPress, Oracle Press and CRC Press and hosts a popular Oracle Application Server Newsletter.

Sommaire

Using the Online Code Depot
Conventions Used in this Book
Acknowledgments
Preface
Introduction to PL/SQL
PL/SQL Flow Control
Procedures, Functionss and Exception Handling
Using SQL and Cursors
Bulk Operations, Packages and Triggers
Index
About John Garmany
About Mike Reed

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Rampant
Auteur(s)	John Garmany
Collection	Easy Oracle Series
Parution	01/01/2006
Nb. de pages	200
Format	18 x 23
Couverture	Broché
Poids	410g
Intérieur	Noir et Blanc
EAN13	9780975913574
ISBN13	978-0-9759135-7-4