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

执行一条命令
echo 'select member from v$logfile;' | su - oracle -c "sqlplus / as sysdba"

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

执行两条命令
echo -e 'select member from v$logfile;\n select member from v$logfile;' | su - oracle -c "sqlplus / as sysdba"

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

执行多条命令
su - oracle -c "sqlplus / as sysdba" <<EOF select member from v$logfile; select member from v$logfile; select member from v$logfile; EOF

|-----------|--------------------------------------------------------------------------------------------------------------------------------------------| | 1 2 3 4 5 | su - oracle -c "sqlplus / as sysdba" <<EOF select member from v$logfile; select member from v$logfile; select member from v$logfile; EOF |