Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Fast output of SQL statement to file SQL Plus
On Jun 13, 7:40 pm, sybra..._at_hccnet.nl wrote:
> On Wed, 13 Jun 2007 10:46:14 -0700, Mensur <mmedic..._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
Also worth setting TERM OFF, TRIM ON and ARRAYSIZE to a hundred or so. I've always found it very fast. Received on Wed Jun 13 2007 - 17:19:57 CDT