SELECT * FROM dba_objects t where t.OBJECT_TYPE=’PROCEDURE’;
SELECT * FROM dba_objects t where t.OBJECT_TYPE=’INDEX’;
dba_objecst里面有个status字段,valid为有效,invalid即为失效
时间:2023-08-22 01:29:26
SELECT * FROM dba_objects t where t.OBJECT_TYPE=’PROCEDURE’;
SELECT * FROM dba_objects t where t.OBJECT_TYPE=’INDEX’;
dba_objecst里面有个status字段,valid为有效,invalid即为失效