Have a dynamic SQL stored procedure how to statistical tables and up all involved in the process?-CodePudding

Home > database > Have a dynamic SQL stored procedure how to statistical tables and up all involved in the process?

Have a dynamic SQL stored procedure how to statistical tables and up all involved in the process?

Time：10-06

I'm from dba_dependencies statistics, but I found that the dynamic SQL reference table is not here,

CodePudding user response:

User_source at no

CodePudding user response:

Certainly not, because the name of the table can also be dynamically;

CodePudding user response:

Dynamic SQL, it involves the objects is variable, seems to have no place to store this statistics, ORACLE