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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 say that if : a) no delete is ever performed b) the number of freelists is one then the rowid WITHIN ONE EXTENT would probably be significant, and I don't see any reason why extents would not be filled in the order in which they appear in DBA_EXTENTS, but there is no absolute certainty. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/server.901/a90125/statements_914.htm#2079891 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 11:33 AM To: Multiple recipients of list ORACLE-L Subject: 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Is there a way to determine which record was entered in last
How about logminer? Igor Neyman ineyman@perceTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ptron.comcc: Sent by: Subject: Re: Is there a way to determine which record was entered in [EMAIL PROTECTED]last om August 27, 2002 03:18 PM Please respond to ORACLE-L 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 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).