Oracle SPOOL小结 (转)

Oracle SPOOL总结 (转)
?

#!/bin/kshDB_USER=tivan #DB USERDB_PWD=tivan #DB PASSWORDDB_SERV=orcl #DB SERVICE NAMEreturnMessage=`sqlplus -s $DB_USER/$DB_PWD@$DB_SERV<<EOFwhenever sqlerror exit 1whenever oserror exit 2set pagesize 0 feedback off verify off heading offset time off echo offset pagesize 0set linesize 2000set trims onset feedback offset TERMOUT OFFalter session set nls_date_format='YYYY-MM-DD HH24:MI:SS';spool sp_test.txtselect PK_ID || '|' ||GRID_ID || '...' from tmp_jy_sys_table_col;spool off/exit 3;EOF`

?

-EOF-