-- Create table
create table SEC_MASTER_HISTA
(
  SECURITY_ALIAS NUMBER,
  EFFECTIVE_DATE DATE,
  COUPON         NUMBER,
  FREQ           NUMBER
)
/
-- Create table
create table SEC_MASTER_HISTB
(
  SECURITY_ALIAS NUMBER,
  EFFECTIVE_DATE DATE,
  COUPON         NUMBER,
  FREQ           NUMBER
)
/
-- Create table
create table SECURITY_MASTERA
(
  SECURITY_ALIAS  NUMBER,
  PRIMARY_ASST_ID VARCHAR2(100),
  UPDATE_DATE     DATE
)
/
-- Create table
create table SECURITY_MASTERB
(
  SECURITY_ALIAS  NUMBER,
  PRIMARY_ASST_ID VARCHAR2(100),
  UPDATE_DATE     DATE
)
/
insert into SEC_MASTER_HISTA (SECURITY_ALIAS, EFFECTIVE_DATE, COUPON, FREQ)
values (1353, to_date('04-07-2013', 'dd-mm-yyyy'), 77, 89);

insert into SEC_MASTER_HISTA (SECURITY_ALIAS, EFFECTIVE_DATE, COUPON, FREQ)
values (98342, to_date('06-07-2013', 'dd-mm-yyyy'), 12, 23);

insert into SEC_MASTER_HISTA (SECURITY_ALIAS, EFFECTIVE_DATE, COUPON, FREQ)
values (96452, to_date('02-07-2013', 'dd-mm-yyyy'), 11, 33);

insert into SEC_MASTER_HISTB (SECURITY_ALIAS, EFFECTIVE_DATE, COUPON, FREQ)
values (6754, to_date('06-07-2013', 'dd-mm-yyyy'), 11, 45);

insert into SEC_MASTER_HISTB (SECURITY_ALIAS, EFFECTIVE_DATE, COUPON, FREQ)
values (3217, to_date('09-07-2013', 'dd-mm-yyyy'), 5, 4);

insert into SEC_MASTER_HISTB (SECURITY_ALIAS, EFFECTIVE_DATE, COUPON, FREQ)
values (23456, to_date('10-07-2013', 'dd-mm-yyyy'), 6, 787);

insert into SECURITY_MASTERA (SECURITY_ALIAS, PRIMARY_ASST_ID, UPDATE_DATE)
values (1353, 'HGTYR', to_date('01-07-2013', 'dd-mm-yyyy'));

insert into SECURITY_MASTERA (SECURITY_ALIAS, PRIMARY_ASST_ID, UPDATE_DATE)
values (98342, 'ARRTY', to_date('02-07-2013', 'dd-mm-yyyy'));

insert into SECURITY_MASTERA (SECURITY_ALIAS, PRIMARY_ASST_ID, UPDATE_DATE)
values (96452, 'YUTRU', to_date('02-07-2013', 'dd-mm-yyyy'));

insert into SECURITY_MASTERB (SECURITY_ALIAS, PRIMARY_ASST_ID, UPDATE_DATE)
values (6754, 'HGTYR', to_date('01-07-2013', 'dd-mm-yyyy'));

insert into SECURITY_MASTERB (SECURITY_ALIAS, PRIMARY_ASST_ID, UPDATE_DATE)
values (3217, 'ARRTY', to_date('03-07-2013', 'dd-mm-yyyy'));

insert into SECURITY_MASTERB (SECURITY_ALIAS, PRIMARY_ASST_ID, UPDATE_DATE)
values (23456, 'YUTRU', to_date('02-07-2013', 'dd-mm-yyyy'));