Oracle PL/SQL Programming, Third Edition

3.88 avg rating
( 229 ratings by Goodreads )
 
9780596003814: Oracle PL/SQL Programming, Third Edition

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 administrators, 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 withincollections), 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.

"synopsis" may belong to another edition of this title.

Review:

If you're doing database application development in the Oracle environment, you're going to have to know PL/SQL, the company's extended query and update language. If you want your programs to exploit the special capabilities of Oracle software, you'll need to know the language well. That's where the third edition of Oracle PL/SQL Programming comes into play. It's an absolutely comprehensive reference (as well as a rather extensive tutorial) on PL/SQL, ideally suited to answering your questions about how to perform some programming tasks and reminding you of the characteristics of functions, triggers, and other elements of the database programmer's toolkit. The new edition covers calls to Java methods from within PL/SQL programs, autonomous transactions, object type inheritance, and the new Timestamp and XMLType data types. There's also more information about server internals--the way PL/SQL programs are run--than before, better enabling readers to optimize their code for fast and safe execution.

Steven Feuerstein takes care to explain, with prose and example code, the characteristics of PL/SQL elements. In explaining number conversions, for example, he explores Oracle's different ways of formatting numbers, then details the behavior of the to_number function under different conditions (with and without a specified format model, and with National Language Support information attached). It's a helpful approach that will have readers using the index to locate places in which Feuerstein mentions language elements of interest. --David Wall

Topics covered: How to use Oracle PL/SQL in all its manifestations through Oracle9i. Fundamentals of program structure (loops, cases, exceptions, etc.) and execution get attention, as do data types, transaction management, triggers, and the object-oriented aspects of the language. There's also coverage of calls to external Java and C programs.

About the Author:

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.

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.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Steven Feuerstein
Published by O'Reilly Media (2002)
ISBN 10: 0596003811 ISBN 13: 9780596003814
New Paperback Quantity Available: 2
Seller:
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description O'Reilly Media, 2002. Paperback. Book Condition: New. Never used!. Bookseller Inventory # P110596003811

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 42.45
Convert Currency

Add to Basket

Shipping: US$ 1.99
Within U.S.A.
Destination, Rates & Speeds

2.

Steven Feuerstein, Bill Pribyl
Published by O Reilly Media, Inc, USA, United States (2002)
ISBN 10: 0596003811 ISBN 13: 9780596003814
New Paperback Quantity Available: 1
Seller:
The Book Depository US
(London, United Kingdom)
Rating
[?]

Book Description O Reilly Media, Inc, USA, United States, 2002. Paperback. Book Condition: New. 3rd Revised edition. Language: English . Brand New Book. This text has been thoroughly revised and updated to include the latest Oracle releases - Oracle8i and Oracle9i - the Internet databases that communicate with other technologies, such as Java, to run powerful e-commerce applications. Oracle has made substantial changes to the PL/SQL language, and developers who want to take full advantage of its power should find the information they need in this book. This new edition of the book includes all PL/S QL language features up to and including Oracle 9i Release 2 (9.2). Regardless of the version you are using, from Oracle 7.3.4 to Oracle 9i, this book will answer your questions. In addition, Oracle PL/SQL Programming now contains much-requested new chapters on Oracle triggers, the internal architecture of PL/SQL in the Oracle database, and the use of PL/SQL with Java. The authors have carefully constructed each chapter of this edition with three objectives: to help you take full advantage of PL/SQL, learn to use PL/SQL to solve your problems, and to write efficient, maintainable code. Beginning with an introduction to PL/SQL programming and continuing through advanced PL/SQL topics, the book covers: PL/SQL language fundamentals; PL/SQL program structure; types of program data; the connection of PL/SQL to the underlying database; application construction; managing your PL/SQL code base; if you re new to PL/SQL, reading this book will improve your skills and help your understanding. If you re already a proficient PL/SQL programmer, you ll be able to extract particular techniques for immediate application. Whether you use this book as a teaching guide or reference, you ll find it will have a significant impact on your ability to use PL/SQL more effectively. Bookseller Inventory # PEA9780596003814

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 56.07
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

3.

Steven Feuerstein
Published by O'REILLY & ASSOCIATES
ISBN 10: 0596003811 ISBN 13: 9780596003814
New soft Quantity Available: 1
Seller:
Agapea Libros Urgentes
(Malaga, Spain)
Rating
[?]

Book Description O'REILLY & ASSOCIATES. soft. Book Condition: New. *** Nota: EL COSTE DE ENVÍO A CANARIAS ES 9.99 EUROS. Si ha realizado un pedido con destino a CANARIAS no podemos hacer el envío con el coste actual. Nos pondremos en contacto con usted para comunicar el coste total del envío a Canarias y si está de acuerdo, Abebooks le efectuará el cargo adicional. Bookseller Inventory # 247616

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 49.11
Convert Currency

Add to Basket

Shipping: US$ 11.77
From Spain to U.S.A.
Destination, Rates & Speeds

4.

Steven Feuerstein, Bill Pribyl
Published by O Reilly Media, Inc, USA, United States (2002)
ISBN 10: 0596003811 ISBN 13: 9780596003814
New Paperback Quantity Available: 1
Seller:
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description O Reilly Media, Inc, USA, United States, 2002. Paperback. Book Condition: New. 3rd Revised edition. Language: English . Brand New Book. This text has been thoroughly revised and updated to include the latest Oracle releases - Oracle8i and Oracle9i - the Internet databases that communicate with other technologies, such as Java, to run powerful e-commerce applications. Oracle has made substantial changes to the PL/SQL language, and developers who want to take full advantage of its power should find the information they need in this book. This new edition of the book includes all PL/S QL language features up to and including Oracle 9i Release 2 (9.2). Regardless of the version you are using, from Oracle 7.3.4 to Oracle 9i, this book will answer your questions. In addition, Oracle PL/SQL Programming now contains much-requested new chapters on Oracle triggers, the internal architecture of PL/SQL in the Oracle database, and the use of PL/SQL with Java. The authors have carefully constructed each chapter of this edition with three objectives: to help you take full advantage of PL/SQL, learn to use PL/SQL to solve your problems, and to write efficient, maintainable code. Beginning with an introduction to PL/SQL programming and continuing through advanced PL/SQL topics, the book covers: PL/SQL language fundamentals; PL/SQL program structure; types of program data; the connection of PL/SQL to the underlying database; application construction; managing your PL/SQL code base; if you re new to PL/SQL, reading this book will improve your skills and help your understanding. If you re already a proficient PL/SQL programmer, you ll be able to extract particular techniques for immediate application. Whether you use this book as a teaching guide or reference, you ll find it will have a significant impact on your ability to use PL/SQL more effectively. Bookseller Inventory # PEA9780596003814

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 62.71
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

5.

Steven Feuerstein
Published by O'Reilly Media (2002)
ISBN 10: 0596003811 ISBN 13: 9780596003814
New Paperback Quantity Available: 1
Seller:
Irish Booksellers
(Rumford, ME, U.S.A.)
Rating
[?]

Book Description O'Reilly Media, 2002. Paperback. Book Condition: New. book. Bookseller Inventory # M0596003811

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 70.17
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

6.

Steven Feuerstein
Published by O'Reilly Media (2002)
ISBN 10: 0596003811 ISBN 13: 9780596003814
New Paperback Quantity Available: 1
Seller:
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description O'Reilly Media, 2002. Paperback. Book Condition: New. Third Edition. Bookseller Inventory # DADAX0596003811

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 91.02
Convert Currency

Add to Basket

Shipping: US$ 4.99
Within U.S.A.
Destination, Rates & Speeds