Re: ** LIKE with RAW

From: Alex Fatkulin <afatkulin_at_gmail.com>
Date: Sun, 28 Dec 2008 12:37:24 -0500
Message-ID: <49d668000812280937x4c2a773dpfe36b76dd7a19a3c@mail.gmail.com>

It is would be nice if you could provide an example, but I'll take a bet and guess that you're stuffing % in a wrong place...

it works

SQL> create table r (r raw(32));

Table created.

SQL> insert into r values (utl_raw.cast_to_raw('raw value'));

1 row created.

SQL> insert into r values (utl_raw.cast_to_raw('raw value again'));

1 row created.

SQL> commit;

Commit complete.

SQL> select *

  2     from r
  3     where r like utl_raw.cast_to_raw('raw')||'%';

R

---

7261772076616C756520616761696E
7261772076616C7565

On Sun, Dec 28, 2008 at 12:17 PM, A Joshi <ajoshi977_at_yahoo.com> wrote:
>
> Hi,
> I have a column with datatype RAW. I can select the data and search using
> = . When try to select using LIKE : it does not work and it does not return
> any rows. Is there a way I can use LIKE. Thanks
>
> * I do a select to get the data and then from the data returned : do a
> select using LIKE and it does not return rows. Thanks for help.
>
>

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

Received on Sun Dec 28 2008 - 11:37:24 CST