Answer:
create table user_views_clob
(view_name VARCHAR2(32),
clob_text CLOB)
/
insert into user_views_clob
select view_name, to_lob(text) from user_views
/
and do the search like
select * from user_views_clob where upper(clob_text) like upper('%hello_world%');
replace hello_world with your text.