Abstract
The connect by clause is used to query hierarchies if they are stored as parent-child relationships, also known as an adjacency lists model. Simply speaking, this model means that a parent – child pair is stored for each child. In general adjacency lists can represent directed graphs, not only hierarchy trees; in this case the list describes the set of neighbors of a vertex in the graph. So an adjacency list model is much wider and a parent-child model is one of its implementations.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2018 Alex Reprintsev
About this chapter
Cite this chapter
Reprintsev, A. (2018). Hierarchical Queries: Connect by. In: Oracle SQL Revealed. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-3372-6_5
Download citation
DOI: https://doi.org/10.1007/978-1-4842-3372-6_5
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-3371-9
Online ISBN: 978-1-4842-3372-6
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books