select * from test where my_long like '%toto%'
A good way to learn is to try to answer user questions. Instead of referencing other posts, I tried today to answer that frequently asked question myself on developpez.com (french forum)
SQL> create table test ( my_long long);
Table created.
SQL> insert into test values ('hello toto !');
1 row created.
SQL> exec for r in ( select my_long from test ) loop if (r.my_long like '%toto%') then dbms_output.put_line(r.my_long); end if; end loop
hello toto !
Posted by Laurent Schneider at 1/17/2006 02:09:00 PM
Permalink : select * from test where my_long like '%toto%'
Post to :
del.icio.us -
furl -
digg -
reddit -
co.mments
2 Comments:
works up to 32k only - Oracle Text can index that and then contains() can be used to perform these searches on any length long.
Keep on answering :)
yes, only until 32k. I did not know oracle text could index "long"... thanks for the info :-)
Post a Comment
<< Home