Expert Oracle PL/SQL (Oracle Press)

3.5 avg rating
( 10 ratings by GoodReads )
 
9780072261943: Expert Oracle PL/SQL (Oracle Press)

Experienced PL/SQL programmers and Oracle developers will learn to master Oracle's procedural extension to industry-standard SQL. Using this authoritative resource, readers will become experts at developing robust, high-performance enterprise applications with PL/SQL. Detailed examples describe the practical aspect of each feature, and provide ideas to the reader of how they can best exploit the functionality.

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

From the Back Cover:

Create and debug next-generation, feature-rich PL/SQL applications

Push your PL/SQL programming skills to the next level with the extensive information contained in this volume. You’ll learn how to write dynamic PL/SQL programs, interface with Oracle databases, execute complex calculations, and handle error conditions using advanced techniques. Plus, you’ll get the latest on the PL/SQL Toolkit, Java integration, code threading, and performance optimizing. Oracle professionals Ron Hardman and Michael McLaughlin cover all the bases, providing real-world examples, undocumented tricks, syntax samples, and unique solutions for every topic.

  • Compile high performance PL/SQL scripts using procedures, functions, packages and triggers
  • Trap, trace, identify, and eliminate compile-time and runtime errors
  • Manage error propagation, stacks, regular expressions, and metacharacters
  • Exploit definer’s-rights and invoker’s-rights architectures
  • Extend PL/SQL functionality using server-side and internal Java class libraries
  • Build and run parallel PL/SQL program units using DBMS_JOB and DBMS_PIPE
  • Exploit definer’s-rights and invoker’s-rights architectures
  • Tune performance using statistics gathering, the PL/SQL optimizer, SQL Trace, DBMS_STATS, and TKPROF
  • Use Oracle Text with PL/SQL Server Pages to perform theme/gist extraction, highlighting, stemming, fuzzy, and wildcard searching
  • Administer server-side PL/SQL Toolkit web pages and PL/SQL Server Pages
  • Secure, encrypt, and transmit data using DBMS_CRYPTO, UTL_COMPRESS, DBMS_DATAPUMP, and DBMS_FILE_TRANSFER

About the Author:

Ron Hardman, OCP, is a Consulting Technical Specialist with Oracle Worldwide Technical Support. Prior to joining Oracle Corporation, he was an Oracle database developer and consultant. He is a frequent presenter on the topics of Oracle Text and Ultrasearch at Oracle User Group conferences, and teaches classes on SQL and PL/SQL. He is the coauthor of Oracle Database 10g PL/SQL Programming and has published articles with Oracle Magazine and other online magazines on subjects related to information retrieval.

Michael McLaughlin, D. CS., is the Senior Application Upgrade Manager for Oracle Applications Release Engineering. He is currently working on the upgrade architecture for the next release of Oracle Applications. He has worked with PL/SQL since its first version in Oracle 6, and has authored customer support notes on customizing Oracle Applications with Pro*C and PL/SQL. He has taught computer science and information technology at Regis University and Colorado Technical University, including courses in database development, SQL, PL/SQL, and Java. He is the coauthor of Oracle Database 10g PL/SQL Programming.

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

Top Search Results from the AbeBooks Marketplace

1.

