ORACLE：檢視登入帳號下所有 OBJECT 資訊

~~~ 從 Xuite 搬過來 ~~~

透過 USER_OBJECTS Table 查詢目前登入 schema 的 OBJECT 資訊
查詢物件(table, view, trigger...)名稱

SELECT OBJECT_NAME FROM USER_OBJECTS;

select * 可查以下資訊
object_name, subobject_name, object_id, data_object_id, object_type,
created, last_ddl_time, timestamp, status, temporary,
generated, secondary, namespace, edition_name

SELECT * FROM USER_OBJECTS WHERE OBJECT_NAME IN('TI_QU06','TI_QU17');