在begin end语句块中,先执行update 然后执行alter talbe语句报错
aivii 2010-10-16 10:48:50 在begin end语句块中,先执行update 然后执行alter talbe语句报错
如下:
begin
update TableName set FileldName=Value;
alter table TableName Rename column ID to ID_new;
end;
错误如下:
第 3 行出现错误:
ORA-06550: 第 3 行, 第 1 列:
PLS-00103: 出现符号 "ALTER"在需要下列之一时:
begin case declare end
exception exit for goto if loop mod null pragma raise return
select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe