Re: sqlplus and feedback
- From: Tanel Poder <tanel@xxxxxxxxxxxxxx>
- To: dedba@xxxxxxxxxx
- Date: Fri, 10 Jan 2014 02:09:38 +0200
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@xxxxxxxxxx> 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.
>
>
Other related posts:
