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 -> Re: Will ROWID change during DB Runing??

Re: Will ROWID change during DB Runing??

From: Ed Prochak <ed.prochak_at_magicinterface.com>
Date: 31 Dec 2004 07:28:34 -0800
Message-ID: <1104506914.007695.296640@z14g2000cwz.googlegroups.com>


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

Original text of this message

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