Monday, May 5, 2008

When was a table created in Oracle

Jez....I thought I would never figure this out, but it is so very simple.

select OBJECT_NAME
,CREATED
from ALL_OBJECTS
where OWNER = 'GEAP_PROJECT'
and OBJECT_TYPE = 'TABLE'
and OBJECT_NAME = 'TBL_PRG_DELIVERY_TYPE'

No comments: