Hello,
I've read the tutorials and tried everything i can think of, but i'm just having a problem getting oracle to do the whole orderby 5, 20 ... whatever. The list of results that will display only x number of rows at a time. I don't want to select every row because it would be quite a db hit. My problem is that i'm doing a multiple join, then i'm ordering the results by column x, then the problem arises because the rownum that i want to order by is now out of order itself. Has anyone dealt with this problem before? ANY help is greatly appreciated.
Dan
I've read the tutorials and tried everything i can think of, but i'm just having a problem getting oracle to do the whole orderby 5, 20 ... whatever. The list of results that will display only x number of rows at a time. I don't want to select every row because it would be quite a db hit. My problem is that i'm doing a multiple join, then i'm ordering the results by column x, then the problem arises because the rownum that i want to order by is now out of order itself. Has anyone dealt with this problem before? ANY help is greatly appreciated.
Dan