SQL & PL/SQL

Hi All,

I want to search those views whose text contains a word 'PATIENT'. I queried DBA_VIEWS, but the text column is of Long datatype, so it is not accepting the following query:

select owner, view_name, text from dba_views where text like '%PATIENT%';


Is there any other way out to get such data??

Thanks,
Api