Buy this Book
Print Book $49.99 Read it Now!
Print Book £28.50
Add to UK Cart
Reprint Licensing
Learning Oracle PL/SQL

By Bill Pribyl
With Steven Feuerstein
First Edition  November 2001 
Pages: 424
ISBN 10: 0-596-00180-0 | ISBN 13: 9780596001803
starstarstarstarstar (Average of 1 Customer Reviews)

Buy 2 Get 1 Free Free ShippingGuarantee

Book description

Designed for both new programmers and those experienced in other languages, this book presents the core features of Oracle's PL/SQL language in an easy-to-read format. Learning Oracle PL/SQL will bring programmers up to speed on the most important aspects of PL/SQL, including web and Internet programming. Updated through Oracle9i, includes sample programs downloadable from examples.oreilly.com/learnoracle.
Full Description

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.

Browse within this book

Cover | Table of Contents | Colophon



Featured customer reviews

Write a Review


Learning Oracle PL/SQL Review,  November 27 2002
Rating: StarStarStarStarStar
Submitted by Kenneth Wilcox   [Respond | View]

I’ve been a self taught Oracle PL/SQL developer for two years, so I was sceptical on reading a "Learning" book. After reading the first few chapters I was able to make improvements to my PL/SQL programs. It was definitely worth the time and money. The examples are well written and simple enough to make sense, but not too simple that they are "duh" type examples. I also liked the fact that the book explains how to set up and use Oracle/Apache to make PSP pages (Stored Procedures that generate web content). The PSP section makes up a good portion of the book that I didn’t know was in it before I got it. With plenty of real-world experience tips, a section on tools and security, it will be a while before I have this ingrained and used on a daily basis. I defiantly got more than I was looking for.

Read all reviews


Media reviews

"I've been a self taught Oracle PL/SQL developer for two years, so I was skeptical on reading a 'Learning' book. After reading the first few chapters I was able to make improvements to my PL/SQL programs. It was definitely worth the time and money. The examples are well written and simple enough to make sense, but not too simple that they are 'duh' type examples. I also liked the fact that the book explains how to set up and use Oracle/Apache to make PSP pages (Stored Procedures that generate web content). The PSP section makes up a good portion of the book that I didn't know was in it before I got it. With plenty of real-world experience tips, a section on tools and security, it will be a while before I have this ingrained and used on a daily basis. I defiantly got more than I was looking for."
--Kenneth Wilcox, Boise Software Developers Group, Dec 2002

"This is the first PL/SQL book written expressly for beginners. This has been a clear gap in the literature and this effort effectively plugs the hole. The book is clear and easy enough for novice PL/SQL programmers, and a very pleasant read even for more advanced IT professionals. It covers topics in enough depth that you will learn quite a lot even if you have been writing PL/SQL code for many years...No doubt that reading this book and applying its principles will make the reader a better PL/SQL programmer."
--Ileana Balcu, New York Oracle Users Group, March 2002

"'Learning Oracle PL/SQL' is one of the best books I have read on learning this subject. This book has a little for everyone: you'll learn something if you know the basics of SQL, but have never really done anything with it. You'll also learn something if you've had a lot of experience with Microsoft SQLServer (and T-SQL), but are looking to transition you knowledge to Oracle PL/SQL."--Salt Lake City ColdFusion User Group, March 2002

"As someone who knows C, Perl, and Java, I found this to be a great starter book in PL/SQL. It gave me the core knowledgeI needed for a jump-start into PL/SQL programming. This is a great book for anybody wanting to learn PL/SQL programming for Oracle!"--Bill Phillips, System Engineer, Diverse Networks

Read all reviews


See larger cover