Even better! On 8/11/05, Magnus Andersen <mag.andersen@xxxxxxxxx> wrote: > > 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 > ! > > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist