Running sqlplus From Shell

sqlplus的基本用法：

sqlplus {username[/password][@connect_identifier] | /}
     [AS {SYSOPER|SYSDBA|SYSASM}] [edition=value]

例如文件叫test.sh
内容如下：

sqlplus aaa/abcde@ABC <<EOF
select price from book where price < 3;
commit;
exit;
EOF

用户名：aaa
密码：abcde
connect_identifier：ABC

 

有些时候会在sqlplus后面加上 -s 选项，代表：

"-s" stands for silent mode - it means you don't get any terminal output. It is useful for running SQL*Plus as part of a script where you don't want the user to see lots of stuff appearing on the screen.