Skip to content

Oracle Database 10g PL/SQL Programming

Spend $50 to get a free DVD!

ISBN-10: 0072230665

ISBN-13: 9780072230666

Edition: 2004

Authors: Scott Urman, Lisa McClain, McGraw-Hill Staff, Ron Hardman, Michael McLaughlin

List price: $57.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!

Description:

This reference for PL/SQL has been revised and expanded, featuring all new examples throughout based on the new Oracle Database 10g.
Customers also bought

Book details

List price: $57.99
Copyright year: 2004
Publisher: McGraw-Hill Education
Publication date: 10/7/2004
Binding: Paperback
Pages: 896
Size: 7.30" wide x 9.20" long x 1.72" tall
Weight: 3.146
Language: English

Scott Urman (Foster City, CA) is a senior member of the diagnostic and defect technical staff in the Language Group of Oracle Support Services, where he aids users of Oracle's various language products (PL/SQL, OCI, and the Oracle precompilers). In addition, he reviews Oracle technical documentation, writes white papers on Oracle languages, and makes technical presentations both inside Oracle and at meetings of Oracle User's Groups. Scott is the best-selling author of Oracle Press' Oracle PL/SQL Programming and Oracle8 PL/SQL Programming.

McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide

Michael McLaughlin, Oracle ACE (Rexburg, ID) is a professor at BYU – Idaho in the Computer Information Technology Department of the Business and Communications School. He is the author of Oracle Database 12c PL/SQL Programming, MySQL Workbench, and several other Oracle Press books.John Harper (Lehi, UT) is a principal database engineer for the Church of Jesus Christ of Latter-day Saints and the co-author, with Michael McLaughlin, of Oracle Database 11g PL/SQL Programming Workbook.

Introduction
Introduction to PL/SQL
Introduction to Programming Languages
PL/What?
Language Fundamentals
PL/SQL Statement Processing
Getting the Most from This Book
Summary
Using SQL*Plus and JDeveloper
SQL*Plus
JDeveloper
Summary
PL/SQL Basics
The PL/SQL Block
Language Rules and Conventions
PL/SQL Data Types
Using Variables
Hiding Code
Expressions
Controlling Program Flow
Summary
Using SQL with PL/SQL
Transaction Processing
Retrieving Data
Cursors
DML and DDL
Using ROWID and ROWNUM
Built-in SQL Functions
Summary
Records
Introducing Records
Summary
Collections
Introducing Collections
Working with Collections
Oracle 10g Collection API
Summary
Error Handling
What Is an Exception?
Exception Propagation
Exception Guidelines
Summary
Creating Procedures, Functions, and Packages
Procedures and Functions
Packages
Summary
Using Procedures, Functions, and Packages
Subprogram Locations
Considerations of Stored Subprograms and Pakcages
Stored Functions and SQL Statements
Native Compilation
Pinning in the Shared Pool
Summary
Database Triggers
Types of Triggers
Creating Triggers
Mutating Tables
Summary
Advanced PL/SQL Features
Intersession Communication
Introducing Intersession Communication
The DBMS_PIPE Built-in Package
DBMS_ALERT Built-in Package
Summary
External Routines
Introducing External Procedures
Working with External Procedures
Troubleshooting the Shared Library
Summary
Dynamic SQL
Introducing Dynamic SQL
Working with Native Dynamic SQL
Working with the Oracle DBMS_SQL Built-in Package
Summary
Introduction to Objects
Introduction to Object-Oriented Programming
Object Type Overview
Creating Object Types
Object Type Inheritance
Attribute Chaining
Making Changes
Summary
Objects in the Database
Introduction to Objects in the Database
Accessing Persistent Objects Using SQL and PL/SQL
Maintaining Persistent Objects
Summary
Large Objects
Introduction to Large Objects
LOBs and SQL
LOBs and PL/SQL
Performance Considerations
Summary
Scheduling Tasks
Introducing DBMS_JOB
Oracle Scheduler
Summary
Appendixes
PL/SQL Reserved Words
Table of Reserved Words
Guide to Supplied Packages
SYS-Owned Built-in Packages
CTXSYS-Owned Built-in Packages
Index