sdate date:=sysdate;
或者
sdate date:=to_date('2004-10-10','yyyy-mm-dd');
....
strsql:='INSERT INTO b(fd_dovou_date ) values(sdate)'; <--这里是变量
execute immediate strsql;
或者
sdate date:=to_date('2004-10-10','yyyy-mm-dd');
....
strsql:='INSERT INTO b(fd_dovou_date ) values(sdate)'; <--这里是变量
execute immediate strsql;
sdate date;
begin
...
strsql:='select fd_dovou_date from tb_a where..';
execute immediate strsql into sdate;--fd_dovou_date是date类型的
strsql:=' begin INSERT INTO b(fd_dovou_date ) values ('||sdate||') end;';
execute immediate strsql;<--插入出错,需要to_date()转换吗?....
end;
/
strsql:='select fd_dovou_date into :sdate from tb_a where..;改为把冒号去掉
strsql:='select fd_dovou_date into sdate from tb_a where..;
修改成
....values('''||sdate||''')就可以了