Re: Why doesn't output display SQL statement when using sqlplus in bash script?
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Tue, 8 Mar 2016 12:57:58 +0300
Message-ID: <CAOVevU5co+vx9m-e70iVYU9E2Nz+tnv=BCQOwODsZc6Q_JkswQ_at_mail.gmail.com>
Hi,
Date: Tue, 8 Mar 2016 12:57:58 +0300
Message-ID: <CAOVevU5co+vx9m-e70iVYU9E2Nz+tnv=BCQOwODsZc6Q_JkswQ_at_mail.gmail.com>
Hi,
just use temporary sql file:
#!/bin/bash
cat <<EOF > inputscript.sql && sqlplus / as sysdba _at_inputscript.sql
set echo on feed on termout on;
select group#,members,bytes/1024/1024,status from v\$log;
exit;
EOF
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 08 2016 - 10:57:58 CET