Wednesday, August 28, 2013

Is it safe to use ROWID to locate a row doing update?

If the strings length changes a lot, the rowid could change.

it will be safer to do it with PK together:

update t
where rowid = :x and primary_key = :pk;


No comments:

Post a Comment