declare
v_sql varchar2(1024);
begin
v_sql := 'create global temporary table t_temp_account
(materialID varchar2(7),
start_amount number(5,0),
start_money number(10,2),
in_amount nmuber(5,0),
in_money number(10,2),
out_amount number(5,0),
out_money number(10,2),
finish_amount number(5,0),
finish_money number(10,2)
)on commit preserve rows';
execute immediate v_sql;
end;
执行后 出现错误
declare
*
ERROR 位于第 1 行:
ORA-00907: 缺少右括号
ORA-06512: 在line 15
我的sql语句没有错误的?
------解决方法--------------------------------------------------------
in_amount nmuber(5,0),
改称
in_amount number(5,0),
