Re: newbie:exporting data?

From: Jerry Gitomer <jgitomer_at_ictgroup.com>
Date: Tue, 12 Jan 1999 14:20:39 -0500
Message-ID: <77g789$sqs$1@client2.news.psi.net>

Hi Bruno,

Welcome to the wonderful world of Oracle!

The quick way to do what you want is:

    SET COLSEP = '|'
    SPOOL <filename.ext>
    SELECT * FROM <table_name>;
    SPOOL OFF
    SET COLSEP = ' ' This will give you an ASCII file with the fields separated by the pipe symbol '|'. If you can live with a space as the column separator just omit the two SET COLSEP statements. Oh, by the way the output will be in the directory you were in when you invoked Oracle (in the case of a PC look in C:/ORAWIN95/BIN -- or wherever your Oracle executables live)

regards

Jerry

Bruno S Fernandes wrote in message <77frao$jd6$1_at_pthp35.telecom.pt>...
>anjo de Jong <"anjo.dejong"@users_at_whh.wau> wrote in message
><369b212e.0_at_wau.nl>...
>>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
>>
>
>Try ImportExport32 from Benthic Software.
>You can find it on the URL: http://www.tiac.net/users/markford/index.htm
>
>Regards,
> Bruno S. Fernandes
>
>
Received on Tue Jan 12 1999 - 13:20:39 CST