Oracle SQL

Name: Oracle SQL | Jumpstart with Examples
Brand: Elsevier
Price: 64.95 EUR
Availability: OnlineOnly

Jumpstart with Examples

Gavin JT Powell Carol McCullough-Dieter(Autor*in)

Elsevier (Verlag)

Erschienen am 15. Oktober 2004

688 Seiten

E-Book

PDF mit Wasserzeichen-DRM

Systemvoraussetzungen

978-0-08-047983-5 (ISBN)

64,95 €inkl. 7% MwSt.

Systemvoraussetzungen

für PDF mit Wasserzeichen-DRM

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

Weitere Details

Weitere Ausgaben

Personen

Inhalt

Front Cover
Oracle SQL Jumpstart with Examples
Copyright Page
Table of Contents
Foreword
Preface
Acknowledgements
Chapter 1. Introduction to Oracle SQL
1.1 A Little History
1.2 The Basics of Relational Data Modeling
1.3 Structured Query Language (SQL)
1.4 Software Useful for Reading this Book
1.5 Syntax Conventions Used in This Book
1.6 SQL Tools
1.7 The MUSIC Schema
Chapter 2. New Features of Oracle SQL
2.1 New Features in Oracle Database 10g
2.2 New Features in Oracle Database 9i
Chapter 3. Oracle Database Architecture
3.1 The Basic Concepts
3.2 The Oracle Instance
3.3 Oracle Database Physical Architecture
3.4 Database Startup and Shutdown
3.5 Enhancing the Physical Architecture
Chapter 4. The SELECT Statement
4.1 The Basic SELECT Statement
4.2 Types of SELECT Queries
4.3 Other Aspects of the SELECT Statement
Chapter 5. Filtering Rows
5.1 WHERE Clause Syntax
5.2 WHERE Clause Expression Conditions
5.3 Logical Operators in the WHERE Clause
5.4 Top-N Queries
Chapter 6. Sorting Rows
6.1 ORDER BY Clause Syntax
6.2 Sorting and Null Values
6.3 Sorting Methods
Chapter 7. Operators, Conditions, and Pseudocolumns
7.1 Precedence
7.2 Operators
7.3 Conditions
7.4 Pseudocolumns
Chapter 8. Using SQL*Plus
8.1 Environmental Settings
8.2 Using Scripts and Variables
8.3 Formatting Query Output in SQL*Plus
8.4 Using iSQL*Plus
Chapter 9. Single-Row Functions
9.1 Types of Functions
9.2 Single-Row Functions
9.3 Combining Functions
Chapter 10. Joining Tables
10.1 Join Formats
10.2 Types of Joins
10.3 Examining Different Types of Joins
Chapter 11. Grouping and Summarizing Data
11.1 GROUP BY Clause Syntax
11.2 Types of Group Functions
11.3 Special Grouping Function Behavior
11.4 Using the GROUP BY Clause
11.5 10g The SPREADSHEET (MODEL) Clause
Chapter 12. Subqueries
12.1 Types of Subqueries
12.2 Where Can Subqueries Be Used?
12.3 Comparison Conditions and Subqueries
12.4 Demonstrating Subqueries
Chapter 13. Unusual Query Types
13.1 Composite Queries
13.2 Hierarchical Queries
13.3 Flashback and Versions Queries
13.4 Parallel Queries
Chapter 14. Expressions
14.1 Types of Expressions
14.2 10g Regular Expressions
14.3 10g Oracle Expression Filter
Chapter 15. Data Manipulation Language (DML)
15.1 What Is DML?
15.2 Transaction Control
15.3 Adding Data (INSERT)
15.4 Changing Data (UPDATE)
15.5 Deleting Data (DELETE)
15.6 10g Merging New and Old Data (MERGE)
Chapter 16. Datatypes and Collections
16.1 Simple Datatypes
16.2 Complex and Object Datatypes
16.3 Special Datatypes
Chapter 17. XML in Oracle
17.1 What Is XML?
17.2 Using XML in Oracle
17.3 Metadata Views
Chapter 18. Tables
18.1 What Is a Table?
18.2 CREATE TABLE Syntax
18.3 Creating Different Table Types
18.4 Changing Table Structure
18.5 Dropping a Table
18.6 Adding Comments to Tables
18.7 10g The Recycle Bin
18.8 Metadata Views
Chapter 19. Views
19.1 What Is a View?
19.2 Types and Uses of Views
19.3 CREATE VIEW Syntax
19.4 Changing and Dropping Views
19.5 Working with Views
19.6 Metadata Views
19.7 Data Dictionary Views (Metadata)
Chapter 20. Constraints
20.1 What Are Constraints?
20.2 Managing Constraints
20.3 Adding, Modifying, and Dropping Constraints
20.4 Metadata Views
Chapter 21. Indexes and Clusters
21.1 Indexes
21.2 Clusters
21.3 Metadata Views
Chapter 22. Sequences and Synonyms
22.1 Sequences
22.2 Synonyms
22.3 Metadata Views
Chapter 23. Security
23.1 Users
23.2 Privileges
23.3 Grouping Privileges Using Roles
23.4 Metadata Views
Chapter 24. Basic PL/SQL
24.1 What is PL/SQL?
24.2 Why Is PL/SQL a Programming Language?
24.3 Variables and Datatypes in PL/SQL
24.4 Retrieving Data in PL/SQL
24.5 Changing Data in PL/SQL
24.6 Dynamic SQL
24.7 Control Structures
24.8 Objects and Methods
24.9 Oracle-Provided Packages
24.10 Metadata Views
Appendix A. Schema Scripting
Appendix B. Utility Scripts
Appendix C. Sources of Information
Index

Systemvoraussetzungen

Als PDF speichern Als Link merken