sqlplus -s $username/$password@$server <<! SPOOL $filename CLEAR COLUMNS CLEAR BREAKS CLEAR COMPUTES SET NEWPAGE 0 SET SPACE 0 SET LINESIZE 80 SET PAGESIZE 0 SET ECHO OFF SET FEEDBACK OFF SET HEADING OFF SET MARKUP HTML OFFselect a,b,c from user_table;SPOOL OFF quit !
只能在服务器的这个路径下生成该文件
客户端不能生成!!
SPOOL $filename
CLEAR COLUMNS
CLEAR BREAKS
CLEAR COMPUTES
SET NEWPAGE 0
SET SPACE 0
SET LINESIZE 80
SET PAGESIZE 0
SET ECHO OFF
SET FEEDBACK OFF
SET HEADING OFF
SET MARKUP HTML OFFselect a,b,c from user_table;SPOOL OFF
quit
!