Mastering Oracle PL/SQL: Practical Solutions

Connor McDonald

Published by Apress, 2004
ISBN 10: 1590592174 / ISBN 13: 9781590592175
Used / Paperback / Quantity Available: 0
Available From More Booksellers
View all  copies of this book

About the Book

We're sorry; this specific copy is no longer available. AbeBooks has millions of books. We've listed similar copies below.

Description:

We ship International with Tracking Number! May not contain Access Codes or Supplements. Buy with confidence, excellent customer service! L. Bookseller Inventory #

About this title:

Book ratings provided by Goodreads:
4.14 avg rating
(14 ratings)

Synopsis:

Do you need more from a PL/SQL book than just the correct keywords and some pretty syntax diagrams? Have you been searching in vain for real-world examples and genuine strategies for maximizing the benefits of PL/SQL within your organization? You'll find them here in Mastering Oracle PL/SQL: Practical Solutions, the inaugural title of the pioneering OakTable Press series from Apress.

This isn't a tutorial on how to code PL/SQL. It's designed to show you how to code PL/SQL well. It shows you how to write code that will run quickly and wont break in high-load, multiuser environments. It covers the vast array of the functionality that PL/SQL provides, including effective handling of relational and abstract data, security, triggers, dynamic web content presentation from within the database, creation of a DBA toolkit, and effective debugging techniques.

This book sets out to redress the unjust criticism leveled at PL/SQL in years gone by. It gives you the tools and techniques to ensure that, whatever your needs are, the PL/SQL you build will run as efficiently as possible. The practical solutions provided in this book will help you to realize the true power and functionality PL/SQL can offer your projects.

If you're brand-new to PL/SQL, then you'll want to take some time to get familiar with the language before tackling this book. It's not for the total beginner. But once youre up and running, you'll find this book an invaluable guide for ensuring that the PL/SQL solutions you build are robust, perform well, and are easy to maintain.

What you’ll learn

Who this book is for

Mastering Oracle PL/SQL: Practical Solutions is targeted primarily toward the DBA or developer charged with the implementation of effective data handling, security, and database administration mechanisms in the Oracle database. However, it will also have great appeal to any developer whose applications rely on an Oracle database and who needs a sound understanding of how to use PL/SQL effectively.

Table of Contents

  1. Efficient PL/SQL
  2. Package It All Up
  3. The Vexed Subject of Cursors
  4. Effective Data Handling
  5. PL/SQL Optimization Techniques
  6. Triggers
  7. DBA Packages
  8. Security Packages
  9. Web Packages
  10. PL/SQL Debugging

About the Author: Christopher Beck has a bachelor's degree in computer science from Rutgers University and has been working in the technology industry for 11 years. Starting off as a junior Ada software developer for a government systems integrator, he has spent the past 7 years with Oracle, most recently as a principal technologist. He specializes in core database technologies and web application development. Beck is also a cocreator of Oracle Portal, a commercial product that began as, in Beck's own words, a "science project," then became known as WebView.

Joel Kallman is a web systems technologist for Oracle Corporation. His work over the past 13 years has centered around database and content management, from SGML databases and publishing systems to text and document management. He is currently developing solutions and tools for customers to easily build database-centric web applications. Joel is a proud alumnus of The Ohio State University, where he received his bachelor's degree in computer engineering. He and his wife, Kristin, reside in Powell, Ohio.

A bio is not available for this author.

