Re: Display shell script output

> I need to be able to see commands executed on the sceen - they are not
> echoed now:

Shell or sqlplus commands?

For shell use

#!/bin/ksh -v (to print shell input lines as they are read or -x if you need to print the commands and their arguments, or -xv for both)

For sqlplus:

From SQL*Plus User's Guide and Reference:

SET ECHO {ON | OFF}
Controls whether or not to echo commands in a script that is executed with @, @@ or START. ON displays the commands on screen. OFF suppresses the display. ECHO does not affect the display of commands you enter interactively or redirect to SQL*Plus from the operating system.

So you could:

1. Write a sql sqlript and then run it in the shell script as @script.
2. Prompt the commands:

#!/bin/ksh
sqlplus system/password<< EOF
set echo on
set termout on
set feedback on
prompt Create user test1 identified by test prompt default tablespace rcvcat_tbs
prompt duota 0 on system;
Create user test1 identified by test
default tablespace users
quota 0 on system;
exit;
EOF Dimitre

--
http://www.freelists.org/webpage/oracle-l