sql command for exporting data to ascii file

From: Stefan den Engelsman <Stefan.denEngelsman_at_nl.origin-it.com>
Date: Tue, 26 Jan 1999 01:21:13 +0100
Message-ID: <0E16861EE7BCD111BE9400805FE6841F068DF428@c1s5x001.cor.srvfarm.origin-it.com>

Hello,

Can anyone tell me if oracle does have a sql command which exports the contents of a table to an ascii file :

for example :

copy table test
(
field1 colon,
field2 colon,
field3 nl
)
into 'file';

would result into :

file :

---

value1:value2:value3
value1:value2:value3
etc.

Thanks in advance Received on Mon Jan 25 1999 - 18:21:13 CST