Mastering Oracle SQL
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...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, California :
O'Reilly
2004.
|
| Edición: | 2nd ed |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009626882706719 |
Tabla de Contenidos:
- Mastering Oracle SQL, 2nd Edition; 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; From Alan; 1. Introduction to SQL; 1.2. A Brief History of SQL; 1.2.2. Theoretical Versus Practical Terminology; 1.3. A Simple Database; 1.4. DML Statements; 1.4.1.2. Ordering your results; 1.4.1.3. Removing duplicates; 1.4.2. The INSERT Statement; 1.4.2.2. Multitable inserts; 1.4.3. The DELETE Statement; 1.4.4. The UPDATE Statement
- 1.4.5. The MERGE Statement1.5. So Why Are There 17 More Chapters?; 2. The WHERE Clause; 2.2. WHERE to the Rescue; 2.3. WHERE Clause Evaluation; 2.4. Conditions and Expressions; 2.4.2. Membership Conditions; 2.4.3. Range Conditions; 2.4.4. Matching Conditions; 2.4.5. Regular Expressions; 2.4.6. Handling NULL; 2.4.7. Placement of Join Conditions; 2.5. WHERE to Go from Here; 3. Joins; 3.2. Join Conditions; 3.2.2. Conditions Involving Multiple Columns; 3.2.3. The Natural Join Clause; 3.3. Types of Joins; 3.3.2. Inner Joins; 3.3.3. Outer Joins; 3.3.3.2. Right outer joins; 3.3.3.3. Full outer joins
- 3.3.4. Equi-Joins Versus Non-Equi-Joins3.3.5. Self Joins; 3.3.5.2. Self non-equi-joins; 3.3.6. Partition Outer Joins; 3.4. Joins and Subqueries; 3.5. DML Statements on a Join View; 3.5.2. INSERT Statements on a Join View; 3.5.3. DELETE Statements on a Join View; 3.5.4. UPDATE Statements on a Join View; 3.5.5. Data Dictionary Views to Find Updatable Columns; 3.5.6. Impact of WITH CHECK OPTION; 4. Group Operations; 4.1.2. Use of DISTINCT and ALL; 4.2. The GROUP BY Clause; 4.2.1.2. GROUP BY clause must include all nonaggregate expressions
- 4.2.1.3. Aggregate functions not allowed in GROUP BY clause4.2.1.4. Constants can be omitted from the GROUP BY clause; 4.2.1.5. Scalar functions may be grouped by their underlying column; 4.2.1.6. Concatenated columns may be grouped in either of two ways; 4.2.1.7. You can sometimes exclude a nonaggregate expression from the GROUP BY clause; 4.2.1.8. You are not required to show your GROUP BY columns; 4.2.2. GROUP BY Clause and NULL Values; 4.2.3. GROUP BY Clause with WHERE Clause; 4.3. The HAVING Clause; 4.4. Nested Group Operations; 5. Subqueries; 5.2. Noncorrelated Subqueries
- 5.2.2. Multiple-Row, Single-Column Subqueries5.2.3. Multiple-Column Subqueries; 5.2.4. The WITH Clause; 5.3. Correlated Subqueries; 5.4. Inline Views; 5.4.2. Query Execution; 5.4.3. Data Set Fabrication; 5.4.4. Overcoming SQL Restrictions; 5.4.4.2. Aggregate queries; 5.4.5. Inline Views in DML Statements; 5.4.6. Restricting Access Using WITH CHECK OPTION; 5.4.7. Global Inline Views; 5.5. Subquery Case Study: The Top N Performers; 5.5.2. Your Assignment; 5.5.3. Second Attempt; 5.5.4. Final Answer; 6. Handling Temporal Data; 6.1.2. Session Time Zone; 6.2. Temporal Data Types in Oracle
- 6.2.2. The TIMESTAMP Data Types
