Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie Question regarding Exporting to a Tab Delimited File
The easiest way is to do simple SQL selects, concatenated with the relevant delimiter, and spool the output. For example:
set head off termout off verify off feedback off echo off pagesize 0
spool tablist.txt
select empno || chr(9) || ename || chr(9) ||job || chr(9) || mgr || chr(9)
|| hiredate from scott.emp;
spool off
Regards
HJR
"MLynn" <mlynn_at_ml.com> wrote in message news:9dbh1a$6d7$1_at_news.ml.com...
> Pardon my inexperience.
>
> I am not an Oracle user and I am attempting to get my database provider to
> give me a dump of my database so that I can import it into a database
other
> than Oracle.
>
> I received a binary file - but ideally, I would like to receive a tab
> delimited dump of the data.
>
> Can someone tell me what the best way to dump a table to tab delimited
> format would be?
>
> Thanks in advance for whatever assistance you can provide.
>
> Mike
>
>
Received on Wed May 09 2001 - 20:02:11 CDT