Execute immediate 晕透了:(

[AechoJohn]

在WorkSheet 中执行下面的语句：

set serveroutput on ;

declare v_dat date ;

begin

select sysdate into v_dat from dual ;
dbms_output.put_line(to_char(v_dat ,'yyyy/mm/dd')) ;

EXECUTE IMMEDIATE 'select sysdate into v_dat from dual' ;

end ;

结果：

2005/09/07
declare v_dat date ;
*
ERROR 位于第 1 行:
ORA-00905: 缺少关键字
ORA-06512: 在line 8
EXECUTE IMMEDIATE 'select sysdate into v_dat from dual' ;就是第8行？？？

[wfeng7907]

改为
EXECUTE IMMEDIATE 'select sysdate from dual' into v_dat ;