Book Excerpt: “Expert Oracle PL/SQL”

Book Excerpt: “Expert Oracle PL/SQL”

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/SQLis 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.

    Share the Post:
    Heading photo, Metadata.

    What is Metadata?

    June 1, 2023

    What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular

    XDR solutions

    The Benefits of Using XDR Solutions

    May 24, 2023

    Cybercriminals constantly adapt their strategies, developing newer, more powerful, and intelligent ways to attack your network. Since security professionals must innovate as well, more conventional endpoint detection solutions have evolved

    AI is revolutionizing fraud detection

    How AI is Revolutionizing Fraud Detection

    May 23, 2023

    Artificial intelligence – commonly known as AI – means a form of technology with multiple uses. As a result, it has become extremely valuable to a number of businesses across

    AI innovation

    Companies Leading AI Innovation in 2023

    May 22, 2023

    Artificial intelligence (AI) has been transforming industries and revolutionizing business operations. AI’s potential to enhance efficiency and productivity has become crucial to many businesses. As we move into 2023, several

    data fivetran pricing

    Fivetran Pricing Explained

    May 17, 2023

    One of the biggest trends of the 21st century is the massive surge in analytics. Analytics is the process of utilizing data to drive future decision-making. With so much of

    kubernetes logging

    Kubernetes Logging: What You Need to Know

    May 16, 2023

    Kubernetes from Google is one of the most popular open-source and free container management solutions made to make managing and deploying applications easier. It has a solid architecture that makes

    Show More