RE: rowid value
Date: Tue, 5 Aug 2014 15:24:16 +0000
Message-ID: <1AFD62082EEAF0448EF1815139687F1324BF6C3A_at_NC2PWEX504.us.ad.lfg.com>
If I could assume you have access and the necessary predicates to identify the duplicate rows, you can just select out the ROWIDs and use the order by clause:
select rowid, department_name
from departments
order by rowid;
If you do not have the knowledge to design a predicate to identify the duplicate rows and you are only concerned with the two in your post, you could do something like this:
with rowids as (
select 'AAAocvACXAAAPFJAAa' from dual
union
select 'AAAocvACXAAAPFJAAb' from dual)
select *
from rowids
order by 1;
In the above example, I would say then the last rowid returned is the higher one. I believe that is simply based on ascii sorting as you can see the last characters are a and b with b returning as the"higher" one.
Chris..
Chris Ruel * Oracle Database Administrator cruel_at_lfg.com<mailto:cruel_at_lfg.com> * Desk:317.759.2172 * Cell 317.523.8482
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Zelli, Brian
Sent: Tuesday, August 05, 2014 11:07 AM
To: oracle-l (oracle-l_at_freelists.org)
Subject: rowid value
Another dba I'm covering for told me to delete a duplicate with the higher rowid? Which one is the higher rowid? AAAocvACXAAAPFJAAa or AAAocvACXAAAPFJAAb?
Brian
This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you. Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 05 2014 - 17:24:16 CEST