How to find a specific text inside SQL VIEW

Transact-SQL
1

Hi Friends,
I want to find out how many views are there in a particular schema or all schema where a specific Text ( e.g. "Deployment") is being used in view definition/script.

e.g.
if I have a view and if 'Deployment' is used in where clause I want to count that view
If I have a view and if "Deployment' text is being used in query then I want to count that view

2

I would recommend posting your question on a site that specializes in Oracle. SQLTeam.com is primarily for Microsoft SQL Server, though maybe someone will answer your question here.