yes i am displaying 10 rows at a time and also there is no order by clause in VO query.
The above method did not work again. I tried and again got the serial number which is not ordered.
You can see my query:- select decode(mod(rownum,10), 0, 10, mod(rownum,10)) Serial_Number,party_name,address1,address2 from hz_parties
As i mentioned in my question in the beginning that after sortin the sr_no disappers i am able to solve it by handling SORT_EVENT.
Now the only problem left is that it shows me the last results first. Can you please help me here?