Re: How to export a LONG field to Excel
From: joel garry <joel-garry_at_home.com>
Date: Mon, 21 Jun 2010 16:45:25 -0700 (PDT)
Message-ID: <b9b359b8-9eb9-44f9-b713-26d21fb46e8a_at_u26g2000yqu.googlegroups.com>
On Jun 17, 10:49 pm, "dn.p..._at_gmail.com" <dn.p..._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.
Date: Mon, 21 Jun 2010 16:45:25 -0700 (PDT)
Message-ID: <b9b359b8-9eb9-44f9-b713-26d21fb46e8a_at_u26g2000yqu.googlegroups.com>
On Jun 17, 10:49 pm, "dn.p..._at_gmail.com" <dn.p..._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.
Also note you can protect commas and tabs with double quotes, as you could see by saving excel files as csv's.
jg
-- _at_home.com is bogus. http://www.boston.com/bostonglobe/ideas/articles/2010/06/13/the_bright_side_of_wrong/Received on Mon Jun 21 2010 - 18:45:25 CDT