Re: SQLPlus - How to spool without query string? - Another problem.

User Son KwonNam wrote:
> When I tried another query which has alot of result rows,
> it did not have any query string but, it had the following line.
> --------------------------
> 99 rows selected.
> --------------------------
>
> Is it possible to remove that line?
>

SET FEEDBACK OFF --//**

SQL> select * from cat where rownum = 1;

TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
AA                             TABLE

SQL> set feedback on
SQL> /

TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
AA                             TABLE

1 row selected..

SQL> set feedback off
SQL> /

TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
AA                             TABLE

-- 
TomekB tbal_at_go2.pl-l