Advanced SQL Functions in Oracle 10g

Dr. Richard Earp, Dr. Sikha Bagui

  • 出版商: Wordware Publishing
  • 出版日期: 2006-02-22
  • 售價: $1,610
  • 貴賓價: 9.5$1,530
  • 語言: 英文
  • 頁數: 397
  • 裝訂: Paperback
  • ISBN: 1598220217
  • ISBN-13: 9781598220216
  • 相關分類: OracleSQL
  • 下單後立即進貨 (約1週~2週)




Designed 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.

Learn 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.