Re: Display shell script output

  • From: "Limin Guo" <lguo.oracle@xxxxxxxxx>
  • To: ranko.mosic@xxxxxxxxx
  • Date: Mon, 17 Jul 2006 16:35:11 -0400

If you want to see the command executed, try this

output=`sqlplus -s system/password<<EOF <system/password@%3C%3CEOF>
set echo on
set termout on
set feedback on
Create user test identified by  test
default tablespace rcvcat_tbs
quota 0 on system;
exit;
EOF`
echo $output

Hope this helps.

Limin.

On 7/14/06, Ranko Mosic <ranko.mosic@xxxxxxxxx> wrote:

Hi List, I need to be able to see commands executed on the sceen - they are not echoed now: #!/bin/ksh sqlplus system/password<<EOF <system/password@%3C%3CEOF> set echo on set termout on set feedback on Create user test identified by test default tablespace rcvcat_tbs quota 0 on system; exit; EOF


-- Regards, Ranko Mosic Contract Senior Oracle DBA B. Eng, Oracle 10g, 9i Certified Database Professional Phone: 416-450-2785 email: mosicr@xxxxxxxxxx

http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARankoMosicMain.html





-- Regards,

Limin Guo.

Other related posts: