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: Robert Klemme <shortcutter_at_googlemail.com>
Date: Fri, 08 Sep 2006 16:20:36 +0200
Message-ID: <4mdchkF5i3jgU1@individual.net> 





On 08.09.2006 16:13, zrwcvhsosoik001_at_sneakemail.com wrote:


> Well, the example is hypothetical of course. But UTL_FILE will not

> work, because I need the output on the client. We have no access to the

> server filesystem.




You could invoke SQL Plus from some form of script (shell, ruby, perl, 
python...), parse the output and create those files from the script.



Kind regards



        robert
Received on Fri Sep 08 2006 - 09:20:36 CDT












Original text of this message













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