insert into 表1(字段A,字段B) select 变量a,字段b from 表2 这个语句怎么写??
如:
declare
c_CARDNO VARCHAR2(20):='00000000000000000000';
c_CARDPASS VARCHAR2(10):='0000000000';
begin
insert into T_CARD(FCARDNO,FCARDPASS,FBATCHCODE)
select c_CARDNO,c_CARDPASS,b.FBATCHCODE
from t_CardBatch b
end;竟然在插入的时候出错
如:
declare
c_CARDNO VARCHAR2(20):='00000000000000000000';
c_CARDPASS VARCHAR2(10):='0000000000';
begin
insert into T_CARD(FCARDNO,FCARDPASS,FBATCHCODE)
select c_CARDNO,c_CARDPASS,b.FBATCHCODE
from t_CardBatch b
end;竟然在插入的时候出错
select c_CARDNO,c_CARDPASS,b.FBATCHCODE
from t_CardBatch b
打''或者"",多试试
insert into T_CARD(FCARDNO,FCARDPASS,FBATCHCODE)
select 'c_CARDNO','c_CARDPASS',b.FBATCHCODE
from t_CardBatch b
declare
c_CARDNO VARCHAR2(20):='00000000000000000000';
c_CARDPASS VARCHAR2(10):='0000000000';
begin
insert into T_CARD(FCARDNO,FCARDPASS,FBATCHCODE)
select c_CARDNO,c_CARDPASS,b.FBATCHCODE
from t_CardBatch b;
end;
还有就是你定义的长度不要超过你表中的字段长度