Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ASCII Data Export
Brenda Muller wrote:
> I just need to export some data from an Oracle DB into a flat file,
> delimited by something or other (doesn't really matter). What's the
> *best* way to do this (easiest, quickest)?
Spool the output by using SQL*Plus such as select column1||','||column2 ... from tblname;
--- Name : Lun Wing San Title : Oracle Application Developer of Hong Kong Productivity Council Oracle Database Administrator and System Administrator of QRC Phone : (852)27885841Received on Fri Dec 20 1996 - 00:00:00 CST