使用oracle用户非交互式执行sql命令

On By 去哪儿

1、执行一条命令

echo 'select member from v$logfile;' | su - oracle -c "sqlplus / as sysdba"

2、执行两条命令

echo -e 'select member from v$logfile;\n select member from v$logfile;' | su - oracle -c "sqlplus / as sysdba"

3、执行多条命令

su - oracle -c "sqlplus / as sysdba" <<EOF
> select member from v\$logfile;
> select member from v\$logfile;
> EOF
编写成脚本
sh sql.sh >> log.txt