Re: Converting Oracle Tables to an Ascii File.

From: Kedar R. Bhave <kedar_at_emirates.net.ae>
Date: 1998/01/07
Message-ID: <34B3A62F.EB29E39@emirates.net.ae>#1/1

You can do this from SQL*Plus.
Just set Heading off. And set spool to a file (from File menu or say spool c:\temp\...txt at the sql command prompt). Now fire select * from tbl and after it is over, set spool off.
You have your ascii file as c:\temp...
Hope this helps
Kedar

Satar Naghshineh wrote:

> Hi,
> I'm running Ver 7.3.3 and I have a table in which I would like to
> convert to an Ascii file. This table contains customer information and
> we like to make lables out of it. Is there a way of doing this?
>
> Any help is greatly appreciated.
> Satar Naghshineh
> SatarNag_at_worldsite.net
Received on Wed Jan 07 1998 - 00:00:00 CST