• Contact

  • Newsletter

  • About us

  • Delivery options

  • Prospero Book Market Podcast

  • Expert Oracle PL/SQL

    Expert Oracle PL/SQL by Hardman, Ron; McLaughlin, Michael;

    Series: Oracle Press;

      • GET 10% OFF

      • The discount is only available for 'Alert of Favourite Topics' newsletter recipients.
      • Publisher's listprice GBP 67.99
      • The price is estimated because at the time of ordering we do not know what conversion rates will apply to HUF / product currency when the book arrives. In case HUF is weaker, the price increases slightly, in case HUF is stronger, the price goes lower slightly.

        32 482 Ft (30 935 Ft + 5% VAT)
      • Discount 10% (cc. 3 248 Ft off)
      • Discounted price 29 234 Ft (27 842 Ft + 5% VAT)

    32 482 Ft

    Availability

    Permanently out of stock

    Why don't you give exact delivery time?

    Delivery time is estimated on our previous experiences. We give estimations only, because we order from outside Hungary, and the delivery time mainly depends on how quickly the publisher supplies the book. Faster or slower deliveries both happen, but we do our best to supply as quickly as possible.

    Product details:

    • Publisher McGraw Hill
    • Date of Publication 16 October 2005

    • ISBN 9780072261943
    • Binding Paperback
    • No. of pages496 pages
    • Size 231x188x27 mm
    • Weight 872 g
    • Language English
    • 0

    Categories

    Short description:

    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

    Long description:

    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


    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

    Table of Contents:

    Part I: PL/SQL Advanced Concepts, Internals, and Debugging

    Chapter 1: Introduction to Advanced Concepts, Patterns, and Techniques

    Chapter 2: PL/SQL Internals

    Chapter 3: Debugging PL/SQL Applications

    Part II: Invoker Rights, Java Libraries, and Object Patterns

    Chapter 4: Invoker's-Rights Architecture

    Chapter 5: Extending PL/SQL with Java Libraries

    Chapter 6: Implementing PL/SQL Objects

    Part III: Optimizing PL/SQL Solutions

    Chapter 7: Threading PL/SQL Execution

    Chapter 8: High Performance PL/SQL

    Part IV: Text Management Using PL/SQL

    Chapter 9: Introduction to Information Retrieval

    Chapter 10: Introduction to Regular Expressions

    Part V: PL/SQL Server Pages and Database Management

    Chapter 11: Leveraging the PL/SQL Toolkit

    Chapter 12: Managing the Database

    Appendix A: REGULAR EXPRESSION METACHARACTERS AND FUNCTIONS

    Appendix B: ORACLE TEXT SUPPLIED PACKAGES

    Appendix C: PL/SQL TOOLKIT PACKAGES

    Appendix D: BASIC PRIMER ON JAVA AND JAVA DATABASE CONNECTIVITY (JDBC)

    INDEX

    More

    0