Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Exporting Relationships to CSV file

Exporting Relationships to CSV file

From: * ~~~~~~ Nic ~~~~~~ * <memnochtd_at_geocities.com>
Date: Fri, 15 Oct 1999 10:55:51 +0100
Message-ID: <3806FA27.3D45DFD8@geocities.com>


I saw on a previous posting that you can export a table to a CSV using the code:

SQL> spool temp
SQL> select c1||','||c2||','||c3 from table1;
SQL> SPOOL OFF

which will export to the file temp.lst

Firstly, can I assume that I can use the select statement:

        SELECT * from table1;

to produce the same result or do I need something more elaborate and also how can I export table relationships to a CSV file?

--

*************************************************************** --

Bide by the Wiccan Law ye must, In perfect love and perfect trust.

Eight words the Wiccan Rede fulfill: An' harm ye none, do what ye will.

What ye sends forth comes back to thee. So ever mind the law of three.

Follow this with mind and heart, Merry ye meet, and merry ye part..

Nic Received on Fri Oct 15 1999 - 04:55:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US