Tell me how can I find a procedure or package that uses a specific table? From the context menu of the table, select "Go to" - nothing happens. Are there any other methods?

    1 answer 1

    There is a universal way - to look at the system view ALL_DEPENDENCIES , DBA_DEPENDENCIES , USER_DEPENDENCIES .

     select * from all_dependencies where owner = 'TABLE_OWNER' and name = 'TABLE_NAME'

    There links all objects with all.

    You can also search by source ( ALL_SOURCE ), but there is a little longer and you need to bother with the register, but you will find the right line.

     select * from all_source where upper(text) like ('%TABLE_NAME%') order by line