SQL & PL/SQL

Hi

i have a search string that i need to check in all_mview and all_views .

for example :-

select owner,Mview_name from all_mviews where upper(query) like upper('example 1')
select owner,view_name from all_views where upper(text) like upper('example 1')

but here query and text columns are long column and i can not search this values.
it gives inconsistent data type.

Please help me on this to get the desired result.


regards
shyam~