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 is
aa varchar2(100);
v_record t_source%rowtype;
begin
select 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;
è¿éå¢å äºåå§ç±»åçåéåè®°å½ç±»åçåé
温馨提示:答案为网友推荐,仅供参考