{"product_id":"9780071812443","title":"Oracle Database 12c PL\/SQL Programming","description":"Master Oracle Database 12\u003ci\u003ec\u003c\/i\u003e PL\/SQL Application Development  \u003cp\u003eDevelop, debug, and administer robust database programs. Filled with detailed examples and expert strategies from an Oracle ACE, \u003ci\u003eOracle Database 12c PL\/SQL Programming\u003c\/i\u003e explains how to retrieve and process data, write PL\/SQL statements, execute effective queries, incorporate PHP and Java, and work with dynamic SQL. Code testing, security, and object-oriented programming techniques are fully covered in this comprehensive Oracle Press guide.\u003c\/p\u003e  \u003cul\u003e \u003cli\u003eExplore new SQL and PL\/SQL features in Oracle Database 12\u003ci\u003ec\u003c\/i\u003e\n\u003c\/li\u003e  \u003cli\u003eBuild control structures, cursors, and loop statements\u003c\/li\u003e  \u003cli\u003eWork with collections, varrays, tables, and associative array collections\u003c\/li\u003e  \u003cli\u003eLocate and repair errors and employ exception handlers\u003c\/li\u003e  \u003cli\u003eExecute black box, white box, and integration tests\u003c\/li\u003e  \u003cli\u003eConfigure and manage stored packages and libraries\u003c\/li\u003e  \u003cli\u003eHandle security with authentication and encryption\u003c\/li\u003e  \u003cli\u003eUse LOBs to store text and multimedia content\u003c\/li\u003e  \u003cli\u003eWrite and implement PL\/SQL and Java triggers\u003c\/li\u003e  \u003cli\u003eExtend functionality using dynamic SQL statements\u003c\/li\u003e  \u003cli\u003eUnderstand object types, nested tables, and unnesting queries\u003c\/li\u003e  \u003c\/ul\u003e","brand":"McGraw-Hill Education","offers":[{"title":"Default Title","offer_id":47124219265264,"sku":"9780071812443","price":72.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9780071812443_p0.jpg?v=1763636268","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9780071812443","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}