Корично изображение Електронна книга

Oracle SQL : Jumpstart with examples /

Developers and DBAs use Oracle SQL coding on a daily basis, whether for application development, finding problems, fine-tuning solutions to those problems, or other critical DBA tasks. Oracle SQL: Jumpstart with Examples is the fastest way to get started and to quickly locate answers to common (and...

Пълно описание

Основен автор: Powell, Gavin.
Други автори: McCullough-Dieter, Carol.
Формат: Електронна книга
Език: English
Публикувано: Amsterdam ; Boston : Elsevier Digital Press, ℗♭2005.
Предмети:
Oracle (Computer file)
SQL (Computer program language)
COMPUTERS > Programming Languages > C♯
COMPUTERS > Programming Languages > Java.
COMPUTERS > Programming Languages > Pascal.
Electronic books.
Онлайн достъп: http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=117183
Подобни документи: Print version:: Oracle SQL.
Съдържание:
  • Cover
  • 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 XM.

Подобни библ. документи