oracle顶用START WITH.CONNECT BY PRIOR 视图demo

oracle中用START WITH...CONNECT BY PRIOR 视图demo
oracle中用START WITH...CONNECT BY PRIOR含义句实现递归查询

create or replace view view_test as
select id,item_name,parent_id from tb_item where 1=1 start with parent_id = 1 connect by prior id = parent_id

这个视图查询结果是一个树状结构存储在一张表里