Re: Exporting Data?

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 - 06:51:46 CST