Mastering Oracle SQL

ISBN-10: 0596006322

ISBN-13: 9780596006327

Edition: 2nd 2004

List price: $39.95 Buy it from $19.62
eBook available
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy


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 oftenoverlooked) power of Oracle SQL, this essential guide for putting Oracle SQL to work will prove invaluable.
Used Starting from $19.62
New Starting from $30.02
eBooks Starting from $31.99
Rent eBooks
Buy eBooks
what's this?
Rush Rewards U
Members Receive:
You have reached 400 XP and carrot coins. That is the daily max!
Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS PowerPoint® 2010 Online content $4.95 $1.99
Customers also bought

Book details

List price: $39.95
Edition: 2nd
Copyright year: 2004
Publisher: O'Reilly Media, Incorporated
Publication date: 7/2/2004
Binding: Paperback
Pages: 496
Size: 6.75" wide x 9.00" long x 1.25" tall
Weight: 1.738
Language: English

Sanjay Mishra has more than 12 years of experience working with Oracle systems. His key areas of interest include database architecture, database administration, performance management, scalability, software development and data modelling for mission-critical and decision support applications. He holds a Bachelor of Science degree in Electrical Engineering, and a Master of Engineering degree in Systems Science and Automation. He is the co-author of the books Oracle Parallel Processing and Oracle SQL Loader: The Definitive Guide (both published by O'Reilly Media, Inc.). Sanjay has published several technical papers in Oracle Magazine and SELECT Journal, and has presented many technical papers at various regional, national and international conferences.

Alan Beaulieu has been designing, building, and implementing custom database applications for over 13 years. He currently runs his own consulting company that specializes in designing Oracle databases and supporting services in the fields of Financial Services and Telecommunications. In building large databases for both OLTP and OLAP environments, Alan utilizes such Oracle features as Parallel Query, Partitioning, and Parallel Server. Alan has a Bachelor of Science degree in Operations Research from the Cornell University School of Engineering. He lives in Massachusetts with his wife and two daughters and can be reached at

Introduction to SQL
What Is SQL?
A Brief History of SQL
A Simple Database
DML Statements
So Why Are There 17 More Chapters?
The Where Clause
Life Without Where
Where to the Rescue
Where Clause Evaluation
Conditions and Expressions
Where to Go from Here
What Is a Join Query?
Join Conditions
Types of Joins
Joins and Subqueries
DML Statements on a Join View
Group Operations
Aggregate Functions
The Group By Clause
The Having Clause
Nested Group Operations
What Is a Subquery?
Noncorrelated Subqueries
Correlated Subqueries
Inline Views
Subquery Case Study: The Top N Performers
Handling Temporal Data
Time Zones
Temporal Data Types in Oracle
Literals of Temporal Types
Getting Temporal Data In and Out of a Database
Date and Time Formats
Manipulating Temporal Data
Set Operations
Set Operators
Precedence of Set Operators
Comparing Two Tables
Using NULLs in Compound Queries
Rules and Restrictions on Set Operations
Hierarchical Queries
Representing Hierarchical Information
Simple Hierarchy Operations
Oracle SQL Extensions
Complex Hierarchy Operations
Restrictions on Hierarchical Queries
Enhancements in Oracle Database 10g
Decode and Case
Decode, Nullif, NVL, and NVL2
The Case for Case
Decode and Case Examples
Partitioning Concepts
Partitioning Tables
Partitioning Indexes
Partitioning Methods
Specifying Partitions
Partition Pruning
What Is PL/SQL?
Procedures, Functions, and Packages
Calling Stored Functions from Queries
Restrictions on Calling PL/SQL from SQL
Stored Functions in DML Statements
The SQL Inside Your PL/SQL
Objects and Collections
Object Types
Collection Types
Collection Instantiation
Querying Collections
Collection Unnesting
Collection Functions
Comparing Collections
Manipulating Collections
Multilevel Collections
Advanced Group Operations
Multiple Summary Levels
Pushing the Grouping Envelope
The Grouping_ID and Group_ID Functions
Advanced Analytic SQL
Analytic SQL Overview
Ranking Functions
Windowing Functions
Reporting Functions
SQL Best Practices
Know When to Use Specific Constructs
Avoid Unnecessary Parsing
Consider Literal SQL for Decision-Support Systems
What Is XML?
Storing XML Data
Generating XML Documents
Regular Expressions
Elementary Regular Expression Syntax
Advanced Function Options
Advanced Regular Expression Syntax
Model Queries
Basic Elements of a Model Query
Cell References
Iterative Models
Reference Models
Oracle's Old Join Syntax
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.