MILLION DOLLAR SERVER
A Fine Turn Server Worth Million Dollar
Labels
Debian
Ubuntu
Oracle
Check_MK
WordPress
Redmine
Python
Search This Blog
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
set...
where rowid = :x and primary_key = :pk;
Reference:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:53140678334596
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment