Home » SQL & PL/SQL » SQL & PL/SQL » update time (Oracle 10g)
update time [message #364647] Tue, 09 December 2008 07:33 Go to next message
pointers
Messages: 410
Registered: May 2008
Senior Member
Hi,

How can we know the last updated time of a table..?
I have a table, for that I need to find what was the last updated time..?

Regards,
Pointers.
Re: update time [message #364648 is a reply to message #364647] Tue, 09 December 2008 07:37 Go to previous messageGo to next message
knicely87
Messages: 25
Registered: December 2008
Location: Pittsburgh, PA
Junior Member
What version of Oracle are you using? There are so many ways.
Re: update time [message #364653 is a reply to message #364647] Tue, 09 December 2008 07:48 Go to previous messageGo to next message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
Last update time of what? The data or structure?
Re: update time [message #364655 is a reply to message #364647] Tue, 09 December 2008 07:52 Go to previous messageGo to next message
pointers
Messages: 410
Registered: May 2008
Senior Member
I am using oracle 10g.
I mean data if it is structure I would say alter rather update.

Regards,
Pointers.
Re: update time [message #364657 is a reply to message #364647] Tue, 09 December 2008 07:53 Go to previous messageGo to next message
knicely87
Messages: 25
Registered: December 2008
Location: Pittsburgh, PA
Junior Member
Good question. I'm sure by "update" they meant data. I think.
Re: update time [message #364658 is a reply to message #364647] Tue, 09 December 2008 08:00 Go to previous messageGo to next message
knicely87
Messages: 25
Registered: December 2008
Location: Pittsburgh, PA
Junior Member
Are you trying to track DML or DDL changes to a table? I can't tell by your last reply.
Re: update time [message #364659 is a reply to message #364655] Tue, 09 December 2008 08:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
pointers wrote on Tue, 09 December 2008 14:52
I am using oracle 10g.
I mean data if it is structure I would say alter rather update.

Regards,
Pointers.

Version must be given with 4 decimals.

And search must be done before posting. This question has been asked many times.

Regards
Michel

Re: update time [message #364665 is a reply to message #364647] Tue, 09 December 2008 08:20 Go to previous messageGo to next message
pointers
Messages: 410
Registered: May 2008
Senior Member
I agree Micheal.

But I searched in our forum. I dint find it.
If you could paste the link or query, that would be greatly appreciated.

version:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0

Regards,
Pointers.
Re: update time [message #364667 is a reply to message #364665] Tue, 09 December 2008 08:28 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Using your question: "last updated time":
http://www.orafaq.com/forum/?SQ=a8779f8c8238d2602b42bebb7ece00f0&t=search&srch=last+updated+time&btn_submit=Search&fi eld=all&forum_limiter=1&search_logic=AND&sort_order=DESC&author=

Scroll down there are at least:
recent updated table name
Select the last updated record using timestamp
...

But there are more recent topics.
Use different words.
In short, there is none unless you designed for it.

Regards
Michel
Previous Topic: Excel "WORKDAY" function in Oracle PL/SQL
Next Topic: Shifting Data
Goto Forum:
  


Current Time: Wed Dec 07 18:13:55 CST 2016

Total time taken to generate the page: 0.09069 seconds