create cluster credit_cluster (
card_no varchar2(16),
transdate date sort
)
hashkeys 10000 hash is ora_hash(card_no) [znP80w1(
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);
|