Re: HELP (How to export a table to a delimetered text file)

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Tue, 27 Apr 1999 09:36:25 -0400
Message-ID: <7g4ec8$1o1$1@autumn.news.rcn.net>

Hi,

try this:

    set pages 0
    set echo off
    set feedback off
    set colsep '|'
    spool <outputfile_name>
    select * from <table_name>;
    spool off

The key is the colsep character. Set it to anything you like.

regards

Jerry Gitomer

---

---

Seigmund Akinwande Johnson wrote in message ...
>Help ,
>Does anyone know how to do this ?
>
>
Received on Tue Apr 27 1999 - 08:36:25 CDT