Re: How to export to comma delimited file from Oracle8?

From: Xlr82sas <xlr82sas_at_aol.com>
Date: 1997/10/05
Message-ID: <19971005145301.KAA02125_at_ladder01.news.aol.com>#1/1

From memory:

If you have SAS access to Oracle ( and have a profile set up for Oracle)., then you can click on 'File' ( upper left corner), select Oracle, select the table and export the table.

You can export the table in several formats, select comma delimited.

After you have done this, you can recall the code that did the export. Wrap a couple of arguments around it and
call it for the each of the many tables you might want to export. Or youy could put the code in a loop.

Roger J DeAngelis
CompuCraft Inc
XLR82SAS_at_aol.com ( Accelerate to SAS ) http://members.aol.com/xlr82sas/utl.html Received on Sun Oct 05 1997 - 00:00:00 CEST

This message: [ Message body ]
Next message: Pompeyo Castillo: "Re: Error ORA-604/1000"
Previous message: Noodles: "Fetching Long ( > 32 K ) into PL with Oracle 7.1.5 ?"
Maybe in reply to: Matt Connors: "Re: How to export to comma delimited file from Oracle8?"
Next in thread: nwhitehead_at_rocketmail.com: "Re: import/export"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message