Re: ** LIKE with RAW

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Sat, 3 Jan 2009 09:57:07 -0800 (PST)
Message-ID: <210094.1518.qm_at_web57514.mail.re1.yahoo.com>



Thanks Alex. It works. In my case the field has values like } and cut and paste of that translates to \372\341

So looks like the field does not have proper varchar2 values. I will keep looking. The table has millions of rows. I have identified some 100 rows with data discrepancy that begin with a certain value when I do a simple select like select r from r. Just want to work with those 100 rows instead of having to work with millions of rows. Thanks again for your help.

  • On Wed, 12/31/08, Alex Fatkulin <afatkulin_at_gmail.com> wrote: From: Alex Fatkulin <afatkulin_at_gmail.com> Subject: Re: ** LIKE with RAW To: ajoshi977_at_yahoo.com Cc: "oracle-l" <oracle-l_at_freelists.org> Date: Wednesday, December 31, 2008, 7:44 PM

SQL> select utl_raw.cast_to_varchar2('7261772076616C7565') from dual;

UTL_RAW.CAST_TO_VARCHAR2('7261772076616C7565')



raw value

>
> Can you tell how I can convert
>
> '7261772076616C7565' to 'raw value'.
>
> Thanks
>

-- 
Alex
 Fatkulin,
http://www.linkedin.com/in/alexfatkulin
--
http://www.freelists.org/webpage/oracle-l





      

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Jan 03 2009 - 11:57:07 CST

Original text of this message