oracle 9i

[divya chamarti]

Please tell me the mechanisms in oracle 9i to export the content of table in txt or csv format.

[atish chachan]

hi,

To export the contents of a table you can use the SPOOL command.

> spool d:\abc.txt
> select * from table_name;
> spool off

This will export the contents of the table to a text file named abc.txt in the D drive.

cheers!

[divya chamarti]

Thanks atish chachan!!!