Get Free Shipping on orders over $89
Expert Oracle PL/SQL : Oracle Press - Ron Hardman

Expert Oracle PL/SQL

By: Ron Hardman, Michael McLaughlin

Paperback | 1 September 2005 | Edition Number 1

At a Glance

Paperback


RRP $118.95

$118.75

or 4 interest-free payments of $29.69 with

 or 

Ships in 5 to 10 business days

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.


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

More in Databases

Statistics and Data Handling for Biologists : A Student's Guide - Neil Millar
Python All-in-One For Dummies : 3rd Edition - John C. Shovic

RRP $74.95

$49.99

33%
OFF
Coding All-in-One For Dummies : 2nd Edition - Chris Minnick

RRP $69.95

$46.99

33%
OFF
Social Research Methods : 4th Edition - Maggie Walter

RRP $101.95

$87.75

14%
OFF
SQL All-in-One For Dummies : For Dummies (Computer/Tech) - Allen G. Taylor
Microsoft 365 Access For Dummies : Access for Dummies - Laurie A. Ulrich
Data-driven BIM for Energy Efficient Building Design : 1st Edition - Saeed Banihashemi
Building a Scalable Data Warehouse with Data Vault 2.0 - Dan Linstedt
Data Analytics for Accounting ISE : 3rd Edition - Vernon J. Richardson

RRP $169.95

$146.75

14%
OFF