Re: Utility for extracting table's data into flat file ?

If you want to have the option of treating your textfile almost as a database table I suggest you look att http://www.sqlmover.com in combination with the MS or Intersolv ODBC driver. Any delimiter, WHERE clauses, concatenation, insert missing info, call system functions like date and string functions, transaction control ... Download both the MS ODBC driver and SQLMover from the site and use 1JHHYDOHG as key. Peder Holst, pederh_at_elektrosoft.se

Timo Haatainen <Timo.Haatainen_at_tietogroup.com> wrote in article <34728879.36B5_at_tietogroup.com>...
> Shirley Donor wrote:
> >
> > Is there an Oracle Utility that can dump a table's data
> > into a flat file ?
> >
> > Thank you very much.
> >
> > --
>
> If you want to move table data between Oracle databases you can use
> utility exp (and imp). It dumps data in binary format, I quess.
>
> To make an ASCII file you can try the following:
>
> SQL> set pagesize 200000
> SQL> -- Additional formatting commands here
> SQL> spool myfile.txt
> SQL> select * from mytable;
> SQL> spool off
>
> Now you have file myfile.txt in your working directory.
>
> Hope this helps.
> --
>
> Timo Haatainen
> Carelcomp Forest Oy
>
  Received on Mon Nov 24 1997 - 00:00:00 CST