I am trying to select some text within all_views but get an error.
I know the text column is a long datatype and when I query the view,
the text field shows the code for the views being selected.
--I want to find what views have a column name of 'project' being used within the view:
select * from all_views where owner = 'AJT' and text like '%project%';
using Oracle 11g