Oracle SQL revealed : executing business logic in the database engine /: executing business logic in the database engine. (2018)

• Record Type: Book
• Further Information: Note: Alex Reprintsev.
• Authors: Reprintsev, Alex
• Contents: Intro; Table of Contents; About the Author; Introduction; Part I: Features and Theory; Chapter 1: Joins; ANSI Joins; Other Types of Joins; Oracle-Specific Syntax; ANSI vs. Oracle Native Syntax; Limitation of the Oracle Native Syntax; Unnesting Collections; Correlated Inline Views and Subqueries; ANSI to Native Transformation; Clearness and Readability; Mixing Syntax; Controlling Execution Plan; Limitations of ANSI; Summary; Chapter 2: Query Transformations; Summary; Chapter 3: Analytic Functions; Differences and Interchangeability of Functions; Summary; Chapter 4: Aggregate Functions. Pivot and Unpivot OperatorsCube, Rollup, Grouping Sets; Summary; Chapter 5: Hierarchical Queries: Connect by; Pseudocolumn Generation in Detail; Summary; Chapter 6: Recursive Subquery Factoring; Traversing Hierarchies; Once Again About Cycles; Limitations of the Current Implementation; Summary; Chapter 7: Model; Brief Analysis of the Performance; Model Parallel Execution; Summary; Chapter 8: Row Pattern Matching: match_recognize; Summary; Chapter 9: Logical Execution Order of Query Clauses; Summary; Chapter 10: Turing Completeness; Summary; Part II: PL/SQL and SQL solutions. Chapter 11: When PL/SQL Is Better Than Vanilla SQLSpecifics of Analytic Functions; Fetch Termination; Avoiding Multiple Sorts; Iterative-Like Computations; When There Is No Effective Built-In Access Method; Problems of a Combinatorial Nature; Specifics of Joins and Subqueries; Specifics of Joins; Limitations of the Subqueries; Summary; Chapter 12: Solving SQL Quizzes; Converting into Decimal Numeral System; Solution; Connected Components; Solution; Ordering Dependencies; Solution; Percentile with Shift; Solution; N Consequent 1s; Solution; Next Value; Solution; Next Branch; Solution. Random SubsetSolution; Covering Ranges; Solution; Zeckendorf Representation; Solution; Top Paths; Solution; Resemblance Group; Solution; Baskets; Solution; Longest Increasing Subsequence; Solution; Quine; Solution; Summary; Appendix A: Useful Oracle Links; Index.
• Publisher Details: United States : Apress
• Publication Date: 2018
• Copyright Date: 2018
• Extent: 1 online resource
• Subjects: 005.756; Computer science; SQL (Computer program language); COMPUTERS -- Programming -- General; SQL (Computer program language); Computer Science; Database Management; Database management; Computers -- Database Management -- General; Databases; Electronic books; Electronic book
• Languages: English
• ISBNs: 9781484233726; 1484233727
• Related ISBNs: 9781484233719; 1484233719
• Notes: Note: Includes bibliographical references and index.; Note: Online resource; title from PDF title page (EBSCO, viewed April 16, 2018).
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.