ADO.NET revolutionized the way data was accessed through SQL Server, Oracle, and MySQL. With Microsoft’s release of ADO.NET 2, ADO and the .NET Framework are integrated with SQL Server for the first time-enabling you to program .NET applications directly within the SQL Server database. Packed with sample code and recommended best practices for using ADO.NET 2, this code-intensive book explores the new data types that are available in the 2.0 Framework and discusses the appropriate time and way to use them. You’ll learn how to make repetitive, mundane tasks much simpler and you’ll walk away with a solid foundation for developing database-driven applications. What you will learn from this book The basics of creating a connection, executing a query, and returning a result Best uses for Oracle in the ADO.NET Framework The many new features that are available for XML How to use the full text search capabilities of Microsoft(r) SQL Server 2005 Methods for retrieving data and presenting it in various ways Why MySQL is a viable option for data storage Who this book is for This book is for experienced database developers who want to learn the latest release of ADO.NET 2.0. Knowledge of ADO.NET 1.0, general .NET development, and Microsoft SQL Server is necessary. Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

Oracle 10g has introduced new features into it srepertoire of SQL instructions that make database queries more versatile. When programmers use SQL in Oracle, they inevitably look for easier and new ways to handle queries. What is needed is a way to introduce SQL users to the new features of Oracle 10g concisely and systematically so that database programmers can take full advantag eof the newer capabilities. This book hopes to meet this need by exploring some common new SQL features.

Each chapter includes numerous working examples, and Oracle users can run these examples as they read and workt hrough the book. Also, many books on Oracle 10g present the language syntax alone with no in-depth explanation, analysis, or examples. In this book, we present not only the syntax for new features and functions, but also a thorough clarification and breakdown of the different functions, along with examples of ways they can and should be used.

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.

You will 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.

This book is meant to be used by Oracle professionals as well as students, but it is not a SQL primer. Readers of this book are expected to have previously used Oracle , SQL*Plus, and, to some extent, PL/SQL. This book can be used for individual study or reference, in advanced Oracle training settings, and in advanced database classes in schools. It is meant for those familiar with SQL programming since most of the topics present not only the syntax, queries, and answers, but also have ananalytical programming perspective to them. This book will allow the Oracle user to use SQL in new and exciting ways.

TABLE OF CONTENT:
Chapter 1 Common Oracle Functions: A Function Review
Chapter 2 Reporting Tools in Oracle’s SQL Plus
Chapter 3 The Analytical Functions in Oracle
Chapter 4 Aggregate Functions Used as Analytical Functions
Chapter 5 The Use of Analytical Functions in Reporting
Chapter 6 The MODEL or SPREADSHEET Predicate in Oracle’s SQL
Chapter 7 Regular Expressions: String Searching and Oracle 10g
Chapter 8 Collection and OO SQL in Oracle
Chapter 9 SQL and XML
Appendix A String Functions
Appendix B Statistical Functions

Code:
download:

http://rapidshare.de/files/29221192/adv_sql_fun_in_ora_10_g.rar

password:
warez

PassGuide Training Materials & Practice Tests

• Microsoft MOC
• McGraw-Hill books
• Sql Server 2005 Moc 2779b & Its Exams
• Career Academy SQL Server 2005
• TrainingSpot SQL Server 2005 Reporting Services 101
• Total Training SQL Development
• CBT Nuggets Exam-Pack 70-443: Designing a Database Server Infrastructure Using Microsoft SQL Server 2005
• Professional ADO dot NET 2 Programming with SQL Server 2005 Oracle and Mysql
• Sams SQL Server 2005 Management and Administration Oct 2007 eBook-BBL
• Oracle PL/SQL Language Pocket Reference