Hardman, Ron; McLaughlin, Michael
Published by McGraw-Hill Education
ISBN 10: 0072261943 ISBN 13: 9780072261943
New PAPERBACK Quantity Available: 5
Seller
zeebooks
(Foley, AL, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education. PAPERBACK. Book Condition: New. 0072261943 Brand new. Has remainder mark & slight shelf wear. Bookseller Inventory # 33470

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 29.95
Convert Currency

Add to Basket

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

2.

Hardman, Ron; McLaughlin, Michael
ISBN 10: 0072261943 ISBN 13: 9780072261943
New Quantity Available: 1
Seller
BooksForStudent
(West Bloomfield, MI, U.S.A.)
Rating
[?]

Book Description Book Condition: New. Brand New Book In Mint Condition. Shipping With Trackable Method. No APO/FPO Addresses Please. Bookseller Inventory # 9780072261943NHS

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 46.35
Convert Currency

Add to Basket

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

3.

Hardman, Ron; McLaughlin, Michael
ISBN 10: 0072261943 ISBN 13: 9780072261943
New Quantity Available: 1
Seller
Bookshub
(Karol Bagh, India)
Rating
[?]

Book Description Book Condition: New. New. US edition. Perfect condition. Ship by express service to USA, Canada, Australia, France, Italy, UK, Germany and Netherland. Customer satisfaction our priority. Bookseller Inventory # ABE-190516-154304

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 46.49
Convert Currency

Add to Basket

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

4.

Hardman, Ron; McLaughlin, Michael
ISBN 10: 0072261943 ISBN 13: 9780072261943
New Quantity Available: 1
Seller
EBOOKSTORE2010
(New Delhi, ND, India)
Rating
[?]

Book Description Book Condition: Brand New. New. US edition. Customer Satisfaction guaranteed!!. Bookseller Inventory # SHAK154304

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 46.54
Convert Currency

Add to Basket

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

5.

Hardman, Ron; McLaughlin, Michael
Published by McGraw-Hill Education (2005)
ISBN 10: 0072261943 ISBN 13: 9780072261943
New Quantity Available: > 20
Print on Demand
Seller
PBShop
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education, 2005. PAP. Book Condition: New. New Book. Shipped from US within 10 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Bookseller Inventory # IQ-9780072261943

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 42.96
Convert Currency

Add to Basket

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

6.

Hardman, Ron; McLaughlin, Michael
ISBN 10: 0072261943 ISBN 13: 9780072261943
New Paperback Quantity Available: > 20
Print on Demand
Seller
BargainBookStores
(Grand Rapids, MI, U.S.A.)
Rating
[?]

Book Description Paperback. Book Condition: New. This item is printed on demand. Item doesn't include CD/DVD. Bookseller Inventory # 5069935

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 43.80
Convert Currency

Add to Basket

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

7.

Hardman, Ron; McLaughlin, Michael
Published by McGraw-Hill Osborne Media (2005)
ISBN 10: 0072261943 ISBN 13: 9780072261943
New Paperback Quantity Available: 1
Seller
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Osborne Media, 2005. Paperback. Book Condition: New. 1. Bookseller Inventory # DADAX0072261943

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 43.94
Convert Currency

Add to Basket

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

8.

Hardman, Ron; McLaughlin, Michael
ISBN 10: 0072261943 ISBN 13: 9780072261943
New Quantity Available: 1
Seller
Basi6 International
(Irving, TX, U.S.A.)
Rating
[?]

Book Description Book Condition: Brand New. Ships from multiple locations. FedEx or DHL 4-6 business days delivery to your doorstep. Bookseller Inventory # 20JULY16APP-461

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 49.19
Convert Currency

Add to Basket

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

9.

Hardman, Ron; McLaughlin, Michael
Published by McGraw-Hill Osborne Media (2005)
ISBN 10: 0072261943 ISBN 13: 9780072261943
New Paperback Quantity Available: 1
Seller
Irish Booksellers
(Rumford, ME, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Osborne Media, 2005. Paperback. Book Condition: New. book. Bookseller Inventory # 0072261943

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 49.21
Convert Currency

Add to Basket

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

10.

Hardman, Ron; McLaughlin, Michael
Published by McGraw-Hill/Osborne Media
ISBN 10: 0072261943 ISBN 13: 9780072261943
New Paperback Quantity Available: 20
Seller
BuySomeBooks
(Las Vegas, NV, U.S.A.)
Rating
[?]

Book Description McGraw-Hill/Osborne Media. Paperback. Book Condition: New. Paperback. 496 pages. Dimensions: 9.0in. x 7.4in. x 1.2in.Experienced PLSQL programmers and Oracle developers will learn to master Oracles procedural extension to industry-standard SQL. Using this authoritative resource, readers will become experts at developing robust, high-performance enterprise applications with PLSQL. Detailed examples describe the practical aspect of each feature, and provide ideas to the reader of how they can best exploit the functionality. This item ships from multiple locations. Your book may arrive from Roseburg,OR, La Vergne,TN. Paperback. Bookseller Inventory # 9780072261943

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 48.47
Convert Currency

Add to Basket

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

There are more copies of this book

View all search results for this book