Re: ** LIKE with RAW
Date: Sat, 3 Jan 2009 09:57:07 -0800 (PST)
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;
> Can you tell how I can convert
> '7261772076616C7565' to 'raw value'.
-- 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