Re: rownum HELP ....

Darta wrote:

I haven't read the question in detail, so this may be way off base, but have you considered using rowid instead of rownum? rownum is a psuedo-column that's a bit "slippery", i.e. it's value changes depending on the where clause, so putting it in the where clause can cause unexpected behavior. Rowid doesn't have this problem; it is what it is independent of what you do with the where clause.

I generally avoid using rownum in the where clause, except for trivial uses like 'WHERE rownum < n'.

-- 


//-Walt

//

//