------------------------------------------------------------------------
-- 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;
