------------------------------------------------------------------------
-- DISCLAIMER:
--    This script is provided for educational purposes only. It is NOT
--	supported by Oracle World Wide Technical Support.
--    The script has been tested and appears to work as intended.
--	You should always run new scripts on a test instance initially.
--
------------------------------------------------------------------------
SET DEFINE OFF;

CREATE TABLE ITEM
(
  ITEM_ID      NUMBER,
  ITEM_DESCRIPTION  VARCHAR2(100)
)
TABLESPACE OGGDATA
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;


CREATE UNIQUE INDEX ITEM_PK ON ITEM
(ITEM_ID)
LOGGING
TABLESPACE OGGDATA
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;


ALTER TABLE ITEM ADD (
  CONSTRAINT ITEM_PK
  PRIMARY KEY
  (ITEM_ID)
  USING INDEX ITEM_PK);

Insert into ITEM
   (ITEM_ID, ITEM_DESCRIPTION)
 Values
   (1, 'T-shirt plain');
Insert into ITEM
   (ITEM_ID, ITEM_DESCRIPTION)
 Values
   (2, 'T-shirt label "Oracle"');
Insert into ITEM
   (ITEM_ID, ITEM_DESCRIPTION)
 Values
   (3, 'T-shirt label "Oracle RAC"');
Insert into ITEM
   (ITEM_ID, ITEM_DESCRIPTION)
 Values
   (4, 'T-shirt label "SQLDEveloper"');
Insert into ITEM
   (ITEM_ID, ITEM_DESCRIPTION)
 Values
   (5, 'T-shirt label "JDeveloper"');
COMMIT;

[user01@EDLVC3AR5P5 configs]$ more inventory.sql
------------------------------------------------------------------------
-- DISCLAIMER:
--    This script is provided for educational purposes only. It is NOT
--	supported by Oracle World Wide Technical Support.
--    The script has been tested and appears to work as intended.
--	You should always run new scripts on a test instance initially.
--
------------------------------------------------------------------------
CREATE TABLE INVENTORY
(
  ITEM_ID        NUMBER,
  ITEM_SIZE      VARCHAR2(12),
  ITEM_COLOR     VARCHAR2(20),
  ITEM_QUANTITY  NUMBER
)
TABLESPACE OGGDATA
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE UNIQUE INDEX INVENTORY_PK ON INVENTORY
(ITEM_ID, ITEM_SIZE, ITEM_COLOR)
LOGGING
TABLESPACE OGGDATA
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;


ALTER TABLE INVENTORY ADD (
  CONSTRAINT INVENTORY_PK
  PRIMARY KEY
  (ITEM_ID, ITEM_SIZE, ITEM_COLOR)
  USING INDEX INVENTORY_PK);

