We see that javascript is disabled or not supported by your browser - javascript is needed for important actions on the site. Read more

What's New - Home - Login

Member $avings: $81,606,388.66 | Books Available: 789,109 | Members Online: 263

Swap Used Books - Buy New Books at Great Prices!

How To Swap Books Sign Up Search submenu

PBS Market (New Books)

Gift Buying Guide

Book Browser Advanced Search Books Posted Today Member Book Reviews Award Winning Books NYT Best Sellers Amazon Best Sellers Most Traveled Copies Club Wish List

Discussion Forums Book Lists

Club Lists My Book Lists My Watched Lists Create a List

Blog Donations

School Donation Program In Memory of... Military Donation Program Friends of PBS

Box-O-Books Maps The Eclectic Pen Fun Stuff

20 Questions Sudoku Bookmark Creator

Top 100

Requests Posts Swappers Referrers Reviewers

Pulse of PBS Spread The Word

Invite Friends Bookmarks Facebook Page Facebook App More Ways...

Photo Gallery Recipes Club Tag Cloud Member Testimonials

Help Center submenu

How To Swap Books Browse Help Docs Ask the Librarian PBS Member Icons Live Help

Kiosk

PBS Market (New Books) Go Shopping Buy Credits Buy PBS Money Upgrade Membership Gift Certificates Transfer Credits

Need Help?

Search - Oracle PL/SQL Programming, Third Edition

Oracle PL/SQL Programming Third Edition
Author: Steven Feuerstein

Nearly a quarter-million PL/SQL programmers--novices and experienced developers alike--have found the first and second editions of Oracle PL/SQL Programming to be indispensable references to this powerful language. Packed with examples and recommendations, this book has helped everyone, from Oracle Forms developers to database administrat... more »ors, make the most of PL/SQL. This new edition is a comprehensive update of the original book, covering all versions of PL/SQL through Oracle9i Release 2. It adds much-requested new chapters on how to create and run PL/SQL programs, call Java methods from within PL/SQL, and define and use database triggers. An extensive new chapter--designed especially for experienced PL/SQL developers--describes PL/SQL's runtime architecture and how to use knowledge of Oracle internals to get the best performance from PL/SQL.The book contains information about the latest Oracle9i PL/SQL features, including:

Record-based DML: You can now use records in INSERT and DELETE statements.
Table functions: These are functions that return a result set (in the form of a PL/SQL collection). Such functions existed in Oracle8i but they are now much expanded.
New and improved datatypes: Oracle now offers dramatically improved support for timestamps, time zone management, and interval calculations. In addition, the XMLType datatype has now been implemented.
Inheritance for object types: You can now define a hierarchy of object types (which were first introduced in Oracle8).
Enhancements to PL/SQL collections. PL/SQL now supports multiple-level collections (nesting collections within collections), as well as associative arrays (previously called index-by tables), which allow you to index by PLS_INTEGER and VARCHAR2.
Native compilation of PL/SQL code: PL/SQL source code can now optionally be compiled into native object code that is linked into Oracle.

The book is divided into six parts:

Part I, Programming in PL/SQL
Part II, PL/SQL Program Structure
Part III, PL/SQL Program Data
Part IV, SQL in PL/SQL
Part V, PL/SQL Application Construction
Part VI, Advanced PL/SQL Topics

Even if you've been a PL/SQL developer for years, you'll find an enormous amount of new and revised information in this third edition and on its companion web site. If you're new to PL/SQL, you'll find Oracle PL/SQL Programming an invaluable companion on the road to mastery.

ISBN-13: 9780596003814
ISBN-10: 0596003811
Publication Date: 9/23/2002
Pages: 1,018
Rating:

Currently 3/5 Stars.

3 stars, based on 1 rating

Publisher: O'Reilly
Book Type: Paperback
Members Wishing: 0
Reviews: Amazon | Write a Review

Genres:

Computers & Technology >> Programming >> General
Computers & Technology >> Databases & Big Data >> Database Management Systems
Computers & Technology >> Databases & Big Data >> Other Databases >> SQL >> General
Computers & Technology >> Databases & Big Data >> Other Databases >> Oracle >> General
Computers & Technology >> Databases & Big Data >> Other Databases >> Oracle >> Databases
Computers & Technology >> Databases & Big Data >> General
Computers & Technology >> General

Back to the Top ↑

Search - Oracle PL/SQL Programming, Third Edition

Loading...