Flat file, non-fixed column dump of SELECT?
From: Mike Accetta <mja_at_cs.cmu.edu>
Date: 25 Oct 1999 03:29:04 GMT
Message-ID: <7v0iq0$g0p$1_at_goldenapple.srv.cs.cmu.edu>
[Quoted] Is there any existing Oracle tool that can be used to dump the columns returned from a select statement into an file formatted as unpadded lines of variable length fields separated by a distinguished character like '|'?
Date: 25 Oct 1999 03:29:04 GMT
Message-ID: <7v0iq0$g0p$1_at_goldenapple.srv.cs.cmu.edu>
[Quoted] Is there any existing Oracle tool that can be used to dump the columns returned from a select statement into an file formatted as unpadded lines of variable length fields separated by a distinguished character like '|'?
SQL Plus comes close with the options indicated in the manual for making a flat file dump, but I can't find anything to stop padding of either the columns or the line to fixed widths. Received on Mon Oct 25 1999 - 05:29:04 CEST