Home » SQL & PL/SQL » SQL & PL/SQL » How To See Latest created Table Including Time in oracle. Is there any table for it? (Oarcle 11g)
icon3.gif  How To See Latest created Table Including Time in oracle. Is there any table for it? [message #643465] Thu, 08 October 2015 02:07 Go to next message
graphe
Messages: 23
Registered: October 2014
Junior Member
/forum/fa/12884/0/
How To See Latest created Table Including Time in oracle. Is there any table for it?
I saw USER_OBJECTS Table But there it has only the CREATED date Column is there.
I want to see the created time of that TABLE also.
Can Anybody Help me in this?
  • Attachment: table.png
    (Size: 33.31KB, Downloaded 1621 times)

Report message to a moderator

Re: How To See Latest created Table Including Time in oracle. Is there any table for it? [message #643466 is a reply to message #643465] Thu, 08 October 2015 02:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

Dates in Oracle also contain time.
Your default date display format is DD-MON-RR so you have not the time part.
Use TO_CHAR to display the date in the format you want:
SQL> select sysdate from dual;
SYSDATE
-----------
08-OCT-2015

1 row selected.

SQL> select to_char(sysdate,'DD/MM/YYYY HH24:MI:SS') from dual;
TO_CHAR(SYSDATE,'DD
-------------------
08/10/2015 09:35:32

1 row selected.


[Edit: Add link to date format elements]

[Updated on: Thu, 08 October 2015 02:37]

Report message to a moderator

Re: How To See Latest created Table Including Time in oracle. Is there any table for it? [message #643467 is a reply to message #643465] Thu, 08 October 2015 02:51 Go to previous messageGo to next message
flyboy
Messages: 1903
Registered: November 2006
Senior Member
Alternatively, start studying your GUI display tool (whichever it is) documentation, especially the part how to define NLS parameter "Date Format" (my SQL Developer named it so, it may differ in your tool) - it holds the display format of data with DATE data type.

Report message to a moderator

Re: How To See Latest created Table Including Time in oracle. Is there any table for it? [message #643471 is a reply to message #643466] Thu, 08 October 2015 04:21 Go to previous messageGo to next message
graphe
Messages: 23
Registered: October 2014
Junior Member
KK I got it i find out that i made the query as TO_CHAR(CREATED,'DD/MON/YYYY HH24:MI:SS') .
So with the Above expression i m able to getting the created time .
Thanks for your Help.

Report message to a moderator

Re: How To See Latest created Table Including Time in oracle. Is there any table for it? [message #643475 is a reply to message #643471] Thu, 08 October 2015 05:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

"KK" is not in my English dictionary.

Report message to a moderator

Re: How To See Latest created Table Including Time in oracle. Is there any table for it? [message #643476 is a reply to message #643475] Thu, 08 October 2015 05:48 Go to previous messageGo to next message
graphe
Messages: 23
Registered: October 2014
Junior Member
I didn't mean about your Capability in Oracle. i mean i catch u what u said to me.

Report message to a moderator

Re: How To See Latest created Table Including Time in oracle. Is there any table for it? [message #643478 is a reply to message #643476] Thu, 08 October 2015 05:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

I didn't mean you didn't catch mean, I mean what I already repeated you in your previous topic.
DO NOT USE IM/SMS SPEAK.
Is this clear?

Report message to a moderator

Re: How To See Latest created Table Including Time in oracle. Is there any table for it? [message #643610 is a reply to message #643475] Tue, 13 October 2015 09:22 Go to previous message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
Michel Cadot wrote on Thu, 08 October 2015 06:41

"KK" is not in my English dictionary.


I suspect that it was OK, not KK, but I agree. U is a letter without meaning. "You" means yourself.

[Updated on: Tue, 13 October 2015 09:23]

Report message to a moderator

Previous Topic: HOW TO STORE ROWID DATA BY USING ROWID DATA TYPE?
Next Topic: Regular Expression
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 15 11:19:02 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.