๐”– Scriptorium
โœฆ   LIBER   โœฆ
๐Ÿ“

Mastering Oracle SQL

โœ Scribed by Sanjay Mishra, Alan Beaulieu

Publisher
Oreily
Year
2002
Tongue
English
Leaves
321
Edition
1
Category
Library
โฌ‡  Acquire This Volume

No coin nor oath required. For personal study only.

โœฆ Synopsis

Few books on the market today go beyond discussing syntax and the barest rudiments of using Oracle SQL. This book changes that, showing you how to creatively leverage the full power of SQL to write queries in an Oracle environment. This book shows you how to:

    Leverage Oracle's vast library of built-in SQL functionsQuery time-based data, and write joins involving date and time rangesUse Oracle SQL's hierarchical query features to deal with data best represented in a tree formatUse DECODE and CASE to implement conditional logic in your queriesUse Oracle's new, analytic SQL features to write ranking queries, lag and lead queries, windowing queries, and moreJoin data from two or more tables using the newly supported SQL92 join syntax
In addition, the authors cover the full range of Oracle SQL features that apply to query writing. You'll learn many creative techniques for writing effective, good performing, and accurate queries.

๐Ÿ“œ SIMILAR VOLUMES

Mastering Oracle SQL
๐Ÿ“ Mastering Oracle SQL
โœ Mishra, Sanjay, Beaulieu, Alan;Alan Beaulieu ๐Ÿ“‚ Library ๐Ÿ“… 2009 ๐Ÿ› O'Reilly Media ๐ŸŒ English

<p>Updated to cover Oracle 10g, this edition of the highly regarded <i>Mastering Oracle SQL</i> has a stronger focus on practical, expert best-practices and on Oracle-specific SQL technique than any other book on the market. For those who want to harness the untapped (and often overlooked) power of

Mastering Oracle SQL
๐Ÿ“ Mastering Oracle SQL
โœ Mishra, Sanjay;Beaulieu, Alan ๐Ÿ“‚ Library ๐Ÿ“… 2004 ๐Ÿ› O'Reilly Media ๐ŸŒ English

The vast majority of Oracle SQL books discuss some syntax, provide the barest rudiments of using Oracle SQL, and perhaps include a few simple examples. It might be enough to pass a survey course, or give you some buzz words to drop in conversation with real Oracle DBAs. But if you use Oracle SQL on

Mastering Oracle SQL
๐Ÿ“ Mastering Oracle SQL
โœ Sanjay Mishra, Alan Beaulieu ๐Ÿ“‚ Library ๐Ÿ“… 2002 ๐Ÿ› O'Reilly Media ๐ŸŒ English
Mastering Oracle SQL
๐Ÿ“ Mastering Oracle SQL
โœ Sanjay Mishra, Alan Beaulieu ๐Ÿ“‚ Library ๐Ÿ“… 2004 ๐Ÿ› O'Reilly Media ๐ŸŒ English

The vast majority of Oracle SQL books discuss some syntax, provide the barest rudiments of using Oracle SQL, and perhaps include a few simple examples. It might be enough to pass a survey course, or give you some buzz words to drop in conversation with real Oracle DBAs. But if you use Oracle SQL on

Mastering Oracle SQL
๐Ÿ“ Mastering Oracle SQL
โœ Sanjay Mishra, Alan Beaulieu ๐Ÿ“‚ Library ๐Ÿ“… 2002 ๐Ÿ› O'Reilly Media ๐ŸŒ English

If you write programs to run against an Oracle database, you spend a lot of time and mental energy writing queries to return the data your programs need. Knowledge of SQL, and particularly of Oracle's implementation of SQL, is the key to writing good queries in a timely manner. In this book, the aut

Mastering Oracle SQL
๐Ÿ“ Mastering Oracle SQL
โœ Sanjay Mishra, Alan Beaulieu ๐Ÿ“‚ Library ๐Ÿ“… 2004 ๐Ÿ› O'Reilly ๐ŸŒ English

The vast majority of Oracle SQL books discuss some syntax, provide the barest rudiments of using Oracle SQL, and perhaps include a few simple examples. It might be enough to pass a survey course, or give you some buzz words to drop in conversation with real Oracle DBAs. But if you use Oracle SQ