oracle tablo view oluşturma düzenleme tarihi Etiketli Yazılar

Oracle – Object Creation and Modification Dates

SELECT   owner, object_name, TO_CHAR (created, 'YYYY-MM-DD hh:mi:ss') created,
         TO_CHAR (last_ddl_time, 'YYYY-MM-DD hh:mi:ss') modified, object_type
FROM dba_objects
WHERE owner LIKE UPPER ('XTablespace')
ORDER BY created,modified DESC