Pro Oracle SQL
Pro Oracle SQL unlocks the power of SQL in the Oracle Database—one of the most potent SQL implementations on the market today. To master it requires a three-pronged approach: learn the language features, learn the supporting features that Oracle provides to help use the language effectively, and lea...
Otros Autores: | |
---|---|
Formato: | Libro electrónico |
Idioma: | Inglés |
Publicado: |
New York :
Apress
2010.
|
Edición: | 1st ed. 2010. |
Colección: | The expert's voice in Oracle Pro Oracle SQL
|
Materias: | |
Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627569606719 |
Tabla de Contenidos:
- Title Page; Copyright Page; Contents at a Glance; Table of Contents; About the Authors; About the Technical Reviewers; Acknowledgments; CHAPTER 1 Core SQL; The SQL Language; Interfacing to the Database; Review of SQL*Plus; Connect to a Database; Configuring the SQL*Plus environment; Executing Commands; The Five Core SQL Statements; The SELECT Statement; The FROM Clause; The WHERE Clause; The GROUP BY Clause; The HAVING Clause; The SELECT List; The ORDER BY Clause; The INSERT Statement; Single-table Inserts; Multi-table Inserts; The UPDATE Statement; The DELETE Statement; The MERGE Statement
- SummaryCHAPTER 2 SQL Execution; Oracle Architecture Basics; SGA - The Shared Pool; The Library Cache; Identical Statements; SGA - The Buffer Cache; Query Transformation; View Merging; Subquery Unnesting; Predicate Pushing; Query Rewrite with Materialized Views; Determining the Execution Plan; Executing the Plan and Fetching Rows; SQL Execution - Putting It All Together; Summary; CHAPTER 3 Access and Join Methods; Full Scan Access Methods; How Full Scan Operations are Chosen; Full Scans and Throwaway; Full Scans and Multiblock Reads; Full Scans and the Highwater Mark; Index Scan Access Methods
- Index StructureIndex Scan Types; Index Unique Scan; Index range scan; Index Full Scan; Index Skip Scan; Index Fast Full Scan; Join Methods; Nested Loops Joins; Sort-Merge Joins; Hash Joins; Cartesian Joins; Outer Joins; Summary; CHAPTER 4 SQL is About Sets; Thinking in Sets; Moving from Procedural to Set-based Thinking; Procedural vs Set-based Thinking: An Example; Set Operations; UNION and UNION ALL; MINUS; INTERSECT; Sets and Nulls; NULLs and Unintuitive Results; NULL Behavior in Set Operations; NULLs and GROUP BY and ORDER BY; NULLs and Aggregate Functions; Summary
- CHAPTER 5 It's About the QuestionAsking Good Questions; The Purpose of Questions; Categories of Questions; Questions about the Question; Questions about Data; Building Logical Expressions; Summary; CHAPTER 6 SQL Execution Plans; Explain Plans; Using Explain Plan; Understanding How EXPLAIN PLAN can Miss the Mark; Reading the Plan; Execution Plans; Viewing Recently Generated SQL; Viewing the Associated Execution Plan; Collecting the Plan Statistics; Identifying SQL Statements for Later Plan Retrieval; Understanding DBMS_XPLAN in Detail; Using Plan Information for Solving Problems; Summary
- CHAPTER 7 Advanced GroupingBasic GROUP BY Usage; HAVING Clause; "New" GROUP BY Functionality; CUBE Extension to GROUP BY; Putting CUBE To Work; Eliminate NULLs with the GROUPING() Function; Extending Reports with GROUPING(); Extending Reports With GROUPING_ID(); GROUPING SETS and ROLLUP(); GROUP BY Restrictions; Summary; CHAPTER 8 Analytic Functions; Example Data; Anatomy of Analytic Functions; List of Functions; Aggregation Functions; Aggregate Function Over An Entire Partition; Granular Window Specifications; Default Window Specification; Lead and Lag; Syntax and Ordering
- Example 1: Returning a Value from Prior Row