Oracle SQL Revealed: Executing Business Logic in the Database Engine
- Length: 389 pages
- Edition: 1st ed.
- Language: English
- Publisher: Apress
- Publication Date: 2018-04-10
- ISBN-10: 1484233719
- ISBN-13: 9781484233719
- Sales Rank: #1998091 (See Top 100 Books)
Description
Tagline: Learn about analytic functions, the model clause, row pattern matching, and other powerful features in Oracle SQL
Table of Contents
Part I: Features and Theory
Chapter 1: Joins
Chapter 2: Query Transformations
Chapter 3: Analytic Functions
Chapter 4: Aggregate Functions
Chapter 5: Hierarchical Queries: Connect by
Chapter 6: Recursive Subquery Factoring
Chapter 7: Model
Chapter 8: Row Pattern Matching: match_recognize
Chapter 9: Logical Execution Order of Query Clauses
Chapter 10: Turing Completeness
Part II: PL/SQL and SQL solutions
Chapter 11: When PL/SQL Is Better Than Vanilla SQL
Chapter 12: Solving SQL Quizzes
Appendix A: Useful Oracle Links
Free ChaptersTry Audible and Get Two Free Audiobooks »
To access the link, solve the captcha.
Recommended BooksMore Similar Books »