批量生成sql并执行

set heading off ; set feedback off ; SPOOL ON.SQL;select 'alter table '||a.Table_Name||' move tablespace FSPTDATA;'from sys.all_tables awhere a.owner = 'FSPT'and a.tablespace_name <> 'FSPTDATA';SPOOL OFF;@ON.SQL;set heading off ; set feedback off ; SPOOL ON.SQL;select 'grant select,insert,delete,update on '||a.Table_Name||' to ptlinkman;' from sys.all_triggers a where a.owner = 'FUSHUN' and a.trigger_name like '%_PT';SPOOL OFF;@ON.SQL;set heading off ; set feedback off ; SPOOL ON.SQL;select dist...