Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Will ROWID change during DB Runing??
ROWID really won't help you much in the situation you described. WHY do
you want to use a pseudocolumn value for such a small table?
using ROWID is generally bad idea, IMHO. (and in case you didn't know,
I really dislike ROWNUM too.)
If you are working with one customer account then use as Daniel
suggests: SELECT ... FOR UPDATE;
Or use your Primary Key.
Ed. Received on Fri Dec 31 2004 - 09:28:34 CST