Learning Oracle PL/SQL Oracle Development Languages

Name: Learning Oracle PL/SQL Oracle Development Languages
Price: 8.43 USD
Availability: InStock
ISBN: 9780596001803

ISBN-10: 0596001800

ISBN-13: 9780596001803

Edition: 2001

Authors: Bill Pribyl, Steven Feuerstein, Debby Russell

List price: $49.99

30 day, 100% satisfaction guarantee!

Buy new: $34.51

Marketplace

4 new & used from $8.43

what's this?

Rush Rewards U
Members Receive:

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…

Book details

List price: $49.99
Copyright year: 2001
Publisher: O'Reilly Media, Incorporated
Publication date: 12/11/2001
Binding: Paperback
Pages: 426
Size: 7.00" wide x 9.19" long x 1.09" 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