Re: how to supress the query display in SQL-PLUS

Hi !

Just put your request in a my.sql file like that :

  set termout off
  spool my_result
  select ...
  spool off

And then, in SQL*Plus, type :
start my.sql
or
@my

That's all !
Pierre

Parvinder Arora a écrit :

> Hi all
>
> I want to supress the result of a query which i am running in
> SQL-PLUS. how can i do that ?
> set spool doesn't suppresses the result. It shows the result on the
> screen as well as it also puts the result into the database.
> Can i achieve this ???
>
> Thanks & Regards
> ~Parvinder
Received on Thu Feb 03 2000 - 06:19:39 CST