declare
-- user_tab_columns 当前用户 的表结构
cursor c_job is
select table_name from user_tab_columns where column_name not in ( 'INO') and column_name not like '%$%' group by table_name;
--定义一个游标变量
c_row c_job%rowtype;
dsql varchar2(2000);
begin
-- 解除 DBMS_OUTPUT 的输出字符限制
DBMS_OUTPUT.ENABLE(buffer_size => null);
for c_row in c_job loop
dbms_output.put_line(' alter table '||c_row.table_name||' add ino int;');
end loop;
end;
转载于:https://my.oschina.net/wxh1989/blog/872358