Oracle-[WITH & CONNECT

【文件属性】：
文件名称：Oracle-[WITH & CONNECT
文件大小：769B
文件格式：SQL
更新时间：2016-04-04 08:03:49
Oracle WITH CONNECT with tt as ( select '0' as pid, '1' as id, '1' as name from dual union all select '1' as pid, '2' as id, '2' as name from dual union all select '1' as pid, '3' as id, '3' as name from dual union all select '2' as pid, '5' as id, '5' as name from dual union all select '2' as pid, '4' as id, '4' as name from dual union all select '3' as pid, '6' as id, '6' as name from dual union all select '3' as pid, '7' as id, '7' as name from dual ) select * from tt