DBS lab 4 (incomplete)

 CREATE TABLE challan_header
  (
     challan_no   VARCHAR2(6) PRIMARY KEY,
     s_order_no   VARCHAR2(6) REFERENCES sales_order(s_order_no),
     challan_date DATE NOT NULL,
     billed_yn    CHAR(1) DEFAULT 'N' CHECK (billed_yn IN ('Y', 'N'))
  );

CREATE TABLE challan_details
  (
     challan_no VARCHAR2(6) REFERENCES challan_header(challan_no),
     product_no VARCHAR2(10) REFERENCES product_master(product_no),
     qty_disp   NUMBER(4, 2) NOT NULL,
     PRIMARY KEY(challan_no, product_no)
  );


INSERT INTO sales_order
            (s_order_no,
             s_order_date,
             client_no,
             dely_type,
             billed_yn,
             salesman_no,
             dely_date,
             order_status)
VALUES     ('046865',
            '20-may-1996',
            '0004',
            'f',
            'y',
            '500002',
            '22-may-1996',
            'canceled');

INSERT INTO sales_order
            (s_order_no,
             s_order_date,
             client_no,
             dely_type,
             billed_yn,
             salesman_no,
             dely_date,
             order_status)
VALUES     ('010008',
            '24-may-1996',
            '0005',
            'f',
            'n',
            '500004',
            '26-may-1996',
            'in process');

INSERT INTO challan_header
VALUES     ('CH9001',
            '019001',
            '12-dec-1995',
            'Y');


INSERT INTO challan_header
VALUES     ('CH865',
            '046865',
            '12-nov-1995',
            'Y');

INSERT INTO challan_header
VALUES     ('CH3965',
            '010008',
            '12-oct-1995',
            'Y');


INSERT ALL

INTO challan_details(challan_no,product_no,qty_disp) VALUES('CH9001', 'P00001', '4')
INTO challan_details(challan_no,product_no,qty_disp) VALUES('CH9001' ,'P07965' ,'1')
INTO challan_details(challan_no,product_no,qty_disp) VALUES('CH9001', 'P07885', '1')
INTO challan_details(challan_no,product_no,qty_disp) VALUES('CH865', 'P07868' ,'3')
INTO challan_details(challan_no,product_no,qty_disp) VALUES('CH865', 'P03453', '4')
INTO challan_details(challan_no,product_no,qty_disp) VALUES('CH865', 'P00001', '10')
INTO challan_details(challan_no,product_no,qty_disp) VALUES('CH3965', 'P00001' ,'5')
INTO challan_details(challan_no,product_no,qty_disp) VALUES('CH3965', 'P07975' ,'2')
SELECT * FROM dual;