Oracle Start With 备查

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

posted @ 2022-08-02 17:13  太晓  阅读(9)  评论(0编辑  收藏  举报