run1.sql

本人在工程上收集的比较常用的oracle sql语句 有问题请发email:[e-mail]

set colsep |;

set echo off;

set feedback off;

set heading off;

set pagesize 0;

set linesize 1000;

set numwidth 12;

set termout off;

set trimout on; 

set trimspool on;

spool tmp.txt;

	select 'exp dyt/sql@dytsms tables=^' as SAL from dual;
	select TABLE_NAME||',^' as SAL from USER_TABLES where TABLESPACE_NAME is
 				not null and TABLE_NAME<>'CITY';
	select 'city  file=dyt.dmp' from dual;

	select 'pause' from dual;
spool off;

exit