Home » SQL & PL/SQL » SQL & PL/SQL » finding time of inserted record
finding time of inserted record [message #222167] Fri, 02 March 2007 02:30 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

Hi,

Is it possible to find out the date and time of inserted records in the table?.

when the reocrds has been inserted in the table?


regards,

arun..
Re: finding time of inserted record [message #222168 is a reply to message #222167] Fri, 02 March 2007 02:35 Go to previous messageGo to next message
Littlefoot
Messages: 20892
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, not unless you have decided to store this information in a table during insert operation.
Re: finding time of inserted record [message #222208 is a reply to message #222168] Fri, 02 March 2007 05:11 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Or if you had auditing turned on.
Re: finding time of inserted record [message #222308 is a reply to message #222167] Fri, 02 March 2007 14:50 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
Every table we create and I mean every table we define a time_stamp column and a userid column populated via a trigger

[Updated on: Fri, 02 March 2007 14:52]

Report message to a moderator

Re: finding time of inserted record [message #222319 is a reply to message #222308] Fri, 02 March 2007 16:19 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
There was a discussion here recently about ORA_ROWSCN. Make sure you read it all.

Ross Leishman
Previous Topic: Index
Next Topic: help me for a table with lob datatype
Goto Forum:
  


Current Time: Mon Dec 05 03:06:41 CST 2016

Total time taken to generate the page: 0.07795 seconds