Re: newbie:exporting data?

From: Nemniss <Nemniss_at_hotmail.com>
Date: Fri, 22 Jan 1999 09:41:43 +0200
Message-ID: <7899vt$4tl$1@hermes.is.co.za>

You can also try the following:

Let say table TBL_A looks like this:

            create table TBL_A
            (
                CField_A        Varchar(10),
                NField_A        Number(10)
            );

--------o0o---------
-- SQL script

Set Heading Off
Set Feedback Off
Set Pagesize 5000
Spool Export_File

Select '~'||CField_A||'~'||NField_A||'~'|| From TBL_A;

Spool Off

You can substitute the ~ for any unusual character, this will be your delimiter.

Lets say the data in TBL_A looked like this:

CField_A NField_A
------------- --------------

Jones            10
Newman        20

...
etc.

your out put of the Export_File will look something like this:

~Jones~10~
~Newman~20~

Hope this will help!

Nemniss

Gjlinker wrote in message <19990121180501.10468.00000322_at_ngol05.aol.com>...
>
>Hi Anjo,
>
>Why not do this via Excel. When you have the data in Excel you can do with
it
>whatever you want.
>
>You can fetch data into Excel using my Oraxcel utility. Please have a look
at
>it on
>
>http://members.aol.com/gjlinker
>
>Regards, Gerrit-Jan Linker
>Developer of Oraxcel, OraSQL, OraCodes and OraWeb
>http://members.aol.com/gjlinker
>
>In article <369b212e.0_at_wau.nl>, anjo de Jong <"anjo.dejong"@users_at_whh.wau>
>writes:
>
>>
>>I 've been looking for a way to export data from oracle to e.g.
>>dbase-format or ascii. I've tried the unload data command but sql gives
>>a 'unknown command' message? What is the regular way to export tables?
>>
>>Anjo de Jong
>>
>
>
Received on Fri Jan 22 1999 - 01:41:43 CST