Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to eliminate "Input truncated..." msg
miker <mdent12_at_none.com> wrote in message news:<9njc7uor6fka84uq3lrnkqbnv09d4thcd5_at_4ax.com>...
> Is there any way to get rid of "Input truncated to xx characters" and
> "xx rows selected." msg? tia.
You can use:
set echo off
set termout off
set feedback off
spool logfile.log
select * from table;
spool off
exit
and use the sqlplus silent option as in sqlplus -s user/pw @script.sql Received on Fri Feb 22 2002 - 11:29:12 CST