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). |