select * from table t where t.a = 'value' start with t.v in ('v1','v2','v3') connect by [nocycle] prior t.v = t.p