ISBN 9788183331845,Advanced SQL Functions in Oracle 10g

Advanced SQL Functions in Oracle 10g



BPB Publications

Publication Year 2006

ISBN 9788183331845

ISBN-10 818333184X


Number of Pages 397 Pages
Language (English)


Advanced SQL Functions in Oracle 10G is a computer programming book written by Dr. Richard Earp and Sikha Bagui.

It has been designed to help users make the most of Oracle 10G's SQL, especially database programmers. It explores some of the new SQL features. It shows readers the syntax for new functions and features, and the different categorisations and breakdowns of functions. The book is easy to understand, so it can be used by students and Oracle professionals. However, it should only be used by those familiar with the software.

This book looks comprehensively at Oracle 10G's Analytical Functions, Regular Expressions, and MODEL Statements. It also covers object-oriented structures and collection objects. It introduces new topics such as statistical functions and XML. It includes a re-examination of the previous Oracle tools which will help users make their transition to the new material.

The book instructs readers on how to lay out result sets with SQL* plus reporting tools, perform certain calculations with model statement, use an aggregate function for reporting, ordering, and partitioning, working with collection objects, searching within strings using regular expressions and handling XML with SQL. It also teaches users how to perform analytical functions. It gives users a programmer’s perspective.

Advanced SQL Functions in Oracle 10G was published by BPB Publications in 2006 and is available in paperback.

Key Features:


  • Each chapter has numerous examples to help readers comprehend and grasp the concept easier.

  • It is helpful for database students and is a good research tool as well.