脚本内容如下
#!/bin/sh
clear
echo "connect Database"
echo "Please Enter UserName ->"|tr -d "\012"
read _USER
echo "Please Enter Password ->"|tr -d "\012"
read _PWD
main()
{
sqlplus -s ${_USER}/${_PWD} << EOF
set trimspool on
set linesize 10000
set pagesize 0
set newpage 1
set heading off
set term off
alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS';
spool /home/oracle/wh/tt.txt;
select PERSON_ID||' '||CLAIM_ID||' '||PERSON_PAY_TYPE||' '||ESTIMATE_AMOUNT||' '||PERSON_PROPERTY||' '||TRAFFIC_TYPE||' '||CHECKER_NAME||' '||CHECKER_CODE||' '||CHECKER_CERTICODE||' '||CHECK_START_TIME||' '||CHECK_END_TIME||' '||CHECK_ADDR||' '||CHECK_DES||' '||CREATE_TIME||' '||UPDATE_TIME from ma_06;
spool off
/
EXIT 3;
EOF
}
main