Orace Tips – Recursive query

select PK_ID
from USERS
start with FK_USER_PARENT = PK_USER
connect by prior PK_ID = FK_USER_PARENT;

select PK_ID

from USERS

start with FK_USER_PARENT = PK_USER

connect by prior PK_ID = FK_USER_PARENT;