✦ LIBER ✦

Mastering Oracle SQL

✍ Scribed by Sanjay Mishra, Alan Beaulieu

Book ID: 127447015
Publisher: O'Reilly Media
Year: 2002
Tongue: English
Weight: 5 MB
Edition: 1
Category: Library
ISBN: 0596001290

No coin nor oath required. For personal study only.

✦ Synopsis

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 authors share their knowledge of Oracle SQL, and show you many creative techniques that you can use to advantage in your own applications.This book shows you how to: * Leverage Oracle's vast library of built-in SQL functions * Query time-based data, and write joins involving date and time ranges * Use Oracle SQL's hierarchical query features to deal with data best represented in a tree format * Use DECODE and CASE to implement conditional logic in your queries * Use Oracle's new, analytic SQL features to write ranking queries, lag and lead queries, windowing queries, and more * Join data from two or more tables using the newly supported SQL92 join syntaxIn addition, you'll see how SQL can best be integrated with PL/SQL. You'll also learn various best practices to help you write SQL queries that perform efficiently.Precious 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.

📜 SIMILAR VOLUMES

Mastering Oracle SQL

✍ Sanjay Mishra, Alan Beaulieu 📂 Library 📅 2004 🏛 O'Reilly Media 🌐 English ⚖ 712 KB

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 and SQL*Plus

✍ Lex de Haan 📂 Library 📅 2004 🏛 Apress 🌐 English ⚖ 3 MB

SQL is the ANSI-standard language for accessing and manipulating relational databases. Anyone (programmers, administrators, or designers) who work with a relational databases need to understand the SQL language. While most books on the market do not properly cover the basics, this book differs: it e

Oracle/SQL Tutorial

✍ Gertz M. 📂 Library 📅 2000 🌐 English ⚖ 506 KB

Oracle Database 10g SQL

✍ Jason Price, McGraw-Hill 📂 Library 📅 2004 🏛 McGraw-Hill Osborne Media 🌐 English ⚖ 849 KB

In this comprehensive book, you'll learn to write Structured Query Language (SQL) statements to access an Oracle database and use PL/SQL (Procedural Language/SQL) to write programs containing SQL statements. Developed in compliance with the new SQL2003 specification, this definitive resource explain

Oracle PL/SQL Programming

✍ Feuerstein S., Pribyl B. 📂 Library 📅 2005 🌐 English ⚖ 2 MB

For the past ten years, O'Reilly's "Oracle PL/SQL Programming" has been the bestselling book on PL/SQL, Oracle's powerful procedural language. Packed with examples and helpful recommendations, the book has helped everyone - from novices to experienced developers, and from Oracle Forms developers to

Oracle 9i. SQL Reference

✍ Lorentz D. 📂 Library 📅 2001 🌐 English ⚖ 10 MB

This reference contains a complete description of the Structured Query Language (SQL) used to manage information in an Oracle database. Oracle SQL is a superset of the American National Standards Institute (ANSI) and the International Standards Organization (ISO) SQL99 standard.