文件名称：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