在SQLPLUS中运行
spool c:\trun.sql
select 'truncate table '||table_name||';' from user_tables;
spool off然后再在SQLPLUS中运行c:\trun.sqlSQL> @c:\trun.sql
spool c:\trun.sql
select 'truncate table '||table_name||';' from user_tables;
spool off然后再在SQLPLUS中运行c:\trun.sqlSQL> @c:\trun.sql
SET NEWPAGE 0
SET SPACE 0
SET LINESIZE 80
SET PAGESIZE 0
SET ECHO OFF
SET FEEDBACK OFF
SET HEADING OFF
SET MARKUP HTML OFF SPOOL OFF
什么意思呀