Re: Exporting Data?

From: Dave <none_at_nowhere.nothere.oops>
Date: Wed, 17 Nov 1999 14:16:56 -0000
Message-ID: <80uddf$fon$1@lure.pipex.net>

This works but will this still display all the data to the screen.
If it displays the data, it will take about 10 times as long to run.

Dave

Martin Zierke <zierke_at_ccschaper.de> wrote in message news:3832a3e8.19618920_at_news.mgi.de...
> On Wed, 17 Nov 1999 11:27:01 -0000, "Dave" <none_at_nowhere.nothere.oops>
> wrote:
>
> - SQL*Plus:
> ------------
>
> - set heading off
> - set pagesize 0
> - set linesize <what you need>
> - <set the buffer size>
> - spool <file>
>
> -select <column> from <table>;
>
> - ready
>
> Martin
>
> >I have a table of 43,000,000 rows. I need
> >to export one of the columns from the table
> >to a line sequential flat file.
> >What is the easiest way to do this?
> >
> >
> >Dave
>
Received on Wed Nov 17 1999 - 08:16:56 CST