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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: