Re: sqlplus and feedback

From: Tanel Poder <tanel_at_tanelpoder.com>
Date: Fri, 10 Jan 2014 02:09:38 +0200
Message-ID: <CAMHX9J+X0APqsbFBw371Rt9nMZv7Rv0BGKy5gHYznUMK+UNb9Q_at_mail.gmail.com>

Do you want to spool the rows to a file or completely ignore the returned data? If ignore, then just SET AUTOTRACE TRACE STAT and it won't return any data (but will return the row count).

-- 
*Tanel Poder*
Enkitec (The Exadata Experts)
Services <http://enkitec.com> | Training<http://blog.tanelpoder.com/seminar/>
 | Troubleshooting <http://blog.tanelpoder.com/> | Exadata
Book<http://www.amazon.com/Expert-Oracle-Exadata-Apress/dp/1430233923>



On Fri, Jan 10, 2014 at 1:49 AM, De DBA <dedba_at_tpg.com.au> wrote:



> Hi Remigiusz,

>

> If shell commands are acceptable, then you could use something like this

> to redirect the rows feedback to STDERR, while you spool the output to a

> file:

>

> $ sp -s / <<EOF |awk '/rows/ { print $0 > "/dev/stderr" ; } { print $0; }

> ' >/my/output.txt

> > select * from user_objects;

> > exit

> > EOF

> 100 rows selected.

>

>


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

Received on Fri Jan 10 2014 - 01:09:38 CET