Re: Pls Help... Oracle sort order

fitzjarrell_at_cox.net wrote:

> It doesn't matter if you're using Oracle 2 or Oracle 10gR2, the answer
> is still the same. Maybe in Oracle 44 ordered heap tables will exist.
>

>> Thanks.

In a sense they do now. Try this example from Morgan's Library.

CREATE CLUSTER sorted_hc (
program_id NUMBER(3),
line_id NUMBER(10) SORT,
delivery_dt DATE SORT)
TABLESPACE uwdata
HASHKEYS 11
HASH IS program_id;

CREATE TABLE shc_airplane (
program_id NUMBER(3),
line_id NUMBER(10) SORT,
delivery_dt DATE SORT,
customer_id VARCHAR2(3),
order_dt DATE)
CLUSTER sorted_hc (program_id, line_id, delivery_dt);

But it seems it is not the data that is sorted but rather the hashes.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org