Quote Originally Posted by pkjha View Post
It is desired that
sqlplus -s uname @script
should prompt like 'Enter passwd : ..'
Currently it waits silently for passwd without any promt.
In earlier verssion it was prompting ..
if you do "sqlplus -s '/as sysdba'" it should start up a sqlplus connection and not prompt for anything or send any extraneous output to the screen. this can be useful in the following case using bash:

Code:
export MYVAL=`sqlplus -s '/as sysdba' << EOF
set term off
set echo off
set feedback off
set heading off
set term on
select status from v\$instance;
EOF`
This will put the status of the database into an environment variable in bash. However, 8.1.7 had a bug where it would let you know that you were connected even though you asked it to not do that.

You can also do this:

Code:
sqlplus -s /nolog << EOF
connect user/pass
...
EOF