Re: Exporting Relationships to CSV file

No, it would be an invalid assumption.

Instead use:

SQL> SET COLSEP ','
SQL> spool temp
SQL> SELECT * from table1;
SQL> SPOOL OFF
SQL> SET COLSEP ' '

regards
jerry gitomer

• ~~~~~~ Nic ~~~~~~ * wrote in message <3806FA27.3D45DFD8_at_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