Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How can I export table/view to a FIX Length OS File ?
Are you exporting the table or just spooling that table's data? If
spooling, use the spool command, but before you do that, set echo, heading,
verify, and feedback to 'OFF', set pagesize to '0', and set linesize to the
proper width, and possibly set trimspool to 'ON'. In your SQL statement,
use rpad or lpad to right-pad or left-pad the data with spaces to the
correct length.
--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.)
Raymond Du <rdu_at_idmcorp.com> wrote in article
<6jsdbh$jo0_at_nntp02.primenet.com>...
> Solaris 2.6 / ORACLE 7.3.
>
> Thanks very much for help.
>
> Raymond Du
> rdu_at_idmcorp.com
>
>
>
Received on Tue May 19 1998 - 11:58:28 CDT