如何在操作系统命令行上执行sql

1. 执行来自输入的sql

[oracle@Oracle10g ~]$ cat .fsql.sh 
#!/bin/ksh


This_PWD=`pwd`

Username="hr"
Passwd="hr"

CONN_STR="$Username/$Passwd"
cd ${This_PWD}

if [ $# -ne 1 ]
then
{
        echo "Usage:"
        echo "$0 \"The sql string\""
        echo ""
        exit 101
}
fi
if [ ! -f ${1} ]
then
{
        echo "The sql-file "${1}" is not exist!"
        exit 102
}
fi

#The_SqlStrtmp=`cat ${1}`
cat ${1}|while read The_SqlStrtmp
do
  sSql=`eval "echo \"$The_SqlStrtmp\" "`
done

The_SqlStr=$sSql

The_day=`date "+%Y%m%d"`
The_resulttxt=`sqlplus $CONN_STR <<EOF
set sqlnumber off;
set autocommit on;
--set pagesize 0
set heading off;
set linesize 2500;
set long 4000;
$The_SqlStr
;
quit;
EOF
` 2>&1
echo "$The_resulttxt" | sed "/^$/d;/Release 10.2.0.1.0/d;/Copyright (c)/d;/Connected to/d;/Partitioning, OLAP/d;/SQL/d;/rows selected/d"
[oracle@Oracle10g ~]$ cat ./sh01/tmp.sql 
select t.employee_id, t.first_name, t.email from hr.employees t where t.employee_id in (198, 199, 200)
[oracle@Oracle10g ~]$ fsql ./sh01/tmp.sql 
        198 Donald               DOCONNEL
        199 Douglas              DGRANT
        200 Jennifer             JWHALEN
[oracle@Oracle10g ~]$ fsql ./sh01/tmp.sqqqq
The sql-file ./sh01/tmp.sqqqq is not exist!
[oracle@Oracle10g ~]$ 

2. 执行来自文件的sql

[oracle@Oracle10g ~]$ cat .fsql.sh 
#!/bin/ksh


This_PWD=`pwd`

Username="hr"
Passwd="hr"

CONN_STR="$Username/$Passwd"
cd ${This_PWD}

if [ $# -ne 1 ]
then
{
        echo "Usage:"
        echo "$0 \"The sql string\""
        echo ""
        exit 101
}
fi
if [ ! -f ${1} ]
then
{
        echo "The sql-file "${1}" is not exist!"
        exit 102
}
fi

#The_SqlStrtmp=`cat ${1}`
cat ${1}|while read The_SqlStrtmp
do
  sSql=`eval "echo \"$The_SqlStrtmp\" "`
done

The_SqlStr=$sSql

The_day=`date "+%Y%m%d"`
The_resulttxt=`sqlplus $CONN_STR <<EOF
set sqlnumber off;
set autocommit on;
--set pagesize 0
set heading off;
set linesize 2500;
set long 4000;
$The_SqlStr
;
quit;
EOF
` 2>&1
echo "$The_resulttxt" | sed "/^$/d;/Release 10.2.0.1.0/d;/Copyright (c)/d;/Connected to/d;/Partitioning, OLAP/d;/SQL/d;/rows selected/d"
[oracle@Oracle10g ~]$ cat ./sh01/tmp.sql 
select t.employee_id, t.first_name, t.email from hr.employees t where t.employee_id in (198, 199, 200)
[oracle@Oracle10g ~]$ fsql ./sh01/tmp.sql 
        198 Donald               DOCONNEL
        199 Douglas              DGRANT
        200 Jennifer             JWHALEN
[oracle@Oracle10g ~]$ fsql ./sh01/tmp.sqqqq
The sql-file ./sh01/tmp.sqqqq is not exist!
[oracle@Oracle10g ~]$