Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: creation date of a table?
Try
select to_char (created, 'DD.MM.YYYY HH24:MI:SS')
from user_objects
where object_name = 'YOUR_TABLE_NAME'
/
Worked for me.
Martin Haltmayer
Jimmy wrote:
>
> Hello all,
>
> Is it possible to see the creation date of a table? Or can I do that by
> a select statement?
>
> Thanks
> Jimmy
Received on Fri Mar 06 1998 - 00:00:00 CST