create cluster credit_cluster

            (

            card_no varchar2(16),

            transdate date sort

            )

            hashkeys 10000 hash is ora_hash(card_no)

            size 256;

            

            

            create table credit_orders

            (

            card_no varchar2(16),

            transdate date,

            amount number

            )

            cluster credit_cluster(card_no,transdate);

            

            

            alter session set nls_date_format = "YYYYMMDDHH24MISS";

            insert into credit_orders (card_no,transdate,amount)

            values ('4111111111111111','20050131000123',57.99);

            insert into credit_orders (card_no,transdate,amount)

            values ('4111111111111111','20050130071216',16.59);

            insert into credit_orders (card_no,transdate,amount)

            values ('4111111111111111','20050131111111',39.00);

            insert into credit_orders (card_no,transdate,amount)

            values ('4111111111111111','20050130081001',25.16);