{"product_id":"9781449397722","title":"Oracle Built-in Packages: Oracle Development Languages","description":"\u003cp\u003eOracle is the most popular database management system in use today, and  PL\/SQL plays a pivotal role in current and projected Oracle products and  applications. PL\/SQL is a programming language providing procedural  extensions to the SQL relational database language and to an ever-growing  number of oracle development tools. originally a rather limited tool,  PL\/SQL became with Oracle7 a mature and effective language for developers. now, with the introduction of Oracle8, PL\/SQL has taken the next step  towards becoming a fully realized programming language providing  sophisticated object-oriented capabilities. Steven Feuerstein's\u003ci\u003eOracle PL\/SQL Programming\u003c\/i\u003e is a comprehensive guide to building  applications with PL\/SQL. That book has become the bible for PL\/SQL  developers who have raved about its completeness, readability, and  practicality.Built-in packages are collections of PL\/SQL objects built by Oracle Corporation and stored directly in the Oracle database. The functionality of these packages is available from any programming environment that can call PL\/SQL stored procedures, including Visual Basic, Oracle Developer\/2000, Oracle Application Server (for web-based development), and, of course, the Oracle database itself. Built-in packages extend the capabilities and power of PL\/SQL in many significant ways. for example:\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eDBMS_SQL executes dynamically constructed SQL statements and PL\/SQL blocks of code.\u003c\/li\u003e\n\u003cli\u003eDBMS_PIPE communicates between different Oracle sessions through a pipe in the RDBMS shared memory.\u003c\/li\u003e\n\u003cli\u003eDBMS_JOB submits and manages regularly scheduled jobs for execution inside the database. \u003c\/li\u003e\n\u003cli\u003eDBMS_LOB accesses and manipulates Oracle8's large objects (LOBs) from within PL\/SQL programs.\u003c\/li\u003e\n\u003c\/ul\u003eThe first edition of \u003ci\u003eOracle PL\/SQL Programming\u003c\/i\u003e contained a chapter on  Oracle's built-in packages. but there is much more to say about the basic  PL\/SQL packages than Feuerstein could fit in his first book. In addition,  now that Oracle8 has been released, there are many new Oracle8 built-in  packages not described in the PL\/SQL book. There are also packages extensions  for specific oracle environments such as distributed database. hence this book.\u003ci\u003eOracle Built-in Packages\u003c\/i\u003e pulls together information about how to use the  calling interface (API) to Oracle's Built-in Packages, and provides extensive examples on using the built-in packages effectively.The windows diskette included with the book contains the companion guide, an online tool developed by RevealNet, Inc., that provides  point-and-click access to the many files of source code and online  documentation developed by the authors.The table of contents follows:PrefacePart I: Overview\u003cul\u003e\u003cli\u003e1. Introduction\u003c\/li\u003e\u003c\/ul\u003ePart II: Application Development Packages\u003cul\u003e\n\u003cli\u003e Executing Dynamic SQL and PL\/SQL \u003c\/li\u003e\n\u003cli\u003e Intersession Communication  \u003c\/li\u003e\n\u003cli\u003e User Lock and Transaction Management  \u003c\/li\u003e\n\u003cli\u003e Oracle Advanced Queuing  \u003c\/li\u003e\n\u003cli\u003e Generating Output from PL\/SQL Programs  \u003c\/li\u003e\n\u003cli\u003e Defining an Application Profile \u003c\/li\u003e\n\u003cli\u003e Managing Large Objects \u003c\/li\u003e\n\u003cli\u003e Datatype Packages \u003c\/li\u003e\n\u003cli\u003e Miscellaneous Packages\u003c\/li\u003e\n\u003c\/ul\u003ePart III: Server Management Packages\u003cul\u003e\n\u003cli\u003eManaging Session Information \u003c\/li\u003e\n\u003cli\u003eManaging Server Resources \u003c\/li\u003e\n\u003cli\u003eJob Scheduling in the Database\u003c\/li\u003e\n\u003c\/ul\u003ePart IV: Distributed Database Packages\u003cul\u003e\n\u003cli\u003eSnapshots \u003c\/li\u003e\n\u003cli\u003eAdvanced Replication \u003c\/li\u003e\n\u003cli\u003eConflict Resolution \u003c\/li\u003e\n\u003cli\u003eDeferred Transactions and Remote Procedure Calls\u003c\/li\u003e\n\u003c\/ul\u003eAppendix. What's on the companion disk?","brand":"O'Reilly Media, Incorporated","offers":[{"title":"Default Title","offer_id":47154726273264,"sku":"9781449397722","price":39.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781449397722_p0.jpg?v=1763835218","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781449397722","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}