Re: Unload table into filesystem

Yes,

Just do the following from either the SQL*Plus prompt or from a script file:

   SET PAGES 0                                        -- Eliminate page
breaks in output file
   SET COLSEP '|'                                   -- Set column separator
character to the pipe symbol
   SPOOL <output file>                           --  Give Oracle the name of
the output file
   SET FEEDBACK OFF                         --  Kill the terminal output
   SET TERMOUT OFF
   SELECT * FROM <tablename>;       --  Build it
   SPOOL OFF                                          --  Close the spool
file so you can access it
   SET COLSEP ' '                                    --  Change column
separator back to space
   SET PAGES 24                                     -- Set the page size to
24 lines
   SET FEEDBACK ON                            -- Restore feedback
   SET TERMOUT ON                              -- Turn terminal output back

regards

Jerry

wkuhn_at_inforatio.de wrote in message <36a44607.1299380_at_news.idnet.de>...
>Is there a possibility to unload one or more Oracle-tables to the
>filesystem, in an 'Informix-like' manner, that is convert all binary
>fileds into ascii ?
>
>Regards
>
>Wolfgang Kuhn
>Inforatio GmbH
>www.inforatio.de
Received on Tue Jan 19 1999 - 14:24:36 CST