INNER JOIN EXAMPLE

CREATE TABLE HCM.TBLWIPLOTLOG_REPORT ( BASELOTNO VARCHAR2(50 BYTE), LOTNO VARCHAR2(50 BYTE), OPNO VARCHAR2(50 BYTE), GOODQTY NUMBER(10), FAILQTY NUMBER(10), CHECKINTIME DATE, CHECKOUTTIME DATE ); delete from HCM.TBLWIPLOTLOG_REPORT; commit; insert into HCM.TBLWIPLOTLOG_REPORT (BASELOTNO, LOTNO, OPNO, GOODQTY, FAILQTY, CHECKINTIME, CHECKOUTTIME) select to_char(round(dbms_random.value(1,level))), to_char(round(dbms_random.value(1,level))), to_char(round(dbms_random.value(1,level))), round(dbms_random.value(1,level)), round(dbms_random.value(1,level)), sysdate - round( mod(dbms_random.value(1,level),7 ) ), sysdate + round( mod(dbms_random.value(1,level),7 ) ) from dual connect by level <= 10000; CREATE TABLE HCM.TBLWIPLOTBASIS ( BASELOTNO VARCHAR2(50 BYTE), PRODUCTNO VARCHAR2(50 BYTE), INPUTQTY NUMBER(10), PLANFINISHDATE DATE, INPUTUNITNO VARCHAR2(50 BYTE), MONO VARCHAR2(50 BYTE) ); insert into HCM.TBLWIPLOTBASIS (BASELOTNO, PRODUCTNO, INPUTQTY, PLANFINISHDATE, INPUTUNITNO, MONO) select to_char(round(dbms_random.value(1,level))), to_char(round(dbms_random.value(1,level))), round(dbms_random.value(1,level)), sysdate - round( mod(dbms_random.value(1,level),7 ) ), to_char(round(dbms_random.value(1,level))), to_char(round(dbms_random.value(1,level))) from dual connect by level <= 1000;