Connor McDonald has worked with Oracle since the early 1990s, cutting his teeth on Oracle versions 6.0.36 and 7.0.12. Over the past 11 years, Connor has worked with systems in Australia, the U.K., southeast Asia, western Europe, and the United States. He has come to realize that although the systems and methodologies around the world are very diverse, there tend to be two common themes in the development of systems running on Oracle: either to steer away from the Oracle-specific functions or to use them in a haphazard or less-than-optimal fashion. It was this observation that led to the creation of a personal hints and tips website (http://www.OracleDBA.co.uk) and more, presenting on the Oracle speaker circuit in an endeavor to improve the perception and usage of PL/SQL in the industry.

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

Bibliographic Details

Title: Mastering Oracle PL/SQL: Practical Solutions
Publisher: Apress
Publication Date: 2004
Binding: Paperback
Book Condition: Used: Good

Top Search Results from the AbeBooks Marketplace

1.

Connor McDonald, Chaim Katz, Christopher Beck, Joel R. Kallman, David C. Knox
Published by Apress (2004)
ISBN 10: 1590592174 ISBN 13: 9781590592175
Used First Edition Quantity Available: 1
Seller
Better World Books
(Mishawaka, IN, U.S.A.)
Rating
[?]

Book Description Apress, 2004. Book Condition: Good. 1st Edition. Shows some signs of wear, and may have some markings on the inside. Bookseller Inventory # GRP29600070

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 3.48
Convert Currency

Add to Basket

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

2.

Connor McDonald, Chaim Katz, Christopher Beck, Joel R. Kallman, David C. Knox
Published by Apress (2004)
ISBN 10: 1590592174 ISBN 13: 9781590592175
Used First Edition Quantity Available: 1
Seller
Better World Books
(Mishawaka, IN, U.S.A.)
Rating
[?]

Book Description Apress, 2004. Book Condition: Fair. 1st Edition. Shows definite wear, and perhaps considerable marking on inside. Bookseller Inventory # GRP96770529

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 3.48
Convert Currency

Add to Basket

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

3.

Chaim Samuel Katz; Connor McDonald; Christopher Beck; Joel R. Kallman; David C. Knox
Published by Apress L. P.
ISBN 10: 1590592174 ISBN 13: 9781590592175
Used Paperback Quantity Available: 1
Seller
Free State Books
(Halethorpe, MD, U.S.A.)
Rating
[?]

Book Description Apress L. P. Paperback. Book Condition: Fair. Ex-Library Book - will contain Library Markings. Bookseller Inventory # G1590592174I5N10

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 4.01
Convert Currency

Add to Basket

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

4.

Chaim Samuel Katz; Connor McDonald; Christopher Beck; Joel R. Kallman; David C. Knox
Published by Apress L. P.
ISBN 10: 1590592174 ISBN 13: 9781590592175
Used Paperback Quantity Available: 1
Seller
ThriftBooks
(Auburn, WA, U.S.A.)
Rating
[?]

Book Description Apress L. P. Paperback. Book Condition: Very Good. Book has appearance of light use with no easily noticeable wear. Bookseller Inventory # G1590592174I4N00

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 4.01
Convert Currency

Add to Basket

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

5.

Chaim Samuel Katz; Connor McDonald; Christopher Beck; Joel R. Kallman; David C. Knox
Published by Apress L. P.
ISBN 10: 1590592174 ISBN 13: 9781590592175
Used Paperback Quantity Available: 1
Seller
Books Squared
(Dallas, TX, U.S.A.)
Rating
[?]

Book Description Apress L. P. Paperback. Book Condition: Fair. Bookseller Inventory # G1590592174I5N00

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 4.01
Convert Currency

Add to Basket

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

6.

McDonald, Connor; Katz, Chaim; Beck, Christopher; Kallman, Joel R.; Knox, David C.
Published by Apress
ISBN 10: 1590592174 ISBN 13: 9781590592175
Used PAPERBACK Quantity Available: 1
Seller
Your Online Bookstore
(Houston, TX, U.S.A.)
Rating
[?]

Book Description Apress. PAPERBACK. Book Condition: Fair. 1590592174 Ships promptly. Bookseller Inventory # AUD1961.2LPCM050516H0258A

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 4.74
Convert Currency

Add to Basket

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

7.

Connor McDonald; Chaim Katz; Christopher Beck; Joel R. Kallman; David C. Knox
Published by Apress (2004)
ISBN 10: 1590592174 ISBN 13: 9781590592175
Used Paperback Quantity Available: 1
Seller
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Apress, 2004. Paperback. Book Condition: Used: Acceptable. Bookseller Inventory # SONG1590592174

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 4.94
Convert Currency

Add to Basket

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

8.

Connor McDonald; Chaim Katz; Christopher Beck; Joel R. Kallman; David C. Knox
Published by Apress (2004)
ISBN 10: 1590592174 ISBN 13: 9781590592175
Used Paperback Quantity Available: 1
Seller
MyLibraryMarket
(Waynesville, OH, U.S.A.)
Rating
[?]

Book Description Apress, 2004. Paperback. Book Condition: Used: Like New. ***please read*** no marks on text - bn6-a. Bookseller Inventory # 151110005

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 18.75
Convert Currency

Add to Basket

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

9.

Connor McDonald
ISBN 10: 1590592174 ISBN 13: 9781590592175
Used Quantity Available: 2
Seller
Best Book Discounts
(Temple Terrace, FL, U.S.A.)
Rating
[?]

Book Description Book Condition: Very Good. In good condition and ready for quick shipment to any US location by an experienced and reliable seller. CDs and Access codes may not be included as is the case with most used books. Thanks for shopping with us!. Bookseller Inventory # 3088995

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 19.95
Convert Currency

Add to Basket

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

10.

Connor McDonald
Published by Apress 2004-01 (2004)
ISBN 10: 1590592174 ISBN 13: 9781590592175
Used Paperback Quantity Available: 1
Seller
Lost Books
(AUSTIN, TX, U.S.A.)
Rating
[?]

Book Description Apress 2004-01, 2004. Paperback. Book Condition: good. 1. 1590592174. Bookseller Inventory # 658658

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 27.05
Convert Currency

Add to Basket

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

There are 26 more copies of this book

View all search results for this book