{"product_id":"expert-oracle-plsql-9780072261943","title":"Expert Oracle Pl\/SQL","description":"\u003cp\u003e\u003cb\u003ePublisher'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.\u003c\/b\u003e\u003c\/p\u003e\u003cp\u003e\u003cb\u003e\u003cbr\u003e\u003c\/b\u003e\u003c\/p\u003e\u003cp\u003e\u003cb\u003eCreate and debug next-generation, feature-rich PL\/SQL applications\u003c\/b\u003e\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\n\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\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAuthor:\u003c\/b\u003e Michael McLaughlin, Ron Hardman\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e McGraw-Hill Companies\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 09\/01\/2005\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 496\u003cbr\u003e\u003cb\u003eBinding Type:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 1.87lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.52h x 7.36w x 1.04d\u003cbr\u003e\u003cb\u003eISBN:\u003c\/b\u003e 9780072261943\u003cbr\u003e\u003cp\u003e\u003cb\u003eAbout the Author\u003c\/b\u003e\u003cbr\u003e\u003cb\u003eRon Hardman, OCP, \u003c\/b\u003e is a Consulting Technical Specialist with Oracle Worldwide Technical Support. Prior to joining Oracle Corporation, he was an Oracle database developer and consultant. He is a frequent presenter on the topics of Oracle Text and Ultrasearch at Oracle User Group conferences, and teaches classes on SQL and PL\/SQL. He is the coauthor of Oracle Database 10g PL\/SQL Programming and has published articles with \u003ci\u003eOracle Magazine\u003c\/i\u003e and other online magazines on subjects related to information retrieval. \u003c\/p\u003e\u003cp\u003e \u003cb\u003eMichael McLaughlin, D. CS., \u003c\/b\u003e is the Senior Application Upgrade Manager for Oracle Applications Release Engineering. He is currently working on the upgrade architecture for the next release of Oracle Applications. He has worked with PL\/SQL since its first version in Oracle 6, and has authored customer support notes on customizing Oracle Applications with Pro*C and PL\/SQL. He has taught computer science and information technology at Regis University and Colorado Technical University, including courses in database development, SQL, PL\/SQL, and Java. He is the coauthor of \u003ci\u003eOracle Database 10g PL\/SQL Programming.\u003c\/i\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e\u003ci\u003eThis title is not returnable\u003c\/i\u003e\u003cbr\u003e\u003c\/p\u003e","brand":"McGraw-Hill Companies","offers":[{"title":"Paperback","offer_id":39927176069235,"sku":"9.78E+12","price":71.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0555\/9255\/0515\/products\/img_6fc9f721-d2c0-4da5-8433-6a375ca78986.jpg?v=1647523230","url":"https:\/\/bookstorenmore.com\/products\/expert-oracle-plsql-9780072261943","provider":"Bookstore N More","version":"1.0","type":"link"}