Re: su - oracle -c "script"

I use the -s in my scripts in combo with a here doc.

su - oracle -c $ORACLE_HOME/bin/sqlplus -s <<! / as sysdba
@/apps/oracle/select_user.sql
disconnect
!

-- 
Magnus Andersen
Systems Administrator / Oracle DBA
Walker & Associates, Inc.
--
http://www.freelists.org/webpage/oracle-l