1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
create table RDT_FS_HISTO_MO
(
C_RMPM_CODE VARCHAR2(18),
C_RATING_AGENCY_ISSUER VARCHAR2(18),
D_RATING_DATE DATE,
C_CURRENT_RATING VARCHAR2(12),
C_CURRENCY_TYPE_CODE VARCHAR2(10),
C_TERM_CODE VARCHAR2(10)
);
insert into RDT_FS_HISTO_MO (C_RMPM_CODE, C_RATING_AGENCY_ISSUER, D_RATING_DATE, C_CURRENT_RATING, C_CURRENCY_TYPE_CODE, C_TERM_CODE)
values (null, '0000002145', to_date('26-07-2002', 'dd-mm-yyyy'), 'A1', 'FC', 'LT');
insert into RDT_FS_HISTO_MO (C_RMPM_CODE, C_RATING_AGENCY_ISSUER, D_RATING_DATE, C_CURRENT_RATING, C_CURRENCY_TYPE_CODE, C_TERM_CODE)
values (null, '0000002145', to_date('22-01-2003', 'dd-mm-yyyy'), 'A3', 'FC', 'LT');
insert into RDT_FS_HISTO_MO (C_RMPM_CODE, C_RATING_AGENCY_ISSUER, D_RATING_DATE, C_CURRENT_RATING, C_CURRENCY_TYPE_CODE, C_TERM_CODE)
values (null, '0000002145', to_date('13-03-2000', 'dd-mm-yyyy'), 'Aa3', 'FC', 'LT');
insert into RDT_FS_HISTO_MO (C_RMPM_CODE, C_RATING_AGENCY_ISSUER, D_RATING_DATE, C_CURRENT_RATING, C_CURRENCY_TYPE_CODE, C_TERM_CODE)
values (null, '0000002145', to_date('17-02-2003', 'dd-mm-yyyy'), 'WR', 'FC', 'LT');
insert into RDT_FS_HISTO_MO (C_RMPM_CODE, C_RATING_AGENCY_ISSUER, D_RATING_DATE, C_CURRENT_RATING, C_CURRENCY_TYPE_CODE, C_TERM_CODE)
values (null, '0000002145', to_date('28-01-1998', 'dd-mm-yyyy'), 'Aa2', 'FC', 'LT');
commit; |
Partager