SET DEFINE OFF;
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, '4XL', 'green', 31);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, 'MEDIUM', 'green', 38);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, 'SMALL', 'green', 40);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, '3XL', 'green', 8);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, '2XL', 'green', 42);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, 'LARGE', 'green', 32);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, '4XL', 'red', 31);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, 'MEDIUM', 'red', 28);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, 'SMALL', 'red', 23);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, '3XL', 'red', 28);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, '2XL', 'red', 41);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, 'LARGE', 'red', 20);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, '4XL', 'blue', 17);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, 'MEDIUM', 'blue', 30);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, 'SMALL', 'blue', 12);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, '3XL', 'blue', 24);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, '2XL', 'blue', 5);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, 'LARGE', 'blue', 21);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, '4XL', 'indigo', 38);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, 'MEDIUM', 'indigo', 21);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, 'SMALL', 'indigo', 29);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, '3XL', 'indigo', 42);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, '2XL', 'indigo', 37);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, 'LARGE', 'indigo', 26);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, '4XL', 'violet', 34);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, 'MEDIUM', 'violet', 36);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, 'SMALL', 'violet', 12);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, '3XL', 'violet', 39);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, '2XL', 'violet', 10);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, 'LARGE', 'violet', 24);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, '4XL', 'yellow', 8);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, 'MEDIUM', 'yellow', 8);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, 'SMALL', 'yellow', 40);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, '3XL', 'yellow', 23);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, '2XL', 'yellow', 31);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, 'LARGE', 'yellow', 27);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, '4XL', 'orange', 15);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, 'MEDIUM', 'orange', 43);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, 'SMALL', 'orange', 24);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, '3XL', 'orange', 36);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, '2XL', 'orange', 11);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (1, 'LARGE', 'orange', 42);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, '4XL', 'green', 34);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, 'MEDIUM', 'green', 8);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, 'SMALL', 'green', 30);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, '3XL', 'green', 42);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, '2XL', 'green', 6);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, 'LARGE', 'green', 10);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, '4XL', 'red', 35);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, 'MEDIUM', 'red', 24);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, 'SMALL', 'red', 8);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, '3XL', 'red', 17);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, '2XL', 'red', 30);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, 'LARGE', 'red', 42);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, '4XL', 'blue', 43);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, 'MEDIUM', 'blue', 42);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, 'SMALL', 'blue', 10);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, '3XL', 'blue', 13);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, '2XL', 'blue', 8);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, 'LARGE', 'blue', 11);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, '4XL', 'indigo', 41);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, 'MEDIUM', 'indigo', 33);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, 'SMALL', 'indigo', 19);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, '3XL', 'indigo', 36);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, '2XL', 'indigo', 26);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, 'LARGE', 'indigo', 35);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, '4XL', 'violet', 33);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, 'MEDIUM', 'violet', 29);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, 'SMALL', 'violet', 35);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, '3XL', 'violet', 18);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, '2XL', 'violet', 17);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, 'LARGE', 'violet', 22);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, '4XL', 'yellow', 21);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, 'MEDIUM', 'yellow', 13);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, 'SMALL', 'yellow', 8);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, '3XL', 'yellow', 6);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, '2XL', 'yellow', 17);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, 'LARGE', 'yellow', 37);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, '4XL', 'orange', 35);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, 'MEDIUM', 'orange', 8);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, 'SMALL', 'orange', 12);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, '3XL', 'orange', 21);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, '2XL', 'orange', 29);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (2, 'LARGE', 'orange', 40);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, '4XL', 'green', 35);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, 'MEDIUM', 'green', 12);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, 'SMALL', 'green', 19);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, '3XL', 'green', 38);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, '2XL', 'green', 18);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, 'LARGE', 'green', 13);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, '4XL', 'red', 11);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, 'MEDIUM', 'red', 30);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, 'SMALL', 'red', 6);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, '3XL', 'red', 5);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, '2XL', 'red', 28);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, 'LARGE', 'red', 16);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, '4XL', 'blue', 26);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, 'MEDIUM', 'blue', 42);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, 'SMALL', 'blue', 34);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, '3XL', 'blue', 37);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, '2XL', 'blue', 26);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, 'LARGE', 'blue', 16);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, '4XL', 'indigo', 30);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, 'MEDIUM', 'indigo', 15);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, 'SMALL', 'indigo', 40);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, '3XL', 'indigo', 18);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, '2XL', 'indigo', 18);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, 'LARGE', 'indigo', 31);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, '4XL', 'violet', 28);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, 'MEDIUM', 'violet', 37);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, 'SMALL', 'violet', 14);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, '3XL', 'violet', 17);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, '2XL', 'violet', 36);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, 'LARGE', 'violet', 19);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, '4XL', 'yellow', 42);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, 'MEDIUM', 'yellow', 29);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, 'SMALL', 'yellow', 10);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, '3XL', 'yellow', 31);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, '2XL', 'yellow', 12);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, 'LARGE', 'yellow', 30);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, '4XL', 'orange', 7);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, 'MEDIUM', 'orange', 37);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, 'SMALL', 'orange', 23);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, '3XL', 'orange', 35);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, '2XL', 'orange', 20);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (3, 'LARGE', 'orange', 14);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, '4XL', 'green', 41);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, 'MEDIUM', 'green', 41);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, 'SMALL', 'green', 33);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, '3XL', 'green', 9);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, '2XL', 'green', 37);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, 'LARGE', 'green', 17);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, '4XL', 'red', 32);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, 'MEDIUM', 'red', 32);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, 'SMALL', 'red', 38);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, '3XL', 'red', 35);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, '2XL', 'red', 9);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, 'LARGE', 'red', 35);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, '4XL', 'blue', 9);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, 'MEDIUM', 'blue', 37);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, 'SMALL', 'blue', 43);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, '3XL', 'blue', 25);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, '2XL', 'blue', 12);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, 'LARGE', 'blue', 37);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, '4XL', 'indigo', 21);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, 'MEDIUM', 'indigo', 29);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, 'SMALL', 'indigo', 31);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, '3XL', 'indigo', 22);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, '2XL', 'indigo', 15);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, 'LARGE', 'indigo', 11);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, '4XL', 'violet', 30);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, 'MEDIUM', 'violet', 30);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, 'SMALL', 'violet', 37);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, '3XL', 'violet', 32);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, '2XL', 'violet', 8);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, 'LARGE', 'violet', 42);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, '4XL', 'yellow', 15);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, 'MEDIUM', 'yellow', 7);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, 'SMALL', 'yellow', 28);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, '3XL', 'yellow', 39);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, '2XL', 'yellow', 9);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, 'LARGE', 'yellow', 16);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, '4XL', 'orange', 20);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, 'MEDIUM', 'orange', 27);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, 'SMALL', 'orange', 39);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, '3XL', 'orange', 34);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, '2XL', 'orange', 28);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (4, 'LARGE', 'orange', 18);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, '4XL', 'green', 15);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, 'MEDIUM', 'green', 29);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, 'SMALL', 'green', 43);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, '3XL', 'green', 20);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, '2XL', 'green', 29);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, 'LARGE', 'green', 43);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, '4XL', 'red', 13);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, 'MEDIUM', 'red', 21);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, 'SMALL', 'red', 27);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, '3XL', 'red', 28);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, '2XL', 'red', 14);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, 'LARGE', 'red', 10);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, '4XL', 'blue', 18);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, 'MEDIUM', 'blue', 5);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, 'SMALL', 'blue', 15);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, '3XL', 'blue', 10);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, '2XL', 'blue', 8);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, 'LARGE', 'blue', 11);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, '4XL', 'indigo', 37);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, 'MEDIUM', 'indigo', 35);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, 'SMALL', 'indigo', 28);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, '3XL', 'indigo', 7);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, '2XL', 'indigo', 9);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, 'LARGE', 'indigo', 10);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, '4XL', 'violet', 24);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, 'MEDIUM', 'violet', 6);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, 'SMALL', 'violet', 33);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, '3XL', 'violet', 11);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, '2XL', 'violet', 26);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, 'LARGE', 'violet', 7);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, '4XL', 'yellow', 16);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, 'MEDIUM', 'yellow', 19);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, 'SMALL', 'yellow', 29);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, '3XL', 'yellow', 25);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, '2XL', 'yellow', 16);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, 'LARGE', 'yellow', 37);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, '4XL', 'orange', 5);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, 'MEDIUM', 'orange', 33);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, 'SMALL', 'orange', 8);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, '3XL', 'orange', 17);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, '2XL', 'orange', 14);
Insert into INVENTORY
   (ITEM_ID, ITEM_SIZE, ITEM_COLOR, ITEM_QUANTITY)
 Values
   (5, 'LARGE', 'orange', 14);
COMMIT;


