DROP TABLE SALES_DTL;
DROP TABLE SALES_MST;
CREATE TABLE SALES_MST
(
  NO     NUMBER(5)                              NOT NULL,
  VDATE  DATE,
  TYPE   VARCHAR2(1)
)
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
NOMONITORING;


ALTER TABLE SALES_MST ADD (
  CONSTRAINT PK_SALES_MST_NO
 PRIMARY KEY
 (NO));

CREATE TABLE SALES_DTL
(
  NO    NUMBER(4),
  CODE  NUMBER(2),
  QTY   NUMBER(3),
  RATE  NUMBER(5,2)
)
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
NOMONITORING;


ALTER TABLE SALES_DTL ADD (
  CONSTRAINT FK_SALES_DTL_NO 
 FOREIGN KEY (NO) 
 REFERENCES SALES_MST (NO));

INSERT INTO SALES_MST
            (NO, vdate, TYPE
            )
     VALUES (1245, TO_DATE ('07-jan-13', 'dd-mon-rr'), 'N'
            );

INSERT INTO SALES_DTL
            (NO, code, qty, rate
            )
     VALUES (1245, 11, 60, 600
            );

INSERT INTO SALES_MST
            (NO, vdate, TYPE
            )
     VALUES (1246, TO_DATE ('07-jan-13', 'dd-mon-rr'), 'N'
            );
INSERT INTO SALES_DTL
            (NO, code, qty, rate
            )
     VALUES (1246, 12, 55, 450
            );
INSERT INTO SALES_DTL
            (NO, code, qty, rate
            )
     VALUES (1246, 11, 45, 600
            );

INSERT INTO SALES_MST
            (NO, vdate, TYPE
            )
     VALUES (1247, TO_DATE ('07-jan-13', 'dd-mon-rr'), 'R'
            );
INSERT INTO SALES_DTL
            (NO, code, qty, rate
            )
     VALUES (1247, 13, 50, 250
            );
INSERT INTO SALES_DTL
            (NO, code, qty, rate
            )
     VALUES (1247, 11, 60, 600
            );

INSERT INTO SALES_MST
            (NO, vdate, TYPE
            )
     VALUES (1248, TO_DATE ('07-jan-13', 'dd-mon-rr'), 'N'
            );
INSERT INTO SALES_DTL
            (NO, code, qty, rate
            )
     VALUES (1248, 11, 45, 600
            );


INSERT INTO SALES_MST
            (NO, vdate, TYPE
            )
     VALUES (1249, TO_DATE ('08-jan-13', 'dd-mon-rr'), 'N'
            );
INSERT INTO SALES_DTL
            (NO, code, qty, rate
            )
     VALUES (1249, 12, 55, 450
            );
INSERT INTO SALES_DTL
            (NO, code, qty, rate
            )
     VALUES (1249, 11, 45, 600
            );

INSERT INTO SALES_MST
            (NO, vdate, TYPE
            )
     VALUES (1250, TO_DATE ('08-jan-13', 'dd-mon-rr'), 'R'
            );
INSERT INTO SALES_DTL
            (NO, code, qty, rate
            )
     VALUES (1250, 18, 41, 250
            );
INSERT INTO SALES_DTL
            (NO, code, qty, rate
            )
     VALUES (1250, 23, 60, 521
            );

INSERT INTO SALES_MST
            (NO, vdate, TYPE
            )
     VALUES (1251, TO_DATE ('08-jan-13', 'dd-mon-rr'), 'N'
            );
INSERT INTO SALES_DTL
            (NO, code, qty, rate
            )
     VALUES (1251, 27, 65, 312
            );

INSERT INTO SALES_MST
            (NO, vdate, TYPE
            )
     VALUES (1252, TO_DATE ('09-jan-13', 'dd-mon-rr'), 'R'
            );
INSERT INTO SALES_DTL
            (NO, code, qty, rate
            )
     VALUES (1252, 18, 41, 250
            );
INSERT INTO SALES_DTL
            (NO, code, qty, rate
            )
     VALUES (1252, 23, 60, 521
            );

INSERT INTO SALES_MST
            (NO, vdate, TYPE
            )
     VALUES (1253, TO_DATE ('09-jan-13', 'dd-mon-rr'), 'N'
            );
INSERT INTO SALES_DTL
            (NO, code, qty, rate
            )
     VALUES (1253, 37, 66, 310
            );
INSERT INTO SALES_MST
            (NO, vdate, TYPE
            )
     VALUES (1254, TO_DATE ('09-jan-13', 'dd-mon-rr'), 'N'
            );
INSERT INTO SALES_DTL
            (NO, code, qty, rate
            )
     VALUES (1254, 32, 95, 112
            );
INSERT INTO SALES_DTL
            (NO, code, qty, rate
            )
     VALUES (1254, 39, 105, 541
            );