1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
| --Création de la table "DETAIL_FINANC"
DROP TABLE DETAIL_FINANC;
create table DETAIL_FINANC
(
CD_PAYS VARCHAR2(10), ID_APPLI VARCHAR2(30),
ID_FINANC VARCHAR2(30), ID_CAR VARCHAR2(30),
ID_PROM VARCHAR2(30), TX_PROMO NUMBER(10,7),
MNT_TOTAL_FINANC NUMBER(30,3), NBR_MOIS NUMBER(5),
TY_PAIEMENT VARCHAR2(10), MNT_MOIS NUMBER(20,3),
CD_PRELEV VARCHAR2(10), ID_IMPAYE VARCHAR2(30), DT_CREAT DATE)
partition by list (CD_PAYS)
(partition PT_DETAIL_FINANC_DE values ('DE') tablespace USERS,
partition PT_DETAIL_FINANC_ES values ('ES') tablespace USERS,
partition PT_DETAIL_FINANC_FR values ('FR') tablespace USERS,
partition PT_DETAIL_FINANC_IT values ('IT') tablespace USERS,
partition PT_DETAIL_FINANC_DEF values (DEFAULT) tablespace USERS
)
nocache
noparallel
monitoring;
insert into DETAIL_FINANC
(CD_PAYS,ID_APPLI,ID_FINANC,ID_CAR,ID_PROM,TX_PROMO,MNT_TOTAL_FINANC,NBR_MOIS,
TY_PAIEMENT,MNT_MOIS,CD_PRELEV,DT_CREAT)
values( 'FR', '01','fin1', 'car1', 'pr2',15,20000,36,'P',555.55,'P',to_date ('09/04/2006 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
insert into DETAIL_FINANC
(CD_PAYS,ID_APPLI,ID_FINANC,ID_CAR,ID_PROM,TX_PROMO,MNT_TOTAL_FINANC,NBR_MOIS,
TY_PAIEMENT,MNT_MOIS,CD_PRELEV,DT_CREAT)
values( 'FR', '01','fin2', 'car1', 'pr2',15,20000,36,'P',555.55,'P',to_date ('09/04/2006 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
insert into DETAIL_FINANC
(CD_PAYS,ID_APPLI,ID_FINANC,ID_CAR,ID_PROM,TX_PROMO,MNT_TOTAL_FINANC,NBR_MOIS,
TY_PAIEMENT,MNT_MOIS,CD_PRELEV,DT_CREAT)
values( 'DE', '01','fini', 'car1', 'pr2',15,20000,36,'P',555.55,'P',to_date ('09/04/2006 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
COMMIT; |
Partager