Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Overview

PL/SQL, Oracle's programming language for stored procedures, delivers a world of possibilities for your database programs. PL/SQL supplements the standard relational database language, SQL, with a wide range of procedural features, including loops, IF-THEN statements, advanced data structures, and rich transactional control--all closely integrated with the Oracle database server. Knowing where to start with Oracle's procedural language is not always obvious to a newcomer, especially considering the language's feature set and the sheer size of the official documentation (not to mention Oracle's ever-increasing number of pre-built PL/SQL programs). But Learning Oracle PL/SQL offers the signposts and guidance you need to come up to speed on the language, delivered in a manageable number of pages while covering all the essentials. Topics include:

  • PL/SQL--what is it, and why use it? Why use PL/SQL instead of Java?

  • Syntax and examples of all core language constructs

  • Creating, using, and reusing stored procedures, functions, and packages

  • Building web-based applications using PL/SQL features available "out of the box" (such as PL/SQL Server Pages)

  • Securing PL/SQL programs against attack

  • Benefits of third-party developer tools and integrated development environments

  • Connecting PL/SQL to email, Java, and the Internet

Meticulously crafted with all-new examples downloadable from examples.oreilly.com/learnoracle, the book addresses language features available in all versions of Oracle, from Oracle7 to Oracle8i to Oracle9i. Learning Oracle PL/SQL was written by PL/SQL experts Bill Pribyl and Steven Feuerstein, whose easy-to-read style and attention to detail has made other O'Reilly books (such as the bestselling Oracle PL/SQL Programming) very popular among Oracle developers worldwide. Learning Oracle PL/SQL is meant for a wide range of target audiences, including both beginning programmers and those already experienced with other programming languages. Whether you are a new developer, a crossover programmer from another database system, or a new database administrator who needs to learn PL/SQL, this book will get you well on your way. It is the perfect introduction to Oracle PL/SQL Programming, also by Pribyl and Feuerstein.

Subscriber Reviews

Average Rating: 3 out of 5 rating Based on 2 Ratings

"Learning PL/SQL" - by farmkittie on 23-NOV-2011
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
Good introduction to PL/SQL.  I don't know why the other rater gave it one star and then didn't explain.  This book gave me a solid introduction a few years ago so that I was able to solve problems at work and continue with reading more advanced PL/SQL books.
Report as Inappropriate

"LEARNING ORACLE PL/SQL" - by LEARNING ORACLE on 17-MAR-2010
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
BOOK
Report as Inappropriate

Table of Contents

 Index

Extras

The publisher has provided additional content related to this title.


Description
Content

Visit the catalog page for Learning Oracle PL/SQL

  • Catalog Page

Visit the errata page for Learning Oracle PL/SQL

  • Errata

Download the supplemental electronic content for Learning Oracle PL/SQL

  • Supplemental Content