CELKO (10/5/2011)

---

Please post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, data types, etc. in your schema are. Please learn to follow...

R.P.Rozema (10/5/2011)

edit: coming to think of it, do you intend to make the even rows show in a different color than the uneven rows? If so, what about this:

select (row_number()...

Yeah I was typing away and hit the enter button and bang! the message was sent. You read it while I was "Editing" my post to add more details....