Refer to CONNECT_BY_ISCYCLE Pseudocolumn for more information. Use this parameter along with the CONNECT_BY_ISCYCLE pseudocolumn to see which rows contain the loop. The NOCYCLE parameter instructs Oracle Database to return rows from a query even if a CONNECT BY loop exists in the data. START WITH specifies the root row(s) of the hierarchy.ĬONNECT BY specifies the relationship between parent rows and child rows of the hierarchy.
If a table contains hierarchical data, then you can select rows in a hierarchical order using the hierarchical query clause:ĭescription of the illustration ''hierarchical_query_clause.gif''Ĭondition can be any condition as described in Chapter 6, "Conditions".
0 kommentar(er)
