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 (an...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Amsterdam ; Boston :
Elsevier Digital Press
c2005.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627855006719 |
Tabla de Contenidos:
- 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 Architecture3.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 Conditions7.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) ClauseChapter 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
