CREATE TABLE TMP_CAR_REC ( ID VARCHAR2(10), LIC_NO VARCHAR2(10) ) TABLESPACE MSSU PCTUSED 40 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 1M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) LOGGING NOCACHE NOPARALLEL; SET DEFINE OFF; Insert into TMP_CAR_REC (ID, LIC_NO) Values ('1', 'YM123'); Insert into TMP_CAR_REC (ID, LIC_NO) Values ('2', 'GH234'); Insert into TMP_CAR_REC (ID, LIC_NO) Values ('3', 'XD890'); Insert into TMP_CAR_REC (ID, LIC_NO) Values ('4', 'PA456'); Insert into TMP_CAR_REC (ID, LIC_NO) Values ('5', 'YH789'); Insert into TMP_CAR_REC (ID, LIC_NO) Values ('6', 'GB565'); Insert into TMP_CAR_REC (ID, LIC_NO) Values ('7', 'RD456'); Insert into TMP_CAR_REC (ID, LIC_NO) Values ('8', 'WA111'); Insert into TMP_CAR_REC (ID, LIC_NO) Values ('9', 'WP222'); Insert into TMP_CAR_REC (ID, LIC_NO) Values ('10', 'RU666'); COMMIT; CREATE TABLE TMP_RO_HDR ( CARD_ID VARCHAR2(10), RO_NO VARCHAR2(10), ID VARCHAR2(10) ) TABLESPACE MSSU PCTUSED 40 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 1M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) LOGGING NOCACHE NOPARALLEL; SET DEFINE OFF; Insert into TMP_RO_HDR (CARD_ID, RO_NO, ID) Values ('2', 'RA01', '10'); Insert into TMP_RO_HDR (CARD_ID, RO_NO, ID) Values ('4', 'RA02', '11'); Insert into TMP_RO_HDR (CARD_ID, RO_NO, ID) Values ('6', 'RA03', '12'); Insert into TMP_RO_HDR (CARD_ID, RO_NO, ID) Values ('8', 'RA04', '14'); Insert into TMP_RO_HDR (CARD_ID, RO_NO, ID) Values ('10', 'RA06', '13'); Insert into TMP_RO_HDR (CARD_ID, RO_NO, ID) Values ('5', 'RA05', '15'); COMMIT; CREATE TABLE TMP_RO_JOBS ( ROHD_ID VARCHAR2(10), ID VARCHAR2(10), JOB_CODE VARCHAR2(10) ) TABLESPACE MSSU PCTUSED 40 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 1M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) LOGGING NOCACHE NOPARALLEL; SET DEFINE OFF; Insert into TMP_RO_JOBS (ROHD_ID, ID, JOB_CODE) Values ('10', '21', 'T0102'); Insert into TMP_RO_JOBS (ROHD_ID, ID, JOB_CODE) Values ('10', '22', 'A0101'); Insert into TMP_RO_JOBS (ROHD_ID, ID, JOB_CODE) Values ('10', '23', 'B0103'); Insert into TMP_RO_JOBS (ROHD_ID, ID, JOB_CODE) Values ('11', '24', 'C0101'); Insert into TMP_RO_JOBS (ROHD_ID, ID, JOB_CODE) Values ('11', '25', 'C0102'); Insert into TMP_RO_JOBS (ROHD_ID, ID, JOB_CODE) Values ('12', '26', 'T0103'); Insert into TMP_RO_JOBS (ROHD_ID, ID, JOB_CODE) Values ('13', '27', 'T0104'); Insert into TMP_RO_JOBS (ROHD_ID, ID, JOB_CODE) Values ('13', '28', 'T0100'); Insert into TMP_RO_JOBS (ROHD_ID, ID, JOB_CODE) Values ('14', '29', 'Z0100'); Insert into TMP_RO_JOBS (ROHD_ID, ID, JOB_CODE) Values ('14', '30', 'R0100'); Insert into TMP_RO_JOBS (ROHD_ID, ID, JOB_CODE) Values ('14', '31', 'S0500'); Insert into TMP_RO_JOBS (ROHD_ID, ID, JOB_CODE) Values ('15', '32', 'T0501'); Insert into TMP_RO_JOBS (ROHD_ID, ID, JOB_CODE) Values ('15', '33', 'T0500'); COMMIT;