Re: How to extract table contents to files?

In article <3ebhrd$h72_at_ctsc.hkbc.hk>, btsang_at_ctsc.hkbc.hk (Bosco Tsang) writes:
|> How can I extract the content of an oracle 7 table to a text file in the home
|> directory (unix version)?

If you are looking to capture the output of a SELECT statement into a file, you can use the SPOOL command:

	SPOOL filename
	SELECT * FROM tablename;
	SPOOL off;

If you are looking to dump the table contents to an ASCII file, read up on Oracle's data loader. Hope this helps.

                                Teresa Larson

+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+
| Teresa A. Larson - Hughes STX Corporation                            |
| NASA/GSFC Code 933.0                        voice:  (301) 286-7867   |
| Greenbelt, Maryland  20771                  fax:    (301) 286-1777   |
| Teresa.Larson_at_gsfc.nasa.gov                                          |
+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+
			Standard disclaimer ...