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

Home -> Community -> Usenet -> c.d.o.server -> Is there a way I can direct a output of select statement (in a stored procedure) into a file?

Is there a way I can direct a output of select statement (in a stored procedure) into a file?

From: <pcmwong_at_my-deja.com>
Date: Thu, 02 Sep 1999 23:38:31 GMT
Message-ID: <7qn1pm$b6j$1@nnrp1.deja.com> 





Hi All,



Is there a way I can direct a output of  select statement (in a stored
procedure) into a file?



I know I can use spool command to direct the output into a file under
SQL Plus or SQL Plus Worksheet.



How about in a stored procedure of a database?



Please help.



Thanks a lot for your input.



Yours Truly,



Paul




Sent via Deja.com http://www.deja.com/



Share what you know. Learn what you don't.
Received on Thu Sep 02 1999 - 18:38:31 CDT












Original text of this message













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