Hierarchical Queries in Oracle
HIERARCHICAL QUERIES IN ORACLE WITH TEAMSQL
Standard SQL doesn’t support hierarchical or recursive queries. However, in the relational data model we usually create tables with an intrinsic recursive nature. Many database engines add proprietary extensions to SQL to support recursive queries. In this article, we will explain how to query these kinds of tables in Oracle using TeamSQL.
There are some different clauses in Oracle to use in hierarchical or recursive queries. We will cover the ...