Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Rowid question

Rowid question

From: <mtillberg_at_my-dejanews.com>
Date: Thu, 03 Sep 1998 17:27:02 GMT
Message-ID: <6smjh5$tiv$1@nnrp1.dejanews.com>


  Are rowid values guaranteed to be consistant over updates if the rows they point to aren't changed? For instance, I have a table that users can access in an editor. Although I don't care in what order the data is sorted (actually, I don't want it sorted by value), I want the data to show up in the same sequence everytime. Also, the users only access a few rows at a time. Here's the situation:

User1 loads data into the editor.
User2 loads data into the editor.
User2 makes changes and commits.
User1 makes changes and commits.

  I want to make sure that user1's data has the same rowids as when he started.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Sep 03 1998 - 12:27:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US