Re: Creating an ASCII file from an Oracle table

From: Cleve Sharpe <cleve_at_cbcsf.org>
Date: 1997/11/25
Message-ID: <65en8p$arv@news.boca.net>#1/1

RobW95 wrote in message <19971120171400.MAA00528_at_ladder01.news.aol.com>...
>My new company has asked me to create a flat file from an Oracle table
(don't
>ask me why). I don't recall any easy way to do this, such as a utility.
Does
>anybody have any suggestions? Thanks. Rob

I am not sure if this is the solution you were looking for, but you can do it simply from SQL-PLUS using the following:

    SPOOL FLATFILE.TXT
    SELECT * FROM THE_ORACLE_TABLE
    SPOOL OFF That's the easiest way.

Cleve Received on Tue Nov 25 1997 - 00:00:00 CST