Exporting Relationships to CSV file

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