{"product_id":"9780072255409","title":"Oracle Database 10g PL\/SQL 101","description":"\u003cb\u003eAuthor(s): Allen, Christopher\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e\n\n\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\u003cb\u003eGet The Ins-and-Outs of SQL and PL\/SQL From an Oracle Expert\u003c\/b\u003e\u003cbr\u003e\u003cp\u003ePerform database functions quickly and easily using the comprehensive information in this step-by-step guide. Oracle professional Christopher Allen begins with database basics and progresses to plain-language explanations and real-world examples of SQL statements and PL\/SQL programs. You’ll learn how to manage, query, and manipulate data, use SQL*Plus, create SQL functions, and write practical PL\/SQL applications. Review questions, chapter summaries, and hands-on projects will have you understanding and exploiting the powerful features of Oracle Database 10\u003ci\u003eg\u003c\/i\u003e in no time.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eCreate tables, rows, records, columns, and fields\u003c\/li\u003e\n\u003cli\u003eStore text, numbers, dates, pictures, and soundfiles in tables and columns\u003c\/li\u003e\n\u003cli\u003eDefine, manipulate, retrieve, and delete data, using SQL commands\u003c\/li\u003e\n\u003cli\u003eSelect, sort, and filter records with SQL functions and procedures\u003c\/li\u003e\n\u003cli\u003eWrite SQL commands to declare variables using anchored types\u003c\/li\u003e\n\u003cli\u003eUse SAVEPOINT and ROLLBACK commands to ensure multilevel undo\u003c\/li\u003e\n\u003cli\u003ePerform time-based and hierarchical data queries\u003c\/li\u003e\n\u003cli\u003eEdit and reuse commands in script files, using the SQL*Plus program\u003c\/li\u003e\n\u003cli\u003eUse PL\/SQL views, sequences, procedures, functions, and packages\u003c\/li\u003e\n\u003cli\u003eUse triggers to automate auditing, security, and maintenance tasks\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cbr\u003e\u003cbr\u003eReview(s):\u003cbr\u003e\u003cbr\u003e\u003cbr\u003eEAN: 9780072255409\u003cbr\u003e\u003cbr\u003eAge Group:  \u003cbr\u003e\u003cbr\u003eNumber of Pages: 416\u003cbr\u003e\u003cbr\u003eWeight: 744.4 gr\u003cbr\u003e\u003cbr\u003e","brand":"McGraw Hill","offers":[{"title":"Paperback \/ softback","offer_id":43845814812910,"sku":"9780072255409","price":68.06,"currency_code":"AUD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0630\/9612\/7726\/products\/9780072255409_647fb7e9-9d63-4fad-a4e7-b6fd822e9371.jpg?v=1671238064","url":"https:\/\/bookland.com.au\/products\/9780072255409","provider":"Book Land AU","version":"1.0","type":"link"}