{"product_id":"expert-oracle-pl-sql-9780072261943","title":"Expert Oracle PL\/SQL","description":"\u003cp\u003e • Author(s): Ron Hardman\u003cbr\u003e • Publisher: McGraw-Hill Education\u003cbr\u003e • Publisher Imprint: McGraw-Hill Education\u003cbr\u003e • BISAC: Languages - SQL\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003cb\u003eFrom the Back Cover\u003c\/b\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eCreate and debug next-generation, feature-rich PL\/SQL applications\u003c\/p\u003e \u003cp\u003ePush 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.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eCompile high performance PL\/SQL scripts using procedures, functions, packages and triggers \u003c\/li\u003e\n\u003cli\u003eTrap, trace, identify, and eliminate compile-time and runtime errors \u003c\/li\u003e\n\u003cli\u003eManage error propagation, stacks, regular expressions, and metacharacters \u003c\/li\u003e\n\u003cli\u003eExploit definer's-rights and invoker's-rights architectures \u003c\/li\u003e\n\u003cli\u003eExtend PL\/SQL functionality using server-side and internal Java class libraries \u003c\/li\u003e\n\u003cli\u003eBuild and run parallel PL\/SQL program units using DBMS_JOB and DBMS_PIPE \u003c\/li\u003e\n\u003cli\u003eExploit definer's-rights and invoker's-rights architectures \u003c\/li\u003e\n\u003cli\u003eTune performance using statistics gathering, the PL\/SQL optimizer, SQL Trace, DBMS_STATS, and TKPROF \u003c\/li\u003e\n\u003cli\u003eUse Oracle Text with PL\/SQL Server Pages to perform theme\/gist extraction, highlighting, stemming, fuzzy, and wildcard searching \u003c\/li\u003e\n\u003cli\u003eAdminister server-side PL\/SQL Toolkit web pages and PL\/SQL Server Pages \u003c\/li\u003e\n\u003cli\u003eSecure, encrypt, and transmit data using DBMS_CRYPTO, UTL_COMPRESS, DBMS_DATAPUMP, and DBMS_FILE_TRANSFER \u003c\/li\u003e\n\u003c\/ul\u003e","brand":"McGraw-Hill Education","offers":[{"title":"Paperback","offer_id":45114301841559,"sku":"9780072261943","price":5349.0,"currency_code":"INR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0666\/3471\/1191\/files\/9780072261943.webp?v=1767269523","url":"https:\/\/atlanticbooks.com\/products\/expert-oracle-pl-sql-9780072261943","provider":"Atlantic Books","version":"1.0","type":"link"}