{"product_id":"oracle-database-10g-pl-sql-101-9780072255409","title":"Oracle Database 10g PL\/SQL 101","description":"\u003cp\u003e • Author(s): Christopher Allen\u003cbr\u003e • Publisher: McGraw-Hill Education\u003cbr\u003e • Publisher Imprint: McGraw-Hill Education\u003cbr\u003e • BISAC: Database Administration \u0026amp; Management\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003cb\u003eFrom the Back Cover\u003c\/b\u003e\u003cbr\u003e\u003c\/p\u003e\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\u003e\u003cbr\u003e\u003c\/b\u003e\u003cp\u003e\u003cb\u003eGet The Ins-and-Outs of SQL and PL\/SQL From an Oracle Expert\u003c\/b\u003e\u003c\/p\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","brand":"McGraw-Hill Education","offers":[{"title":"Paperback","offer_id":45116036579479,"sku":"9780072255409","price":3226.0,"currency_code":"INR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0666\/3471\/1191\/files\/9780072255409.webp?v=1767271298","url":"https:\/\/atlanticbooks.com\/products\/oracle-database-10g-pl-sql-101-9780072255409","provider":"Atlantic Books","version":"1.0","type":"link"}