Re: How to export a LONG field to Excel

From: Frank van Bortel <fbortel_at_home.nl>
Date: Mon, 21 Jun 2010 20:37:25 +0200
Message-ID: <7e139$4c1fb165$524ba3af$711_at_cache6.tilbu1.nb.home.nl>

On 06/18/2010 07:49 AM, dn.perl_at_gmail.com wrote:
> I use Oracle SQL Developer, ver 2.1, to access an Oracle 10g server. I
> would like to export a LONG field into an excel sheet. Sometimes it
> works, sometimes not, and I have not been able to find out the
> boundary beyond which it fails. I can export it into a csv file and
> then open it an an excel file, but the LONG field contains several
> tabs and several commas within it. And formatting that data correctly
> so that excel organizes it the way I want (correct field in correct
> column) is proving a bit tiresome.
>
> Can Oracle SQL Developer or TOAD be configured to read (say) 2,000
> characters of a LONG field, truncate the rest, and reliably export
> this data (with a limit of characters in a LONG field) into an Excel
> sheet?
>
> Please advise; thanks in advance.
>

Learn about the darn thing:
1) Long has been deprecated since 8.0
2) Use SQL*Plus "Set long xxx" command

Documentation could always be found on
tahiti.oracle.com, which you would have known had you done any research. And by that I mean use your favourite search engine.

-- 

Regards,

Frank van Bortel

Received on Mon Jun 21 2010 - 13:37:25 CDT