Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    5

    Unanswered: How exactly is Rowid is created

    Hi,
    i just wanted to know..
    1) from rowid can i find out which is the oldest record among 2 duplicates if i dont have any date column in my table.

    2) can any once tell me how the rowid is created is it always in increasing order and what exactly the full those 16 charecters stands for could any one please help me ..
    coz i want to delete teh duplicate records and retain the oldest one..

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    I thought I'd already answered (1) for you here: http://www.dbforums.com/t997665.html

    You can read all about ROWIDs in the Concepts Guide. The ROWID is made up of various pieces of information such as file number, block number, row number.

    Nothing in the ROWID denotes the order of insertion of the records. The last record inserted may well have a ROWID that is lower than that of 1000s of existing records. ROWIDs are not a solution to the problem you have, which is that you need to know the creation order of records but are failing to record that information!

    Still, if you have 2 duplicate records and no way of telling which is the oldest and which is the newest - does it really matter which one you delete?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •