Laurent Schneider

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 !

This entry was posted on Tuesday, January 17th, 2006 at 14:09 and is filed under oracle, sql, dba. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
Post to : del.icio.us - Digg it - Furl - reddit - Spurl

Put your code in <code> and </code> tags

2 Responses to “select * from test where my_long like ‘%toto%’”

Thomas Kyte Says:
January 17th, 2006 at 17:43
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
Laurent Schneider Says:
January 18th, 2006 at 09:29
yes, only until 32k. I did not know oracle text could index “long”… thanks for the info

Use <code> and </code> to post code

select * from test where my_long like ‘%toto%’

2 Responses to “select * from test where my_long like ‘%toto%’”

Leave a Reply