Flylib.com
Mastering Oracle SQL, 2nd Edition
Mastering Oracle SQL, 2nd Edition
ISBN: 0596006322
EAN: 2147483647
Year: 2003
Pages: 154
Authors:
Sanjay Mishra
,
Alan Beaulieu
BUY ON AMAZON
Mastering Oracle SQL, 2nd Edition
Table of Contents
Copyright
Preface
Why We Wrote This Book
What s New in Oracle SQL?
Objectives of This Book
Audience for This Book
Platform and Version
Structure of This Book
Conventions Used in This Book
Using Code Examples
Comments and Questions
Acknowledgments
Chapter 1. Introduction to SQL
1.1 What Is SQL?
1.2 A Brief History of SQL
1.3 A Simple Database
1.4 DML Statements
1.5 So Why Are There 17 More Chapters?
Chapter 2. The WHERE Clause
2.1 Life Without WHERE
2.2 WHERE to the Rescue
2.3 WHERE Clause Evaluation
2.4 Conditions and Expressions
2.5 WHERE to Go from Here
Chapter 3. Joins
3.1 What Is a Join Query?
3.2 Join Conditions
3.3 Types of Joins
3.4 Joins and Subqueries
3.5 DML Statements on a Join View
Chapter 4. Group Operations
4.1 Aggregate Functions
4.2 The GROUP BY Clause
4.3 The HAVING Clause
4.4 Nested Group Operations
Chapter 5. Subqueries
5.1 What Is a Subquery?
5.2 Noncorrelated Subqueries
5.3 Correlated Subqueries
5.4 Inline Views
5.5 Subquery Case Study: The Top N Performers
Chapter 6. Handling Temporal Data
6.1 Time Zones
6.2 Temporal Data Types in Oracle
6.3 Literals of Temporal Types
6.4 Getting Temporal Data In and Out of a Database
6.5 Date and Time Formats
6.6 Manipulating Temporal Data
Chapter 7. Set Operations
7.1 Set Operators
7.2 Precedence of Set Operators
7.3 Comparing Two Tables
7.4 Using NULLs in Compound Queries
7.5 Rules and Restrictions on Set Operations
Chapter 8. Hierarchical Queries
8.1 Representing Hierarchical Information
8.2 Simple Hierarchy Operations
8.3 Oracle SQL Extensions
8.4 Complex Hierarchy Operations
8.5 Restrictions on Hierarchical Queries
8.6 Enhancements in Oracle Database 10g
Chapter 9. DECODE and CASE
9.1 DECODE, NULLIF, NVL, and NVL2
9.2 The Case for CASE
9.3 DECODE and CASE Examples
Chapter 10. Partitioning
10.1 Partitioning Concepts
10.2 Partitioning Tables
10.3 Partitioning Indexes
10.4 Partitioning Methods
10.5 Specifying Partitions
10.6 Partition Pruning
Chapter 11. PLSQL
11.1 What Is PLSQL?
11.2 Procedures, Functions, and Packages
11.3 Calling Stored Functions from Queries
11.4 Restrictions on Calling PLSQL from SQL
11.5 Stored Functions in DML Statements
11.6 The SQL Inside Your PLSQL
Chapter 12. Objects and Collections
12.1 Object Types
12.2 Collection Types
12.3 Collection Instantiation
12.4 Querying Collections
12.5 Collection Unnesting
12.6 Collection Functions
12.7 Comparing Collections
12.8 Manipulating Collections
12.9 Multilevel Collections
Chapter 13. Advanced Group Operations
13.1 Multiple Summary Levels
13.2 Pushing the GROUPING Envelope
13.3 The GROUPING_ID and GROUP_ID Functions
Chapter 14. Advanced Analytic SQL
14.1 Analytic SQL Overview
14.2 Ranking Functions
14.3 Windowing Functions
14.4 Reporting Functions
14.5 Summary
Chapter 15. SQL Best Practices
15.1 Know When to Use Specific Constructs
15.2 Avoid Unnecessary Parsing
15.3 Consider Literal SQL for Decision-Support Systems
Chapter 16. XML
16.1 What Is XML?
16.2 Storing XML Data
16.3 Generating XML Documents
16.4 Summary
Chapter 17. Regular Expressions
17.1 Elementary Regular Expression Syntax
17.2 Advanced Function Options
17.3 Advanced Regular Expression Syntax
Chapter 18. Model Queries
18.1 Basic Elements of a Model Query
18.2 Cell References
18.3 Rules
18.4 Iterative Models
18.5 Reference Models
Appendix A. Oracle s Old Join Syntax
A.1 Old Inner Join Syntax
A.2 Old Outer Join Syntax
A.3 Advantages of the New Join Syntax
Colophon
Index
index_SYMBOL
index_A
index_B
index_C
index_D
index_E
index_F
index_G
index_H
index_I
index_J
index_K
index_L
index_M
index_N
index_O
index_P
index_Q
index_R
index_S
index_T
index_U
index_V
index_W
index_X
index_Y
Mastering Oracle SQL, 2nd Edition
ISBN: 0596006322
EAN: 2147483647
Year: 2003
Pages: 154
Authors:
Sanjay Mishra
,
Alan Beaulieu
BUY ON AMAZON
Absolute Beginner[ap]s Guide to Project Management
Essential Elements for any Successful Project
Setting the Stage for Success
Managing Project Issues
Managing Project Risks
Seven Powerful Principles
Inside Network Security Assessment: Guarding Your IT Infrastructure
Security and the Employee (Social Engineering)
Introducing the Assessment Process
Contents of a Good Report
Statement of Work
Analysis
Metrics and Models in Software Quality Engineering (2nd Edition)
Fundamentals of Measurement Theory
Level of Measurement
Run Charts
Measuring Levels Is Not Enough
Measuring Process Compliance
Cisco IP Telephony (CIPT) (Authorized Self-Study) (2nd Edition)
Cisco Unified CallManager Advanced Route Plans
Conference Bridge Resources
Call Routing and Call Queuing
Call Admission Control Between Clusters
Java for RPG Programmers, 2nd Edition
Javas Language And Syntax
Structured Operations And Statements
String Manipulation
An Object Orientation
User Interface
Ruby Cookbook (Cookbooks (OReilly))
Summing the Items of an Array
Using Berkeley DB Databases
Creating a Mac OS X Application with RubyCocoa
Running Code as Another User
Renaming Files in Bulk
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies