{"product_id":"advanced-sql-functions-in-oracle-10g-9781598220216","title":"Advanced SQL Functions in Oracle 10g: .","description":"\u003cp\u003e • Author(s): Richard Earp | Sikha Bagui\u003cbr\u003e • Publisher: Jones \u0026amp; Bartlett Publishers\u003cbr\u003e • Publisher Imprint: Jones \u0026amp; Bartlett Publishers\u003cbr\u003e • BISAC: Programming Languages - General\u003c\/p\u003e\u003cp\u003eDesigned to exploit Oracle 10g's SQL, this book takes a comprehensive look at Oracle 10g's analytical functions, MODEL statements, and regular expressions. In addition, the book covers collection objects and object-oriented structures and introduces new Oracle 10g topics such as XML and statistical functions. The authors' logical and developmental approach to query building includes a review of older Oracle tools to help in the transition to newer material.This text will teach the reader how to format result sets with SQL*Plus reporting tools; use aggregate functions for partitioning, ordering, and reporting; perform calculations with the MODEL statement; search within strings using regular expressions; work with collection objects; handle XML within SQL.\u003c\/p\u003e","brand":"Jones \u0026 Bartlett Publishers","offers":[{"title":"Paperback","offer_id":46891953160343,"sku":"9781598220216","price":4363.0,"currency_code":"INR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0666\/3471\/1191\/files\/9781598220216.webp?v=1770277716","url":"https:\/\/atlanticbooks.com\/products\/advanced-sql-functions-in-oracle-10g-9781598220216","provider":"Atlantic Books","version":"1.0","type":"link"}