insert 与 with as的联合使用??

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);