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.

0
2 comments

@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:

1

Thank you, it works even better than I expected!

0

Please sign in to leave a comment.