Oracle SQL Revealed
- نوع فایل : کتاب
- زبان : انگلیسی
- نویسنده : Alex Reprintsev
- چاپ و سال / کشور: 2018
- تعداد صفحه : 389
- شابک / ISBN : 1484233719
Description
Tagline: Learn about analytic functions, the model clause, row pattern matching, and other powerful features in Oracle SQL
Table of ContentsPart I: Features and TheoryChapter 1: JoinsChapter 2: Query TransformationsChapter 3: Analytic FunctionsChapter 4: Aggregate FunctionsChapter 5: Hierarchical Queries: Connect byChapter 6: Recursive Subquery FactoringChapter 7: ModelChapter 8: Row Pattern Matching: match_recognizeChapter 9: Logical Execution Order of Query ClausesChapter 10: Turing Completeness
Part II: PL/SQL and SQL solutionsChapter 11: When PL/SQL Is Better Than Vanilla SQLChapter 12: Solving SQL Quizzes
Appendix A: Useful Oracle Links
Table of ContentsPart I: Features and TheoryChapter 1: JoinsChapter 2: Query TransformationsChapter 3: Analytic FunctionsChapter 4: Aggregate FunctionsChapter 5: Hierarchical Queries: Connect byChapter 6: Recursive Subquery FactoringChapter 7: ModelChapter 8: Row Pattern Matching: match_recognizeChapter 9: Logical Execution Order of Query ClausesChapter 10: Turing Completeness
Part II: PL/SQL and SQL solutionsChapter 11: When PL/SQL Is Better Than Vanilla SQLChapter 12: Solving SQL Quizzes
Appendix A: Useful Oracle Links
