Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP (How to export a table to a delimetered text file)
Unfortunately, there isn't an easy way to export the data to delimited file. But you can do this
select col1 || '^' || col2 || '^' || col3 || '^' || col4 from table_name
Spool the output to a file
Open the file using MS-EXCEL, specify '^' as the delimiter. Excel will
do the rest for you
Regards
N.Prabhakar
Seigmund Akinwande Johnson wrote:
> Help ,
> Does anyone know how to do this ?
Received on Fri May 07 1999 - 02:25:34 CDT
![]() |
![]() |