Re: Fast output of SQL statement to file SQL Plus

On Wed, 13 Jun 2007 10:46:14 -0700, Mensur <mmedic123_at_gmail.com> wrote:

>Is there a way to quickly output large number of rows from a SQL
>statement to a file through SQL plus. I tried using spool but that is
>slow. Is there another way? I am using Oracle 10g.
>
>Thanks!

Put the sql in a file, the spool command prior to the select, and you won't have to scroll your output over the screen.

-- 
Sybrand Bakker
Senior Oracle DBA