Re: howto use ROWNUM which is using in ORACLE??

Dick Snoke wrote: >I believe y'all are confusing two separate issues. The Informix rowid is >related to the location of the row. The Oracle rownum is the number of >the row in the set of rows returned by a single query. That means the >same row may have a different rownum each time its retrieved from the >database. >Informix has no direct equivalent of the rownum. I wasn't aware of the limited scope of the ROWNUM in Oracle. Thanks for the clarification. carlos Currently on hiatus from unemployment. ---------------------- Do you do Linux? :) Get your FREE @linuxstart.com email address at: http://www.linuxstart.com