Learning Oracle Pl/SQL

by
Edition: 1st
Format: Paperback
Pub. Date: 2001-11-01
Publisher(s): Oreilly & Associates Inc
List Price: $49.99

Buy New

Usually Ships in 5-7 Business Days
$49.94

Rent Textbook

Select for Price
There was a problem. Please try again later.

Rent Digital

Rent Digital Options
Online:1825 Days access
Downloadable:Lifetime Access
$47.99
*To support the delivery of the digital material to you, a digital delivery fee of $3.99 will be charged on each digital item.
$47.99*

Used Textbook

We're Sorry
Sold Out

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

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.

Author Biography

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.

Table of Contents

Preface xi
PL/SQL: What, When, and Where
1(19)
What Is PL/SQL?
1(8)
Why Use PL/SQL?
9(6)
What You Need to Get Started with PL/SQL
15(5)
Fundamentals
20(42)
PL/Lingo
20(2)
Running Your First PL/SQL Program
22(4)
Introduction to Program Structure
26(4)
Variables
30(7)
Common Operators
37(7)
Conditional Logic
44(4)
Executing in Circles: Loop Statements
48(6)
Code Formatting: Requirements and Guidelines
54(2)
Some Advanced Fundamentals
56(6)
Let's Code!
62(44)
Some Background on the Example
62(2)
A First Programming Exercise
64(15)
Retrieving a Book Count with a Function
79(4)
Make Your Code Resilient
83(6)
Using PL/SQL Packages to Organize Code
89(11)
Going to the Next Level
100(4)
Now What?
104(2)
Go Web, Young Man
106(45)
Introduction to HTML
107(10)
Using PL/SQL to Create Web Pages
117(32)
What Else?
149(2)
Fetch!
151(45)
What's the Big Deal?
151(1)
A Simple-Minded Approach to Retrieving One Row
152(2)
Retrieving More than One Row Using a Cursor
154(11)
Presenting Query Results via a Web Page
165(5)
Building a Web-Based Search Page Using Dynamic SQL
170(17)
Advanced Data Retrieval Topics
187(9)
Keeping House
196(29)
Organize Your Code
196(13)
Use Tools to Write Code Effectively
209(16)
Security: Keep the Bad Guys Out
225(41)
Oracle Security Primer
226(9)
Organizing Accounts to Improve Security
235(11)
Analyzing the Library System's Requirements
246(6)
Keeping a Trail of Database Changes
252(8)
Special Security Topics for PL/SQL Developers
260(6)
Communicating with the Outside World
266(36)
Sending Internet Email from PL/SQL
267(5)
Using the Mail Sender in the Library System
272(3)
Receiving Email Inside the Database
275(9)
Fetching Data from a Remote Web Site
284(12)
Integration with Other Languages
296(6)
Intermediate Topics and Other Diversions
302(59)
Riding the Software Lifecycle
303(2)
Lists o'Stuff (Collections) in PL/SQL
305(12)
Exception-Handling Packages
317(5)
Transaction Control
322(5)
The PL/SQL Compiler
327(4)
Managing Patron and Librarian Privileges
331(20)
Still More PL/SQL Features
351(10)
``Making Good'' of Database Programming 361(6)
The Evidence
361(2)
The Problem
363(1)
Answering the Objections
364(1)
What to Do
365(2)
Glossary 367(14)
Index 381

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.