oracle 插入 insert into with select

set feedback off;
set pagesize 0;

create table foo (a number, b varchar(10), c varchar(10));

insert into foo values ( 15, 'abc','def' );
insert into foo values (998, 'max','min' );
insert into foo values (  7, 'bla','bla' );
insert into foo values (632, 'now','then');

insert into foo 
  (a,b,c)
  (select                   AA,
                            BB,
                            CC 
  from
    (select max(a) +1       AA      from foo), 
    (select 'new'           BB,
            'old'           CC      from dual));

select * from foo where a = (select max(a) from foo);

drop table foo;

注意，当需要序列值时，不能放在子查询中

INSERT INTO T_A 
	(id,
	 goodsA_id,
	 goodsB_id,
	 goodsC_id,
	 num,
	 money,
	 dateA_id,
	 dateB_id,
	 create_date)
	(SELECT test1_SEQUENCE.NEXTVAL,
					goodsA_id,
					goodsB_id,
					goodsC_id,
					num,
					money,
					dateA_id,
					dateB_id,
					SYSDATE
	 FROM   (SELECT goodsA_id,
									goodsB_id,
									goodsC_id,
									num,
									33 money
					 FROM   goods_info),
					(SELECT id     dateA_id,
									period dateB_id
					 FROM   date_x
					 WHERE  flagA = 'Y'))