Is there a way to determine which record was entered in last

Hi, I have records that have same key fields(PK was disabled) but other fields are different. Is there a way to determine which record was inserted in last. I do not think rowid would guarantee it. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

Re: Is there a way to determine which record was entered in last

No way. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 27, 2002 2:33 PM Hi, I have records that have same key fields(PK was disabled) but other fields are different. Is there a way to

Re: Is there a way to determine which record was entered in last

[EMAIL PROTECTED] wrote: Hi, I have records that have same key fields(PK was disabled) but other fields are different. Is there a way to determine which record was inserted in last. I do not think rowid would guarantee it. Thanks Rick No if you have no timestamp. I would tend to

RE: Is there a way to determine which record was entered in last

If u r 9i, then create table t1 (c1 number) ; set serveroutput on; declare v1 number; begin insert into t1 values(1) returning c1+10 into v1; dbms_output.put_line(v1); end; more at

Re: Is there a way to determine which record was entered in last

Does the row have a column with a DATE or timestamp datatype? If so, is there a trigger or DEFAULT value associated with the insert action? Was Audit turned on? If auditing was on for the table and for inserts or updates, then you should be able to determine which record was entered last. RWB

Re: Is there a way to determine which record was entered in last

How about logminer? Igor Neyman ineyman@perce