Search in the database code in Oracle
Completed
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.
Please sign in to leave a comment.
@Dmitriy Kurashkin,
There are several ways to do it, you can use `Find usages`, `Full text search` in specified view. Refer to help article https://www.jetbrains.com/help/datagrip/how-to-find-things-in-datagrip.html#db_tutorial_code .
Also you can narrow down your search via scopes:
Thank you, it works even better than I expected!