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 a regular basis, you
want much more. You want to access the full power of SQL to write
queries in an Oracle environment. You want a solid understanding of
what's possible with Oracle SQL, creative techniques for writing
effective and accurate queries, and the practical, hands-on
information that leads to true mastery of the language. Simply put,
you want useful, expert best practices that can be put to work
immediately, not just non-vendor specific overview or theory.
Updated to cover the latest version of Oracle, Oracle 10g, this
edition of the highly regarded "Mastering Oracle SQL" has a
stronger focus on technique and on Oracle's implementation of SQL
than any other book on the market. It covers Oracle s vast library
of built-in functions, the full range of Oracle SQL query-writing
features, regular expression support, new aggregate and analytic
functions, subqueries in the SELECT and WITH clauses, multiset
union operators, enhanced support for hierarchical queries: leaf
and loop detection, and the CONNECT_BY_ROOT operator, new
partitioning methods (some introduced in Oracle9i Release 2), and
the native XML datatype, XMLType.
"Mastering Oracle SQL," 2nd Edition fills the gap between the
sometimes spotty vendor documentation, and other books on SQL that
just don't explore the full depth of what is possible with
Oracle-specific SQL. For those who want to harness the untapped
(and often overlooked) power of Oracle SQL, this essential guide
for putting Oracle SQL to work will prove invaluable.
General
Imprint: |
O'Reilly Media
|
Country of origin: |
United States |
Series: |
O'REILLY |
Release date: |
July 2004 |
First published: |
July 2004 |
Authors: |
Sanjay Mishra
|
Dimensions: |
232 x 180 x 27mm (L x W x T) |
Format: |
Paperback
|
Pages: |
472 |
Edition: |
2nd Revised edition |
ISBN-13: |
978-0-596-00632-7 |
Categories: |
Books >
Computing & IT >
Computer software packages >
Database software >
Oracle
|
LSN: |
0-596-00632-2 |
Barcode: |
9780596006327 |
Is the information for this product incomplete, wrong or inappropriate?
Let us know about it.
Does this product have an incorrect or missing image?
Send us a new image.
Is this product missing categories?
Add more categories.
Review This Product
No reviews yet - be the first to create one!