Skip to content

Learning Oracle PL/SQL

Spend $50 to get a free DVD!

ISBN-10: 0596001800

ISBN-13: 9780596001803

Edition: 2001

Authors: Bill Pribyl, Steven Feuerstein, Debby Russell

List price: $49.99
Shipping box This item qualifies for FREE shipping.
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

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…    
Customers also bought

Book details

List price: $49.99
Copyright year: 2001
Publisher: O'Reilly Media, Incorporated
Publication date: 12/1/2001
Binding: Paperback
Pages: 432
Size: 7.00" wide x 9.00" long x 1.00" tall
Weight: 1.496
Language: English

Bill Pribyl, author, teacher, and software consultant,is the primary author of Learning Oracle PL/SQL and the coauthor of Oracle PL/SQL Programming and its companion pocket reference, all published by O'Reilly & Associates. An Oracle user since 1986, Bill has consulted on many aspects of using Oracle products. He recently spearheaded PLNet.org, a Web-based repository where developers can share open source PL/SQL.

Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language. He is the author or coauthor of Oracle PL/SQL Programming, Oracle PL/SQL Best Practices, Oracle PL/SQL Programming: Guide to Oracle8i Features, Oracle PL/SQL Developer's Workbook, Oracle Built-in Packages, Advanced Oracle PL/SQL Programming with Packages, and several pocket reference books (all from O'Reilly & Associates). Steven is a Senior Technology Advisor with Quest Software, has been developing software since 1980, and worked for Oracle Corporation from 1987 to 1992.

Preface
PL/SQL: What, When, and Where
What Is PL/SQL?
Why Use PL/SQL?
What You Need to Get Started with PL/SQL
Fundamentals
PL/Lingo
Running Your First PL/SQL Program
Introduction to Program Structure
Variables
Common Operators
Conditional Logic
Executing in Circles: Loop Statements
Code Formatting: Requirements and Guidelines
Some Advanced Fundamentals
Let's Code!
Some Background on the Example
A First Programming Exercise
Retrieving a Book Count with a Function
Make Your Code Resilient
Using PL/SQL Packages to Organize Code
Going to the Next Level
Now What?
Go Web, Young Man
Introduction to HTML
Using PL/SQL to Create Web Pages
What Else?
Fetch!
What's the Big Deal?
A Simple-Minded Approach to Retrieving One Row
Retrieving More than One Row Using a Cursor
Presenting Query Results via a Web Page
Building a Web-Based Search Page Using Dynamic SQL
Advanced Data Retrieval Topics
Keeping House
Organize Your Code
Use Tools to Write Code Effectively
Security: Keep the Bad Guys Out
Oracle Security Primer
Organizing Accounts to Improve Security
Analyzing the Library System's Requirements
Keeping a Trail of Database Changes
Special Security Topics for PL/SQL Developers
Communicating with the Outside World
Sending Internet Email from PL/SQL
Using the Mail Sender in the Library System
Receiving Email Inside the Database
Fetching Data from a Remote Web Site
Integration with Other Languages
Intermediate Topics and Other Diversions
Riding the Software Lifecycle
Lists o' Stuff (Collections) in PL/SQL
Exception-Handling Packages
Transaction Control
The PL/SQL Compiler
Managing Patron and Librarian Privileges
Still More PL/SQL Features
"Making Good" of Database Programming
The Evidence
The Problem
Answering the Objections
What to Do
Glossary
Index