Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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