Connect By/prior/start with usage in Oracle

All ancestor parent directories or all subordinate subdirectories that can be started by using connect By/prior/start with the specified data

Here are two simple examples to learn two ways to use.

Method One:

SELECT DISTINCT t.catalog_id, t.parent_catalog_id from Bi_catalog T-START with t.catalog_id = 324CONNECT by PRIOR T.paren t_catalog_id = t.catalog_id

Method Two:

SELECT DISTINCT t.catalog_id, t.parent_catalog_id from Bi_catalog T-START with t.catalog_id = 324CONNECT by t.catalog_id = PRIOR t.parent_catalog_id

The results of the two methods are the same, as follows

Connect By/prior/start with usage in Oracle