select * from user_arguments;
select * from user_dependencies;
select * from user_errors;
select * from user_identifiers;
select * from user_object_size;
select * from USER_PLSQL_OBJECT_SETTINGS ;
select * from USER_PROCEDURES;
select * from USER_SOURCE where name='F';
select * from USER_STORED_SETTINGS;
select * from user_triggers;
select * from user_dependencies;
select * from user_errors;
select * from user_identifiers;
select * from user_object_size;
select * from USER_PLSQL_OBJECT_SETTINGS ;
select * from USER_PROCEDURES;
select * from USER_SOURCE where name='F';
select * from USER_STORED_SETTINGS;
select * from user_triggers;
select * from user_trigger_cols;
对于select * from user_identifiers;这个视图来说,可以跟踪程序中的标识符的使用,要使用该功能,需要启用pl/scope
ALTER SESSION SET plscope_settings='IDENTIFIERS:ALL' /plscore_settings的值有2个, IDENTIFIERS:ALL or IDENTIFIERS:NONE,默认是NONE
<