> 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
