[SQL] Search content from all views in Oracle

I have over a 300 views in an Oracle database.

I am looking for a string in the view result. For example, I want to look for "Admission Possible" in the view resultset.

Is there any query which can scan all the views output and get me the list of all the views which will have this string.

PS: I am not looking for any string in the create view SQL command.I want it like this:

Select * from vw_ABC


should have one+ columns which has this string.

Please let me know if this is possible.

Thanks

Continue reading...