Home » SQL & PL/SQL » SQL & PL/SQL » Determine rows without a Date/Time column?
Determine rows without a Date/Time column? [message #384186] Mon, 02 February 2009 11:28 Go to next message
Duane
Messages: 452
Registered: December 2002
Senior Member
Is it possible to determine the Date/Time stamp of a row without there being a Date/Time column? Maybe something in the system that would tell me when the row was created?
Re: Determine rows without a Date/Time column? [message #384187 is a reply to message #384186] Mon, 02 February 2009 11:31 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you

Answer depends upon Oracle version which you decided not to post;
contrary to Posting Guidelines (above).
Re: Determine rows without a Date/Time column? [message #384194 is a reply to message #384186] Mon, 02 February 2009 12:06 Go to previous messageGo to next message
Duane
Messages: 452
Registered: December 2002
Senior Member
Oh, sorry.

Oracle Version 10.2.0.1.0

Windows 2003 Server 5.2 SP2

Re: Determine rows without a Date/Time column? [message #384196 is a reply to message #384194] Mon, 02 February 2009 12:12 Go to previous message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA_ROWSCN
Read it and follow the links.

Regards
Michel
Previous Topic: Reading into a Defined structure (merged)
Next Topic: update trigger take an insert in the same table
Goto Forum:
  


Current Time: Wed Dec 07 04:52:02 CST 2016

Total time taken to generate the page: 0.06993 seconds