Re: Native Hash Full Join and Pagination Query 11g

From: Stalin <stalinsk@xxxxxxxxx>
To: "Mark W. Farnham" <mwf@xxxxxxxx>
Date: Tue, 3 Nov 2009 12:08:59 -0800

Thanks for the response mark.

Yes i was testing with just accountId initially but the ultimate goal
is to sort the results by customer and
customer's accounts sorted by another actID.

I don't think sort order of null values should be an issue.

On Tue, Nov 3, 2009 at 11:59 AM, Mark W. Farnham <mwf@xxxxxxxx> wrote:
> you've changed the order by since the original posting. which order by do
> you actually want? a.actID versus c.name, a.actID
>
> How do you want null values to sort for the sort order you actually want?
>
--
http://www.freelists.org/webpage/oracle-l

References:

Native Hash Full Join and Pagination Query 11g
From: Stalin

Re: Native Hash Full Join and Pagination Query 11g
From: Dion Cho

Re: Native Hash Full Join and Pagination Query 11g
From: Stalin

RE: Native Hash Full Join and Pagination Query 11g
From: Mark W. Farnham

Re: Native Hash Full Join and Pagination Query 11g

Other related posts: