insert 与 with as的联合使用??
http://www.itpub.net/viewthread.php?tid=1397088&pid=17273772&page=1&extra=page%3D1#pid17273772
insert into one(id)
with te as (select 1 l from dual)
select id from one where one.id in (
select l from te) values(id);