摘要:
基本语法select...from tabename start with cond1 connect by prior cond2 where cond2注:cond1是根节点的限定语句cond2是连接条件,其中prior表示上一条记录,指该记录的父亲是上一条记录cond3是过滤条件构造环境:不说你懂的create table Family(id integer,parentid integer,name varchar2(50))insert into family values(0,0,'a')insert into family values(1,0,'b 阅读全文