ORA-06550:第17行 17列
PLS-00103:出现符号end 在需要下列之一时:
declare
cursor cur_TableName is
Select * From user_tab_columns where TABLE_NAME like 'SQGL%' and column_name='OID';
begin
for i in cur_TableName loop
-- 打印 删除表数据
--dbms_output.put_line('truncate table '||i.TABLE_NAME||';');
declare
cursor cur_DataType is
Select * From user_tab_columns where table_name=i.TABLE_NAME;
begin
for j in cur_DataType loop
begin
if j.data_type='NVARCHAR2' then
-- alter table i.TABLE_NAME modify(j.column_name varchar2(j.data_length));
end if;
end;
end loop;
end;
end loop;
end;