E-Books: Advanced SQL Functions in Oracle 10g
With the advent of new features added to SQL in Oracle 10g, we thought that some collection of material related to the newer query mechanisms was in order.
Hence, in this book we have gathered some useful new tools into a set of topics for exploiting Oracle 10g’s SQL. We have also briefly reviewed some older tools that will help transition to the new material.
This book mainly addresses advanced topics in SQL with a focus on SQL functions for Oracle 10g. The functions and methods we cover include the analytical functions, MODEL statements, regular expressions, and object-oriented/collection structures. We also introduce and give examples of the SQL/XML bridges as XML is a newer and common method of transferring data from user to user. We rely heavily on examples, as most SQL programmers can and do adapt examples to other problems quickly.
For Download:
Click Here