Oracle把一个表里的数据取出直接插进另外一个表SQL详解

 

oracle中把一个表里的数据取出直接插进另外一个表语法：INSERT INTO...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;