Oracle Connect by recursion, reverse recursion, auto-complete query implementation

Recursion:

SELECT *
From t_pams_solution t
Start with t.id is null
Connect by prior id = t.parent_id
ORDER BY level DESC

The red characters are the table name, the start condition, the child node and the root association condition respectively.

Reverse recursion:

Select RowNum num,
Level Lev,
Connect_by_root (ID) ID,
Connect_by_root (solution_name) name
From t_pams_solution t
where t.id = 23379
Start with 1 = 1
Connect by prior id = t.parent_id
ORDER BY level DESC

The red characters are the table name, the start condition, the child node and the root association condition respectively.

Auto-complete query:

Select level from dual
Connect by Level <10

Oracle Connect by recursion, reverse recursion, auto-complete query implementation