Re: set SQLPLUS output to system

xxsiu_at_uta.edu (Sunny Siu) wrote:

>How can I save the output of a SQLPLUS query to a file in UNIX in
>non-interactive mode? For example:
>
>unix> sqlplus user/passwd _at_myprogram arg1
>
>After running the command on unix, the output will save in a file.
>How can I do it?

  Just add SPOOL command in your 'myprogram.sql'

   For example:

      SPOOL myprogram.log
        ...
      SELECT ....

      SPOOL OFF
      EXIT

Valery

--
SoftService, Moscow
Oracle Corp. Distributor
tel (095) 976-34-78, 976-43-13 
tel/fax (095) 976-01-33