Mastering Oracle SQL

By: Sanjay Mishra

Write A Review

Paperback | 9 July 2004 | Edition Number 2

At a Glance

Paperback
492 Pages

Edition Type
Revised

Dimensions(cm)
24 x 18 x 0.5

The Big Book Sale

T&Cs apply. Limited time only.

Ends 30/06/26

View Promotion >

Paperback

RRP $95.00

$10.00

89%OFF

or 4 interest-free payments of $2.50 with

In Stock and Ships next day

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.

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $49.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Computer Programming & Software Development Database Programming Databases Database Software Oracle Data Mining Booktopia Publisher Services John Wiley & Sons Publishers UK Data Warehousing Bargains

Non-Fiction Bargains Autobiography and Biography Bargains

Preface	p. ix
Introduction to SQL	p. 1
What Is SQL?	p. 1
A Brief History of SQL	p. 3
A Simple Database	p. 4
DML Statements	p. 5
So Why Are There 17 More Chapters?	p. 17
The Where Clause	p. 18
Life Without Where	p. 18
Where to the Rescue	p. 19
Where Clause Evaluation	p. 20
Conditions and Expressions	p. 23
Where to Go from Here	p. 30
Joins	p. 31
What Is a Join Query?	p. 31
Join Conditions	p. 32
Types of Joins	p. 37
Joins and Subqueries	p. 53
DML Statements on a Join View	p. 53
Group Operations	p. 62
Aggregate Functions	p. 62
The Group By Clause	p. 66
The Having Clause	p. 74
Nested Group Operations	p. 77
Subqueries	p. 80
What Is a Subquery?	p. 80
Noncorrelated Subqueries	p. 81
Correlated Subqueries	p. 88
Inline Views	p. 91
Subquery Case Study: The Top N Performers	p. 106
Handling Temporal Data	p. 112
Time Zones	p. 112
Temporal Data Types in Oracle	p. 114
Literals of Temporal Types	p. 120
Getting Temporal Data In and Out of a Database	p. 126
Date and Time Formats	p. 134
Manipulating Temporal Data	p. 146
Set Operations	p. 166
Set Operators	p. 167
Precedence of Set Operators	p. 172
Comparing Two Tables	p. 173
Using NULLs in Compound Queries	p. 176
Rules and Restrictions on Set Operations	p. 178
Hierarchical Queries	p. 181
Representing Hierarchical Information	p. 181
Simple Hierarchy Operations	p. 184
Oracle SQL Extensions	p. 187
Complex Hierarchy Operations	p. 193
Restrictions on Hierarchical Queries	p. 204
Enhancements in Oracle Database 10g	p. 204
Decode and Case	p. 210
Decode, Nullif, NVL, and NVL2	p. 210
The Case for Case	p. 214
Decode and Case Examples	p. 217
Partitioning	p. 230
Partitioning Concepts	p. 230
Partitioning Tables	p. 231
Partitioning Indexes	p. 231
Partitioning Methods	p. 232
Specifying Partitions	p. 238
Partition Pruning	p. 239
PL/SQL	p. 243
What Is PL/SQL?	p. 243
Procedures, Functions, and Packages	p. 244
Calling Stored Functions from Queries	p. 246
Restrictions on Calling PL/SQL from SQL	p. 251
Stored Functions in DML Statements	p. 254
The SQL Inside Your PL/SQL	p. 256
Objects and Collections	p. 258
Object Types	p. 258
Collection Types	p. 267
Collection Instantiation	p. 268
Querying Collections	p. 269
Collection Unnesting	p. 270
Collection Functions	p. 271
Comparing Collections	p. 273
Manipulating Collections	p. 275
Multilevel Collections	p. 276
Advanced Group Operations	p. 279
Multiple Summary Levels	p. 279
Pushing the Grouping Envelope	p. 301
The Grouping_ID and Group_ID Functions	p. 311
Advanced Analytic SQL	p. 320
Analytic SQL Overview	p. 320
Ranking Functions	p. 326
Windowing Functions	p. 339
Reporting Functions	p. 346
Summary	p. 351
SQL Best Practices	p. 352
Know When to Use Specific Constructs	p. 352
Avoid Unnecessary Parsing	p. 358
Consider Literal SQL for Decision-Support Systems	p. 363
XML	p. 365
What Is XML?	p. 365
Storing XML Data	p. 366
Generating XML Documents	p. 382
Summary	p. 387
Regular Expressions	p. 389
Elementary Regular Expression Syntax	p. 389
Advanced Function Options	p. 401
Advanced Regular Expression Syntax	p. 405
Model Queries	p. 417
Basic Elements of a Model Query	p. 417
Cell References	p. 419
Rules	p. 427
Iterative Models	p. 442
Reference Models	p. 445
Oracle's Old Join Syntax	p. 449
Index	p. 455
Table of Contents provided by Ingram. All Rights Reserved.

Mastering Oracle SQL

At a Glance

The Big Book Sale

T&Cs apply. Limited time only.

Paperback

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Databases

Microsoft Power BI For Dummies

For Dummies (Computer/Tech)

Statistics and Data Handling for Biologists

A Student's Guide

Statistics and Data Handling for Biologists

A Student's Guide

Stochastic Control in Energy, Environmental and Resource Management Applications

Emerging Methodologies and Applications in Modelling, Identification and Control

Proceedings of the 6th International Conference on Big Data Analytics for Cyber-Physical System in Smart City, Volume 1

BDCPS 2024, December 7-8, Ji'an, China

Data Science and Social Research III

Epistemology, Methods, Technology, Applications, and Relation to Artificial Intelligence

Architecting an Apache Iceberg Lakehouse

A Scalable, Open-Source Data Platform

Python All-in-One For Dummies

3rd Edition

Code

2nd Edition - The Hidden Language of Computer Hardware and Software

Hands-On Programming with R

Write Your Own Functions and Simulations

Confident Data Skills

Master the Fundamentals of Working with Data and Supercharge Your Career

Microsoft 365 Access For Dummies

Access for Dummies

The Art of Explanation

How to Communicate with Clarity and Confidence

The Value of People Analytics

Using HR Data to Drive Business Results

Coding All-in-One For Dummies

2nd Edition

Microsoft Excel 365 Bible

Bible

Storytelling with Data

A Data Visualization Guide for Business Professionals, 10th Anniversary Edition

Database Systems 6ed

A Practical Approach to Design, Implementation, and Management, Global Edition

Artificial Intelligence for HR

Use AI to Support and Develop a Successful Workforce

SQL Essentials For Dummies

For Dummies (Computer/Tech)

Fundamentals of Data Engineering

Plan and Build Robust Data Systems

Analytics Engineering with SQL and Dbt

Building Meaningful Data Models at Scale

Data-driven BIM for Energy Efficient Building Design

1st Edition

Building a Scalable Data Warehouse with Data Vault 2.0

This product is categorised by