#!/bin/shUSER= PWD= TNS= TABLE=sqlplus -s $USER/$PWD@$TNS << EOF > /dev/null 2>&1 set time off; set echo off; set head off; set wrap off; set linesize 10000; set pagesize 0; set trims on; set feedback off; spool /home/user/test.txt; select * from ${table}; spool off; exit; EOF done
先写一个SQL脚本,如sqlloadout.sqlset termout off set heading off set feedback off set linesize 1000 set pagesize 0 spool employees.csv select * from employees; spool off exit然后写一个shell脚本,如sqlloadout.shsqlplus hr/oracle @sqlloadout.sql最后运行shell脚本 sh sqlloadout.sh
是啊 要求是写shell脚本的
PWD=
TNS=
TABLE=sqlplus -s $USER/$PWD@$TNS << EOF > /dev/null 2>&1
set time off;
set echo off;
set head off;
set wrap off;
set linesize 10000;
set pagesize 0;
set trims on;
set feedback off;
spool /home/user/test.txt;
select * from ${table};
spool off;
exit;
EOF
done
set heading off
set feedback off
set linesize 1000
set pagesize 0
spool employees.csv
select * from employees;
spool off
exit然后写一个shell脚本,如sqlloadout.shsqlplus hr/oracle @sqlloadout.sql最后运行shell脚本
sh sqlloadout.sh