Ron Hardman – författare
645 kr
Skickas inom 3-6 vardagar
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.
The essential desktop reference for PL/SQL revised and expanded for Oracle Database 10gCreate dynamic client/server applications using PL/SQL and the comprehensive information contained in this authoritative volume. Expert Oracle insiders cover the features of PL/SQL, explain scripting semantics and syntax, and fully detail the PL/SQL functionality of Oracle Database 10g. You’ll learn how to write powerful PL/SQL programs, interact with Oracle databases, perform complex calculations, and handle error conditions.
730 kr
Skickas inom 3-6 vardagar
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 triggersTrap, trace, identify, and eliminate compile-time and runtime errorsManage error propagation, stacks, regular expressions, and metacharactersExploit definer’s-rights and invoker’s-rights architecturesExtend PL/SQL functionality using server-side and internal Java class librariesBuild and run parallel PL/SQL program units using DBMS_JOB and DBMS_PIPEExploit definer’s-rights and invoker’s-rights architecturesTune performance using statistics gathering, the PL/SQL optimizer, SQL Trace, DBMS_STATS, and TKPROFUse Oracle Text with PL/SQL Server Pages to perform theme/gist extraction, highlighting, stemming, fuzzy, and wildcard searchingAdminister server-side PL/SQL Toolkit web pages and PL/SQL Server PagesSecure, encrypt, and transmit data using DBMS_CRYPTO, UTL_COMPRESS, DBMS_DATAPUMP, and DBMS_FILE_TRANSFER