Oracle-查看使用者物件資訊

標籤：

--視圖(可查看擁有者、對象名稱、建立時間、上次修改時間)SELECT t.OBJECT_NAME, t.CREATED, t.LAST_DDL_TIME FROM user_objects t order by t.LAST_DDL_TIME desc;SELECT t.OWNER, t.OBJECT_NAME, t.CREATED, t.LAST_DDL_TIME FROM all_objects t;SELECT t.OWNER, t.OBJECT_NAME, t.CREATED, t.LAST_DDL_TIME FROM dba_objects t;--查看最近修改對象SELECT t.OBJECT_NAME,t.OBJECT_TYPE,t.CREATED,t.LAST_DDL_TIME FROM user_objects t WHERE T.OBJECT_TYPE IN(‘TABLE‘,‘SEQUENCE‘,‘TRIGGER‘,‘PROCEDURE‘)order by t.LAST_DDL_TIME desc;

 

Oracle-查看使用者物件資訊