Cargando…
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 le...
| Clasificación: | Libro Electrónico |
|---|---|
| Autores principales: | , , , , |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
[Berkeley, California] :
Apress,
[2010]
|
| Colección: | Expert's voice in Oracle.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
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
- 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