Re: How to export a LONG field to Excel

From: <galen_boyer_at_yahoo.com>
Date: Tue, 22 Jun 2010 20:25:27 -0400
Message-ID: <14qhbkuoars.fsf_at_yahoo.com>

"dn.perl_at_gmail.com" <dn.perl_at_gmail.com> writes:

> 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?

You know, this post really urks me. Its as though its the database's job to somehow make sure excel can handle something.

-- 
Galen Boyer

--- news://freenews.netfront.net/ - complaints: news_at_netfront.net ---

Received on Tue Jun 22 2010 - 19:25:27 CDT