Beginning PL/SQL: From Novice to Professional

by Donald Bales

Overview

Beginning PL/SQL is a fast-paced and blissfully short introduction to Oracle's PL/SQL language. PL/SQL is the built-in language that every Oracle developer and database administrator simply must know. The book shows readers how to apply object-oriented PL/SQL to production applications. No other book on PL/SQL does this. It gives the reader practical advice on what works and what doesn’t, and advises on the performance tradeoffs between doing work in SQL versus in PL/SQL. This book gets readers up-to-speed on the core of the language without wasting time on esoteric and seldom used syntax.

Product Details

ISBN-13:	9781590598825
Publisher:	Apress
Publication date:	08/27/2007
Series:	Expert's Voice in Oracle Series
Edition description:	1st ed.
Pages:	476
Product dimensions:	7.01(w) x 9.25(h) x 0.04(d)

About the Author

Donald Bales is a computer applications consultant specializing in the analysis, design, and programming of client-server and web-based distributed systems, systems integration, and data warehousing. Don has over 20 years of experience with Oracle as both a developer and a database administrator, and 10 years of experience with Java. He is currently working on the migration of medical and industrial hygiene systems to a web environment for a major oil company. When he is not developing applications, Donald can often be found working with horses, playing the piano, or playing the bagpipes. Donald has had several careers, and has at various times been a mechanic, a general contractor, Mr. Mom, a developer, and currently a consultant. He has a bachelor of science degree in business from Elmhurst College in Illinois. Don resides in Downers Grove, Illinois, with his wife, Diane, and his daughter, Kristyn. He can be contacted by e-mail at [e-mail].

Table of Contents

A table of contents is not available for this title.

Editorial Reviews

You can get rolling with Oracle PL/SQL faster than you think -- and when we say "get rolling," we mean actually start solving business problems, not just fooling around. Beginning PL/SQL: From Novice to Professional is the book can get you there. This is no fancied-up restatement of the "Help": It's a well distilled, surprisingly brief, relentlessly practical introduction to the PL/SQL features developers and DBAs really need to understand in order to write production code.

Which features are those? Well, variables and datatypes; statement execution; cursors; debugging; and testing -- as well as PL/SQL's use in both relational and object-oriented programs. But it's not just about features: As seasoned developers know, it's about writing efficient, maintainable, modular, and reusable code, too. Bales brings two full decades of experience with Oracle, and that experience shows on every page. Bill Camarda, from the October 2007 Read Only