16Hierarchical Retrieval
CERTIFICATION OBJECTIVES
16.01 Interpret the Concept of a Hierarchical Query
16.02 Create and Format Hierarchical Data
16.03 Exclude Branches from the Tree Structure
This chapter discusses the hierarchical query which is based on data structured in a self-join table or view. The hierarchical query uses clauses in the SELECT statement to create a dynamic, tree-structured report appropriate for corporate organization charts, a distribution chain, family genealogy research, or any situation that requires a multilevel data structure.
CERTIFICATION OBJECTIVE 16.01Interpret the Concept of a Hierarchical ...
Get OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.