dcsimg
Login | Register   
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


advertisement
 

Book Excerpt: "Expert Oracle PL/SQL"

PL/SQL is essential to the process of stored Java class libraries. In this comprehensive book for Oracle developers of all levels, you'll learn how to use PL/SQL as a wrapper, making PL/SQL the gate through which data moves to and from Java stored objects.


advertisement

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


xperienced PL/SQL programmers and Oracle developers will learn to master Oracle's procedural extension to industry-standard SQL. "Expert Oracle PL/SQL" should help you become expert 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.

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
  • Chapter 5, 'Extending PL/SQL with Java Libraries' explains how to extend PL/SQL to make it be the gate through which data moves to and from Java stored objects. Extending stored programs with Java is a very popular solution, and PL/SQL is essential to the process of stored Java class libraries.



    Download the PDF of Chapter 5: 'Extending PL/SQL with Java Libraries'

    Reproduced from "Expert Oracle PL/SQL," by permission of McGraw Hill. ISBN 0072261943, copyright 2005. All rights reserved.



       
    Comment and Contribute

     

     

     

     

     


    (Maximum characters: 1200). You have 1200 characters left.

     

     

    Sitemap
    Thanks for your registration, follow us on our social networks to keep up-to-date