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
//
//
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
//
//