Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: creation date of a table?

Re: creation date of a table?

From: AMARENDRA B NETTEM <nettama_at_charlie.cns.iit.edu>
Date: 1998/03/09
Message-ID: <3504457D.D84ECF88@charlie.cns.iit.edu>#1/1

Hi,
Try this SQL statemet
SELECT created FROM user_objects
WHERE object_name ='EMP';

AMARENDRA 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

--
*****************************************************************
AMARENDRA B NETTEM
Oracle Certified DBA (OCP)
Whittman-Hart Inc.,
311 South Wacker Drive, Suite 3500
Chicago, IL 60606.

Residence:
-----------
5039 N E River Road,
Apt. 1A
NORRIDGE, IL 60656


Ph.No. (708) 583 9870 (H)
       (312) 913 6758 (W)

 E-mail:nettama_at_charlie.cns.iit.edu,
        anettem_at_whittman-hart.com

Homepage: http://www.iit.edu/~nettama

****************************************************************
Opinions are mine and do not necessarily reflect those
of Whittman-hart Inc.
Received on Mon Mar 09 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US