oracle中insert语句怎么嵌入select

insert into select可洞含以将select 出来的N行(0到任意数)结果集复制一个新表中，select into from只能将"一行"结果复制到一个变量中。这样说吧，select into是PL/SQL language 的赋值语句。而前者是标准的SQL语句。做一个测试看两者差别。首先创建两个表，一个作为源表，一个作为目标表。create table t_source( id number primary key, testname varchar2(20), createtime date, flag varchar2(10) );create table t_target( id number primary key, testname varchar2(20), createtime date, flag varchar2(10) );接着，插入测试数据insert into t_source values(1,'测试数据1....1',sysdate-2,'N'); insert into t_source values(2,'测试数据1....2',sysdate-2,'N'); insert into t_source values(3,'测试数据1....3',sysdate-2,'N'); commit;测试insert into select 操作insert into test2 select * from t_source where id=1; commit;测试select into 操作因为select into是一个plsql语言中的复制语句，和:=实现的目标一雹档样。create or replace procedure sp_sync_test isaa varchar2(100);v_record t_source%rowtype; beginselect t1.testname into aa from t_source t1 where id = 1;dbms_output.put_line('普通变纳肆笑量 t1.testname= ' || aa);select t1.* into v_record from t_source t1 where id = 1;dbms_output.put_line('记录变量 t1.testname= ' || v_record.testname);end;这里增加了原始类型的变量和记录类型的变量

标签：oracle,insert,select