Re: Data extraction

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Tue, 19 Oct 1999 12:39:38 -0400
Message-ID: <7ui769$604$1@autumn.news.rcn.net>

    SET PAGES 0
    SET FEEDBACK OFF
    SET COLSEP ' ' (put a tab between the single quotes)

    SPOOL <filename>
    SELECT * FROM <table_name>;
    SPOOL OFF hth
jerry gitomer

Nick wrote in message <380BAC98.626C89CD_at_mailcity.com>...
>Hi,
>
>Im wondering if there is a way to extract data from an Oracle
database,
>in tab delimited .dat files. I know this can be done via an odbc
>connection with Access and then 'save as' but we have over a
hundred
>tables. Thanks,
>
>-Nick
>
>
Received on Tue Oct 19 1999 - 11:39:38 CDT