orcal 递归

来源:互联网 发布:济南管家婆进销存软件 编辑:程序博客网 时间:2024/05/20 07:34
select distinct t.id, t.biz_org_id,t.biz_org_name,t.PARENT_ID from SYS_ORGANIZATION t where biz_org_type='CORP' start with PARENT_ID = '18CDBB74A3F0448BE055000000000001' 
connect by prior PARENT_ID = id  and parent_id is not null 
0 0
原创粉丝点击