spool c:\aaaa.sql select 'drop table '||tname||';' from tab; spool off @c:\aaaa.sql
按如下序列执行命令 1、sql>set linesize 80 sql>set pagesize 0 sql>set feedback off 2、sql>spool drop_table.sql sql>select 'drop table '||tname from tab||';'; sql>spool off 3、查看一下drop_table.sql,删除drop语句的其它行。 4、sql>@drop_table.sql一切便Ok了!
按如下序列执行命令 1、sql>set linesize 80 sql>set pagesize 0 sql>set feedback off 2、sql>spool drop_table.sql sql>select 'drop table '||tname from tab||';'; sql>spool off 3、查看一下drop_table.sql,删除drop语句的其它行。 4、sql>@drop_table.sql一切便Ok了!
the above methods are clever!
create procedure p_del is declare cursor c_del is select 'drop table '||tname||';' from tab ; begin open ...; for .. execute ... next end; /
create procedure p_del is declare ls_sql varchar2 ; cursor c_del is select 'drop table '||tname||';' from tab ; begin open ...; fetch ...; for .. execute ...; fetch ...; next end; /execute p_del;
create procedure sp_drop_table is v_sql varchar2(2); cursor c1 is select 'drop table '||tname||' ;'||from tab; begin open c1; loop fetch c1 into v_sql; exit when c1%notfound; execute v_sql; end loop; close c1; end; /execute sp_drop_table;
select 'drop table '||tname||';' from tab;
spool off
@c:\aaaa.sql
1、sql>set linesize 80
sql>set pagesize 0
sql>set feedback off
2、sql>spool drop_table.sql
sql>select 'drop table '||tname from tab||';';
sql>spool off
3、查看一下drop_table.sql,删除drop语句的其它行。
4、sql>@drop_table.sql一切便Ok了!
1、sql>set linesize 80
sql>set pagesize 0
sql>set feedback off
2、sql>spool drop_table.sql
sql>select 'drop table '||tname from tab||';';
sql>spool off
3、查看一下drop_table.sql,删除drop语句的其它行。
4、sql>@drop_table.sql一切便Ok了!
declare
cursor c_del is select 'drop table '||tname||';' from tab ;
begin
open ...;
for ..
execute ...
next
end;
/
declare
ls_sql varchar2 ;
cursor c_del is select 'drop table '||tname||';' from tab ;
begin
open ...;
fetch ...;
for ..
execute ...;
fetch ...;
next
end;
/execute p_del;
v_sql varchar2(2);
cursor c1 is select 'drop table '||tname||' ;'||from tab;
begin
open c1;
loop
fetch c1 into v_sql;
exit when c1%notfound;
execute v_sql;
end loop;
close c1;
end;
/execute sp_drop_table;