Queries involving the table under the stored procedure: select * from dba_dependencies t
Where t.r eferenced_owner=[user]
And t.t ype='PROCEDURE'
And t.r eferenced_type='TABLE'
And NAME=[PROCEDURE_NAME]

CodePudding user response:

Name lookup table, the table name, field name, field name, field type involved in the system tables user_tab_columns, user_tab_comments, user_col_comments

CodePudding user response:

Backup storage process involves user_source table