Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ASCII Data Export

Re: ASCII Data Export

From: Lun Wing San (Oracle) <wslun_at_qrcsun.qrc.org>
Date: 1996/12/20
Message-ID: <32BB885C.7DD9@qrcsun.qrc.org>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US