| 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)27885841
Received on Fri Dec 20 1996 - 00:00:00 CST
![]() |
![]() |