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.

On 06/18/2010 07:49 AM, dn.perl (AT) gmail (DOT) com wrote:
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

On Jun 17, 10:49*pm, "dn.p... (AT) gmail (DOT) com" <dn.p... (AT) gmail (DOT) com> wrote:
Also note you can protect commas and tabs with double quotes, as you
could see by saving excel files as csv's.

jg
--
@home.com is bogus.
http://www.boston.com/bostonglobe/id...side_of_wrong/

Op 22-6-2010 1:45, joel garry schreef:
Or just use different field seperators.

Shakespeare

On Jun 22, 12:08*am, Shakespeare <what... (AT) xs4all (DOT) nl> wrote:
How many ways does Excel blow? Don't get me started...

jg
--
@home.com is bogus.
http://thedailywtf.com/Articles/A-Gr...ce-Period.aspx

"dn.perl (AT) gmail (DOT) com" <dn.perl (AT) gmail (DOT) com> writes:

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 (DOT) net ---