declare
v_Count integer;
begin
select count(*) into v_Count from user_tab_cols where table_name='OC_ACCOUNTINFO' and column_name='JOBNUMBER';
if v_Count=0 then
alter table OC_AccountInfo add (JobNumber varchar2(32))
end if
end;
出现如下问题。不应该吧
ORA-06550: 第 6 行, 第 5 列:
PLS-00103: 出现符号 "ALTER"在需要下列之一时：
( begin case declare exit
for goto if loop mod null pragma raise return select update
while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
continue close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe purge
看到有人说是 中文空格或者字符串的原因，。都试过了不行。