How to search for a specific column in all Oracle schema

As an ETL developer, this is something I have to do when developers of a source database application have to extend the length of a field. Because that field can be used in so many different projects and/or datamart, I need to find all the possible tables and views of all schemas having the field in my database.

Here is how I do it.. Suppose i’m looking for a column named “awesome_id”.  All I have to do is to execute this query with a user having the privileges to read into all schemas.

It will return all the tables having a column with the word “awesome_id”.

But it didn’t look the queries used to build views. Instead I have to use:

Unfortunately, it only returns the first 4000 characters of the queries, but the lookup is done on the complete queries.