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 -> Re: How to copy a table into a file in specific format

Re: How to copy a table into a file in specific format

From: John Durst <jdurst_at_sky.net>
Date: Tue, 29 Sep 1998 22:50:42 -0500
Message-ID: <3611AA91.C0ABF5CC@sky.net> 





Try running this in SQL*Plus:



set pages 0 head off feed off colsep |


spool unix.file


select * from entire_table;


spool off



badstreetboy_at_my-dejanews.com wrote:



> I want to copy the entire table into a unix file in this format:


> f1|f2|f3


> ...


> How to do that?  Thanks!


>


> -----== Posted via Deja News, The Leader in Internet Discussion ==-----


> http://www.dejanews.com/rg_mkgrp.xp   Create Your Own Free Member Forum





Received on Tue Sep 29 1998 - 22:50:42 CDT












Original text of this message













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