RE: Dratted LONG column
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 25 Jun 2004 10:21:24 -0400
You can read longs that are less than 32k in size into pl/sql varchar2
variables which can be 32k in size. From there you can just treat the data
as varchar2 and use all the regular character datatype functions on the
data.
The conversion of the data to clob is probably the best long-term solution.
HTH -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Thomas Day
Sent: Friday, June 25, 2004 9:29 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Dratted LONG column
Thanks. I went one further and just converted the long to clob (alter
table). I couldn't find another useful way to do anything with the long.
Daniel Fink
<Daniel.Fink To:
oracle-l@xxxxxxxxxxxxx
@Sun.COM> cc:
Sent by: Subject: Re: Dratted LONG
column
oracle-l-bounce
06/25/2004 09:18
AM
Please respond
to oracle-l
Thomas,
I posted a solution to checking constraint conditions (also a long) for
duplicates. The basic idea is to create a gtt with a clob, insert the long
(using to_lob() function, then manipulate the resulting character 'string'.
As
long as you know that the data is character and only character, this should
work. It's a cludge, but it does work.
Regards,
Daniel Fink
Thomas Day wrote:
> I have to do a select using the long column in the where clause.
>
> Of course that won't work.
>
> 7 million rows. Some of the long data is over 15,000 characters (people
> like to write novels).
>
> I've tried to use the ANYDATA data type but I can't COPY into ANYDATA and
I
> can't SELECT (for insert) from a LONG. Any ideas (or being pointed in the
> right direction) would be greatly appreciated.
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
