Oracle PL/SQL for Dummies

by Michael Rosenblum, Paul Dorsey

Oracle PL/SQL For Dummies shows novice Oracle programmers how to use PL/SQL, the procedural programming language embedded in Oracle, to develop Oracle applications. This book introduces PL/SQL and its relationship to SQL and includes coverage of the following: getting started with PL/SQL (e.g., language fundamentals, program control, exception handling, and packages); Oracle-specific programming topics (e.g., Oracle constructs of interest to PL/SQL developers and code-placement options); advanced PL/SQL (e.g., manipulating strings, manipulating dates, and manipulating numbers). The book also includes a database primer chapter, coverage of best practices (based on actual system-building experience) in sidebars throughout and in a full chapter, and coding and naming standards that can be adopted by organizations. About The Author: Dr. Paul Dorsey is the founder of Dulcian, Inc., an Oracle consulting firm, where he models and codes database applications and trains clients to develop Oracle database systems. He is the co-author of seven Oracle Press books. Paul won the Oracle Development Tools User Group 2003 Volunteer of the Year award. He is on the Board of Directors of ODTUG, a Contributing Editor of the Int'l Oracle User's Group SELECT Journal, President of the NY Oracle Users' Group, and the founder and chairperson of the ODTUG Business Rules/Best Practices Symposium. Michael Rosenblum is a Development DBA at Dulcian, Inc., where he is responsible for system tuning and application architecture and writing complex PL/SQL routines. He presents at reg'l and nat'l Oracle user group conferences. Table Of Contents: Introduction Part I: Basic PL/SQL Concepts ?PL/SQL and Your Database ?The PL/SQL Environment Part II: Getting Started with PL/SQL ?Laying the Groundwork: PL/SQL Fundamentals ?Controlling Program Flow ?Handling Exceptions ?PL/SQL and SQL Working Together Part III: Standards and Structures ?Putting Your Code in the Right Place ?Creating Naming Standards ?Crea

434 pages, Paperback

First published May 1, 2006

Reviews

[Daniel · Rating 3 out of 5]

well, I didn't quite complete the book but read the first half and skimmed the rest. It was funny to see the Ada influence on PL/SQL - the:= for assignment, the IN, OUT, IN OUT for parameters, the exceptions concept, ....

It's a good book for a refresher or learn it for the first time in a non-text book way.

[Ross · Rating 3 out of 5]

Very interesting an technically challanging.

[Chano · Rating 5 out of 5]

It helped me to refresh my memory on PL/SQL and even gained some new knowledge regarding coding and naming standards. Quite a good book for anyone.

[Rahul Pandey]

ok

[Abhinav Dubey · Rating 4 out of 5]

for quick basic tips