Mastering Oracle SQL, 2nd Edition - page 1
- 1
- 2
- 11.6 The SQL Inside Your PLSQL
- Chapter 12. Objects and Collections
- 12.1 Object Types
- 12.2 Collection Types
- 12.3 Collection Instantiation
- 12.4 Querying Collections
- 12.5 Collection Unnesting
- 12.6 Collection Functions
- 12.7 Comparing Collections
- 12.8 Manipulating Collections
- 12.9 Multilevel Collections
- Chapter 13. Advanced Group Operations
- 13.1 Multiple Summary Levels
- 13.2 Pushing the GROUPING Envelope
- 13.3 The GROUPING_ID and GROUP_ID Functions
- Chapter 14. Advanced Analytic SQL
- 14.1 Analytic SQL Overview
- 14.2 Ranking Functions
- 14.3 Windowing Functions
- 14.4 Reporting Functions
- 14.5 Summary
- Chapter 15. SQL Best Practices
- 15.1 Know When to Use Specific Constructs
- 15.2 Avoid Unnecessary Parsing
- 15.3 Consider Literal SQL for Decision-Support Systems
- Chapter 16. XML
- 16.1 What Is XML?
- 16.2 Storing XML Data
- 16.3 Generating XML Documents
- 16.4 Summary
- Chapter 17. Regular Expressions
- 17.1 Elementary Regular Expression Syntax
- 17.2 Advanced Function Options
- 17.3 Advanced Regular Expression Syntax
- Chapter 18. Model Queries
- 18.1 Basic Elements of a Model Query
- 18.2 Cell References
- 18.3 Rules
- 18.4 Iterative Models
- 18.5 Reference Models
- Appendix A. Oracle s Old Join Syntax
- A.1 Old Inner Join Syntax
- A.2 Old Outer Join Syntax
- A.3 Advantages of the New Join Syntax
- Colophon
- Index
- index_SYMBOL
- index_A
- index_B
- index_C
- index_D
- index_E
- index_F
- index_G
- index_H
- index_I
- index_J
- index_K
- index_L
- index_M
- index_N
- index_O
- index_P
- index_Q
- index_R
- index_S
- index_T
- index_U
- index_V
- index_W
- index_X
- index_Y
- 1
- 2
