On Wed, May 20, 2009 at 4:35 PM, ashok abraham <[email protected]> wrote:
>
>
>
> Dear all
>
> How to redirect oracle sql query output to a text file
> instead to console

SQL> spool /tmp/output.txt
SQL> select instance_name, status from v$instance;
SQL> spool off
SQL> exit
$ cat /tmp/ouput.txt

Regards,
NMK

Reply via email to