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: SQL*Plus: How can I write each record to a separate file

Re: SQL*Plus: How can I write each record to a separate file

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 8 Sep 2006 13:15:11 -0700
Message-ID: <1157746511.570641.223990@i3g2000cwc.googlegroups.com>


I started writing out an example, but there are too many options depending on how you want to deliver this. If you have a specific question then someone can answer it.
It goes from setting up environment variables in SQL Plus (ex: define slash = "/")
to the solution Sybrand Bakker suggested (exp rows=n).

Sorry to be so vague, but a cool approach in one situation can lead to bad practise that is hard to maintain in another delivery model. Received on Fri Sep 08 2006 - 15:15:11 CDT

Original text of this message

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