Re: Converting Oracle Tables to an Ascii File.

The best way to do this, IMHO, is to use a good report writer i.e. Crystal Reports Pro or even Access ( with a link to the Oracle stuff via ODBC )

The report writer can either export the data ( in multiple formats ) or create a label format report for your type of label ( assuming a somewhat standard Avery-type label ).

This is much easier than spooling sql output due to the intricacies of formatting involved ( one again, the opinion of a lazy person) - the cost will be paid back in time saved.

John Greco
Oracle DBA
Reply to: john.greco_at_dot.state.mn.us

Satar Naghshineh <satarnag_at_worldsite.com> 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 Fri Nov 07 1997 - 00:00:00 CST