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
raw value
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-lReceived on Sat Jan 03 2009 - 11:57:07 CST