The reason for this is probably because the original poster inherited
a database without a primary key, and now needs to make edits to it.
That happened to me with Oracle once, and I was lucky enough to be
able to use Oracle's rowid, which is a unique reference to the row
that is independent of
At 03:43 AM 8/10/2006, you wrote:
Hi All,
Is there any way to refer a row based on the row number or
row count?
I just the effect as below...
E.g. UPDATE TBL_NAME SET COL_NAME = xyz WHERE ROW_NO=4
Or SELECT COL_NAME FROM TBL_NAME WHERE ROW_NO=5
Regards,
Ravi K
Ravi
Why would you want to do this? As data moves around within the table the
updates will be in error. Wouldn't it be easier to assign a unique key to each
row, search for the key or unique set of information and update the resulting
row?
Bob
-Original Message-
From: [EMAIL PROTECTED]
Bartis, Robert M (Bob) wrote:
Why would you want to do this? As data moves around within the table the
updates will be in error. Wouldn't it be easier to assign a unique key to
each row, search for the key or unique set of information and update the
resulting row?
Bob
I don't know,
At 14:13 +0530 8/10/06, [EMAIL PROTECTED] wrote:
Hi All,
Is there any way to refer a row based on the row number or
row count?
I just the effect as below...
E.g. UPDATE TBL_NAME SET COL_NAME = xyz WHERE ROW_NO=4
Or SELECT COL_NAME FROM TBL_NAME WHERE ROW_NO=5
No, because