Is there a way to search in the code which is stored in the database?
Oracle has view ALL_SOURCE, which contains all codes of all objects (function, procedures, packages, triggers, types, etc.). What I am looking for is a possibility to search there. For example, if I have a table MY_TABLE, I would like to find all packages which somehow interact with this table, and a piece of the corresponding code.
I didn't find such function in IDE.
P. S. Currently, I am working with IDEA, but as I understand, all IDEs have the same database tools, and DataGrip is more related to database questions.