How to Populate the Dimensional Model ?

sql, database, queries

Populate the Dimensional Model

design and develop the programs that are required to extract the data from the production data (which you have loaded into your schema) and populate the Sales Dimensional Model that you designed. This is part of the overall ETL process. The E (Extract) has already been done for you. What you need to do is to define all the data mappings, translations, transformations, etc. required to Load the data into the Dimensional model. You will need to aggregate the data up to a daily level in addition to the other dimensions you have defined

You are required to produce the following:

  • Diagram showing the data flows and processes/programs
  • Program specifications
  • Explanations of all design decisions, translations, transformations, etc.
  • Fully developed programs
  • Details of all testing

 

All programming should be done in SQL and/or PL/SQL.

The codes must be run in Oracle SQL Developer

After that, perform a data quality assessment of the ETL process to ensure that the process is working correctly, all the data is being transferred and all data that is generated and aggregated into the dimensional model. Investigate and analyze the data and write a short report of the steps you have completed and what you can report on these steps.

The dimensional model that you need to populate:

 

Solution:

Channels_Data_Initial.sql

Insert into CHANNELS (CHANNEL_ID,CHANNEL_DESC,CHANNEL_CLASS,CHANNEL_CLASS_ID,CHANNEL_TOTAL,CHANNEL_TOTAL_ID) values (3,’Direct Sales’,’Direct’,12,’Channel total’,1);
Insert into CHANNELS (CHANNEL_ID,CHANNEL_DESC,CHANNEL_CLASS,CHANNEL_CLASS_ID,CHANNEL_TOTAL,CHANNEL_TOTAL_ID) values (9,’Tele Sales’,’Direct’,12,’Channel total’,1);
Insert into CHANNELS (CHANNEL_ID,CHANNEL_DESC,CHANNEL_CLASS,CHANNEL_CLASS_ID,CHANNEL_TOTAL,CHANNEL_TOTAL_ID) values (5,’Catalog’,’Indirect’,13,’Channel total’,1);
Insert into CHANNELS (CHANNEL_ID,CHANNEL_DESC,CHANNEL_CLASS,CHANNEL_CLASS_ID,CHANNEL_TOTAL,CHANNEL_TOTAL_ID) values (4,’Internet’,’Indirect’,13,’Channel total’,1);
Insert into CHANNELS (CHANNEL_ID,CHANNEL_DESC,CHANNEL_CLASS,CHANNEL_CLASS_ID,CHANNEL_TOTAL,CHANNEL_TOTAL_ID) values (2,’Partners’,’Others’,14,’Channel total’,1);

Countries_Data_Initial.sql

Insert into COUNTRIES (COUNTRY_ID,COUNTRY_ISO_CODE,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_SUBREGION_ID,COUNTRY_REGION,COUNTRY_REGION_ID,COUNTRY_TOTAL,COUNTRY_TOTAL_ID,COUNTRY_NAME_HIST) values (52790,’US’,’United States of America’,’Northern America’,52797,’Americas’,52801,’World total’,52806,null);
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_ISO_CODE,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_SUBREGION_ID,COUNTRY_REGION,COUNTRY_REGION_ID,COUNTRY_TOTAL,COUNTRY_TOTAL_ID,COUNTRY_NAME_HIST) values (52776,’DE’,’Germany’,’Western Europe’,52799,’Europe’,52803,’World total’,52806,null);
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_ISO_CODE,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_SUBREGION_ID,COUNTRY_REGION,COUNTRY_REGION_ID,COUNTRY_TOTAL,COUNTRY_TOTAL_ID,COUNTRY_NAME_HIST) values (52789,’GB’,’United Kingdom’,’Western Europe’,52799,’Europe’,52803,’World total’,52806,null);
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_ISO_CODE,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_SUBREGION_ID,COUNTRY_REGION,COUNTRY_REGION_ID,COUNTRY_TOTAL,COUNTRY_TOTAL_ID,COUNTRY_NAME_HIST) values (52784,’NL’,’The Netherlands’,’Western Europe’,52799,’Europe’,52803,’World total’,52806,null);
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_ISO_CODE,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_SUBREGION_ID,COUNTRY_REGION,COUNTRY_REGION_ID,COUNTRY_TOTAL,COUNTRY_TOTAL_ID,COUNTRY_NAME_HIST) values (52780,’IE’,’Ireland’,’Western Europe’,52799,’Europe’,52803,’World total’,52806,null);
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_ISO_CODE,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_SUBREGION_ID,COUNTRY_REGION,COUNTRY_REGION_ID,COUNTRY_TOTAL,COUNTRY_TOTAL_ID,COUNTRY_NAME_HIST) values (52777,’DK’,’Denmark’,’Western Europe’,52799,’Europe’,52803,’World total’,52806,null);
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_ISO_CODE,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_SUBREGION_ID,COUNTRY_REGION,COUNTRY_REGION_ID,COUNTRY_TOTAL,COUNTRY_TOTAL_ID,COUNTRY_NAME_HIST) values (52779,’FR’,’France’,’Western Europe’,52799,’Europe’,52803,’World total’,52806,null);
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_ISO_CODE,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_SUBREGION_ID,COUNTRY_REGION,COUNTRY_REGION_ID,COUNTRY_TOTAL,COUNTRY_TOTAL_ID,COUNTRY_NAME_HIST) values (52778,’ES’,’Spain’,’Western Europe’,52799,’Europe’,52803,’World total’,52806,null);
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_ISO_CODE,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_SUBREGION_ID,COUNTRY_REGION,COUNTRY_REGION_ID,COUNTRY_TOTAL,COUNTRY_TOTAL_ID,COUNTRY_NAME_HIST) values (52788,’TR’,’Turkey’,’Western Europe’,52799,’Europe’,52803,’World total’,52806,null);
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_ISO_CODE,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_SUBREGION_ID,COUNTRY_REGION,COUNTRY_REGION_ID,COUNTRY_TOTAL,COUNTRY_TOTAL_ID,COUNTRY_NAME_HIST) values (52786,’PL’,’Poland’,’Eastern Europe’,52795,’Europe’,52803,’World total’,52806,null);
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_ISO_CODE,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_SUBREGION_ID,COUNTRY_REGION,COUNTRY_REGION_ID,COUNTRY_TOTAL,COUNTRY_TOTAL_ID,COUNTRY_NAME_HIST) values (52775,’BR’,’Brazil’,’Southern America’,52798,’Americas’,52801,’World total’,52806,null);
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_ISO_CODE,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_SUBREGION_ID,COUNTRY_REGION,COUNTRY_REGION_ID,COUNTRY_TOTAL,COUNTRY_TOTAL_ID,COUNTRY_NAME_HIST) values (52773,’AR’,’Argentina’,’Southern America’,52798,’Americas’,52801,’World total’,52806,null);
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_ISO_CODE,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_SUBREGION_ID,COUNTRY_REGION,COUNTRY_REGION_ID,COUNTRY_TOTAL,COUNTRY_TOTAL_ID,COUNTRY_NAME_HIST) values (52783,’MY’,’Malaysia’,’Asia’,52793,’Asia’,52802,’World total’,52806,null);
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_ISO_CODE,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_SUBREGION_ID,COUNTRY_REGION,COUNTRY_REGION_ID,COUNTRY_TOTAL,COUNTRY_TOTAL_ID,COUNTRY_NAME_HIST) values (52782,’JP’,’Japan’,’Asia’,52793,’Asia’,52802,’World total’,52806,null);
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_ISO_CODE,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_SUBREGION_ID,COUNTRY_REGION,COUNTRY_REGION_ID,COUNTRY_TOTAL,COUNTRY_TOTAL_ID,COUNTRY_NAME_HIST) values (52781,’IN’,’India’,’Asia’,52793,’Asia’,52802,’World total’,52806,null);
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_ISO_CODE,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_SUBREGION_ID,COUNTRY_REGION,COUNTRY_REGION_ID,COUNTRY_TOTAL,COUNTRY_TOTAL_ID,COUNTRY_NAME_HIST) values (52774,’AU’,’Australia’,’Australia’,52794,’Oceania’,52805,’World total’,52806,null);
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_ISO_CODE,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_SUBREGION_ID,COUNTRY_REGION,COUNTRY_REGION_ID,COUNTRY_TOTAL,COUNTRY_TOTAL_ID,COUNTRY_NAME_HIST) values (52785,’NZ’,’New Zealand’,’Australia’,52794,’Oceania’,52805,’World total’,52806,null);
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_ISO_CODE,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_SUBREGION_ID,COUNTRY_REGION,COUNTRY_REGION_ID,COUNTRY_TOTAL,COUNTRY_TOTAL_ID,COUNTRY_NAME_HIST) values (52791,’ZA’,’South Africa’,’Africa’,52792,’Africa’,52800,’World total’,52806,null);
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_ISO_CODE,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_SUBREGION_ID,COUNTRY_REGION,COUNTRY_REGION_ID,COUNTRY_TOTAL,COUNTRY_TOTAL_ID,COUNTRY_NAME_HIST) values (52787,’SA’,’Saudi Arabia’,’Middle East’,52796,’Middle East’,52804,’World total’,52806,null);
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_ISO_CODE,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_SUBREGION_ID,COUNTRY_REGION,COUNTRY_REGION_ID,COUNTRY_TOTAL,COUNTRY_TOTAL_ID,COUNTRY_NAME_HIST) values (52772,’CA’,’Canada’,’Northern America’,52797,’Americas’,52801,’World total’,52806,null);
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_ISO_CODE,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_SUBREGION_ID,COUNTRY_REGION,COUNTRY_REGION_ID,COUNTRY_TOTAL,COUNTRY_TOTAL_ID,COUNTRY_NAME_HIST) values (52771,’CN’,’China’,’Asia’,52793,’Asia’,52802,’World total’,52806,null);
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_ISO_CODE,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_SUBREGION_ID,COUNTRY_REGION,COUNTRY_REGION_ID,COUNTRY_TOTAL,COUNTRY_TOTAL_ID,COUNTRY_NAME_HIST) values (52769,’SG’,’Singapore’,’Asia’,52793,’Asia’,52802,’World total’,52806,null);
Insert into COUNTRIES (COUNTRY_ID,COUNTRY_ISO_CODE,COUNTRY_NAME,COUNTRY_SUBREGION,COUNTRY_SUBREGION_ID,COUNTRY_REGION,COUNTRY_REGION_ID,COUNTRY_TOTAL,COUNTRY_TOTAL_ID,COUNTRY_NAME_HIST) values (52770,’IT’,’Italy’,’Western Europe’,52799,’Europe’,52803,’World total’,52806,null);

Create_tables.sql

drop table sales;
drop table products;

CREATE TABLE PRODUCTS
(
PROD_ID               NUMBER(6,0) NOT NULL ENABLE,
PROD_NAME             VARCHAR2(50 BYTE) NOT NULL ENABLE,
PROD_DESC             VARCHAR2(4000 BYTE) NOT NULL ENABLE,
PROD_SUBCATEGORY      VARCHAR2(50 BYTE) NOT NULL ENABLE,
PROD_SUBCATEGORY_ID   NUMBER NOT NULL ENABLE,
PROD_SUBCATEGORY_DESC VARCHAR2(2000 BYTE) NOT NULL ENABLE,
PROD_CATEGORY         VARCHAR2(50 BYTE) NOT NULL ENABLE,
PROD_CATEGORY_ID      NUMBER NOT NULL ENABLE,
PROD_CATEGORY_DESC    VARCHAR2(2000 BYTE) NOT NULL ENABLE,
PROD_WEIGHT_CLASS     NUMBER(3,0) NOT NULL ENABLE,
PROD_UNIT_OF_MEASURE  VARCHAR2(20 BYTE),
PROD_PACK_SIZE        VARCHAR2(30 BYTE) NOT NULL ENABLE,
SUPPLIER_ID           NUMBER(6,0) NOT NULL ENABLE,
PROD_STATUS           VARCHAR2(20 BYTE) NOT NULL ENABLE,
PROD_LIST_PRICE       NUMBER(8,2) NOT NULL ENABLE,
PROD_MIN_PRICE        NUMBER(8,2) NOT NULL ENABLE,
PROD_TOTAL            VARCHAR2(13 BYTE) NOT NULL ENABLE,
PROD_TOTAL_ID         NUMBER NOT NULL ENABLE,
PROD_SRC_ID           NUMBER,
PROD_EFF_FROM DATE,
PROD_EFF_TO DATE,
PROD_VALID VARCHAR2(1 BYTE),
CONSTRAINT PRODUCTS_PK PRIMARY KEY (PROD_ID) USING INDEX );

CREATE INDEX PRODUCTS_PROD_SUBCAT_IX ON PRODUCTS
(
PROD_SUBCATEGORY
);

CREATE INDEX PRODUCTS_PROD_CAT_IX ON PRODUCTS
(
PROD_CATEGORY
);

CREATE BITMAP INDEX PRODUCTS_PROD_STATUS_BIX ON PRODUCTS
(
PROD_STATUS
);

drop table promotions;

CREATE TABLE PROMOTIONS
(
PROMO_ID             NUMBER(6,0) NOT NULL ENABLE,
PROMO_NAME           VARCHAR2(30 BYTE) NOT NULL ENABLE,
PROMO_SUBCATEGORY    VARCHAR2(30 BYTE) NOT NULL ENABLE,
PROMO_SUBCATEGORY_ID NUMBER NOT NULL ENABLE,
PROMO_CATEGORY       VARCHAR2(30 BYTE) NOT NULL ENABLE,
PROMO_CATEGORY_ID    NUMBER NOT NULL ENABLE,
PROMO_COST           NUMBER(10,2) NOT NULL ENABLE,
PROMO_BEGIN_DATE DATE NOT NULL ENABLE,
PROMO_END_DATE DATE NOT NULL ENABLE,
PROMO_TOTAL    VARCHAR2(15 BYTE) NOT NULL ENABLE,
PROMO_TOTAL_ID NUMBER NOT NULL ENABLE,
CONSTRAINT PROMO_PK PRIMARY KEY (PROMO_ID) USING INDEX );

drop table channels;

CREATE TABLE CHANNELS
(
CHANNEL_ID       NUMBER NOT NULL ENABLE,
CHANNEL_DESC     VARCHAR2(20 BYTE) NOT NULL ENABLE,
CHANNEL_CLASS    VARCHAR2(20 BYTE) NOT NULL ENABLE,
CHANNEL_CLASS_ID NUMBER NOT NULL ENABLE,
CHANNEL_TOTAL    VARCHAR2(13 BYTE) NOT NULL ENABLE,
CHANNEL_TOTAL_ID NUMBER NOT NULL ENABLE,
CONSTRAINT CHANNELS_PK PRIMARY KEY (CHANNEL_ID) USING INDEX );

drop table countries;

CREATE TABLE COUNTRIES
(
COUNTRY_ID           NUMBER NOT NULL ENABLE,
COUNTRY_ISO_CODE     CHAR(2 BYTE) NOT NULL ENABLE,
COUNTRY_NAME         VARCHAR2(40 BYTE) NOT NULL ENABLE,
COUNTRY_SUBREGION    VARCHAR2(30 BYTE) NOT NULL ENABLE,
COUNTRY_SUBREGION_ID NUMBER NOT NULL ENABLE,
COUNTRY_REGION       VARCHAR2(20 BYTE) NOT NULL ENABLE,
COUNTRY_REGION_ID    NUMBER NOT NULL ENABLE,
COUNTRY_TOTAL        VARCHAR2(11 BYTE) NOT NULL ENABLE,
COUNTRY_TOTAL_ID     NUMBER NOT NULL ENABLE,
COUNTRY_NAME_HIST    VARCHAR2(40 BYTE),
CONSTRAINT COUNTRIES_PK PRIMARY KEY (COUNTRY_ID) USING INDEX );

drop table customers;

CREATE TABLE CUSTOMERS
(
CUST_ID                NUMBER NOT NULL ENABLE,
CUST_FIRST_NAME        VARCHAR2(20 BYTE) NOT NULL ENABLE,
CUST_LAST_NAME         VARCHAR2(40 BYTE) NOT NULL ENABLE,
CUST_GENDER            CHAR(1 BYTE) NOT NULL ENABLE,
CUST_YEAR_OF_BIRTH     NUMBER(4,0) NOT NULL ENABLE,
CUST_MARITAL_STATUS    VARCHAR2(20 BYTE),
CUST_STREET_ADDRESS    VARCHAR2(40 BYTE) NOT NULL ENABLE,
CUST_POSTAL_CODE       VARCHAR2(10 BYTE) NOT NULL ENABLE,
CUST_CITY              VARCHAR2(30 BYTE) NOT NULL ENABLE,
CUST_CITY_ID           NUMBER NOT NULL ENABLE,
CUST_STATE_PROVINCE    VARCHAR2(40 BYTE) NOT NULL ENABLE,
CUST_STATE_PROVINCE_ID NUMBER NOT NULL ENABLE,
COUNTRY_ID             NUMBER NOT NULL ENABLE,
CUST_MAIN_PHONE_NUMBER VARCHAR2(25 BYTE) NOT NULL ENABLE,
CUST_INCOME_LEVEL      VARCHAR2(30 BYTE),
CUST_CREDIT_LIMIT      NUMBER,
CUST_EMAIL             VARCHAR2(30 BYTE),
CUST_TOTAL             VARCHAR2(14 BYTE) NOT NULL ENABLE,
CUST_TOTAL_ID          NUMBER NOT NULL ENABLE,
CUST_SRC_ID            NUMBER,
CUST_EFF_FROM DATE,
CUST_EFF_TO DATE,
CUST_VALID VARCHAR2(1 BYTE),
CONSTRAINT CUSTOMERS_PK PRIMARY KEY (CUST_ID) USING INDEX );

CREATE BITMAP INDEX CUSTOMERS_GENDER_BIX ON CUSTOMERS
(
CUST_GENDER
);

CREATE BITMAP INDEX CUSTOMERS_MARITAL_BIX ON CUSTOMERS
(
CUST_MARITAL_STATUS
);

CREATE BITMAP INDEX CUSTOMERS_YOB_BIX ON CUSTOMERS
(
CUST_YEAR_OF_BIRTH
);

CREATE TABLE SALES
(
PROD_ID NUMBER NOT NULL ENABLE,
CUST_ID NUMBER NOT NULL ENABLE,
TIME_ID DATE NOT NULL ENABLE,
CHANNEL_ID    NUMBER NOT NULL ENABLE,
PROMO_ID      NUMBER NOT NULL ENABLE,
QUANTITY_SOLD NUMBER(10,2) NOT NULL ENABLE,
AMOUNT_SOLD   NUMBER(10,2) NOT NULL ENABLE,
CONSTRAINT SALES_CHANNEL_FK FOREIGN KEY (CHANNEL_ID) REFERENCES CHANNELS (CHANNEL_ID) ENABLE NOVALIDATE,
CONSTRAINT SALES_PRODUCT_FK FOREIGN KEY (PROD_ID) REFERENCES PRODUCTS (PROD_ID) ENABLE NOVALIDATE,
CONSTRAINT SALES_CUSTOMER_FK FOREIGN KEY (CUST_ID) REFERENCES CUSTOMERS (CUST_ID) ENABLE NOVALIDATE,
CONSTRAINT SALES_PROMO_FK FOREIGN KEY (PROMO_ID) REFERENCES PROMOTIONS (PROMO_ID) ENABLE NOVALIDATE
);

Product_Data_Initial.sql

Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (13,’5MP Telephoto Digital Camera’,’5MP Telephoto Digital Camera’,’Cameras’,2044,’Cameras’,’Photo’,204,’Photo’,1,’U’,’P’,1,’STATUS’,899.99,899.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (14,’17” LCD w/built-in HDTV Tuner’,’17” LCD w/built-in HDTV Tuner’,’Monitors’,2035,’Monitors’,’Peripherals and Accessories’,203,’Peripherals and Accessories’,1,’U’,’P’,1,’STATUS’,999.99,999.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (15,’Envoy 256MB – 40GB’,’Envoy 256MB – 40Gb’,’Desktop PCs’,2021,’Desktop PCs’,’Hardware’,202,’Hardware’,1,’U’,’P’,1,’STATUS’,999.99,999.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (16,’Y Box’,’Y Box’,’Game Consoles’,2011,’Game Consoles’,’Electronics’,201,’Electronics’,1,’U’,’P’,1,’STATUS’,299.99,299.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (17,’Mini DV Camcorder with 3.5″ Swivel LCD’,’Mini DV Camcorder with 3.5″ Swivel LCD’,’Camcorders’,2041,’Camcorders’,’Photo’,204,’Photo’,1,’U’,’P’,1,’STATUS’,1099.99,1099.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (18,’Envoy Ambassador’,’Envoy Ambassador’,’Portable PCs’,2022,’Portable PCs’,’Hardware’,202,’Hardware’,1,’U’,’P’,1,’STATUS’,1299.99,1299.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (19,’Laptop carrying case’,’Laptop carrying case’,’Accessories’,2051,’Accessories’,’Software/Other’,205,’Software/Other’,1,’U’,’P’,1,’STATUS’,55.99,55.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (20,’Home Theatre Package with DVD-Audio/Video Play’,’Home Theatre Package with DVD-Audio/Video Play’,’Home Audio’,2012,’Home Audio’,’Electronics’,201,’Electronics’,1,’U’,’P’,1,’STATUS’,599.99,599.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (21,’18” Flat Panel Graphics Monitor’,’18” Flat Panel Graphics Monitor’,’Monitors’,2035,’Monitors’,’Peripherals and Accessories’,203,’Peripherals and Accessories’,1,’U’,’P’,1,’STATUS’,899.99,899.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (22,’Envoy External Keyboard’,’Envoy External Keyboard’,’Accessories’,2031,’Accessories’,’Peripherals and Accessories’,203,’Peripherals and Accessories’,1,’U’,’P’,1,’STATUS’,24.99,24.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (23,’External 101-key keyboard’,’External 101-key keyboard’,’Accessories’,2051,’Accessories’,’Software/Other’,205,’Software/Other’,1,’U’,’P’,1,’STATUS’,21.99,21.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (24,’PCMCIA modem/fax 28800 baud’,’PCMCIA modem/fax 28800 baud’,’Modems/Fax’,2034,’Modems/Fax’,’Peripherals and Accessories’,203,’Peripherals and Accessories’,1,’U’,’P’,1,’STATUS’,45.99,45.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (25,’SIMM- 8MB PCMCIAII card’,’SIMM- 8MB PCMCIAII card’,’Memory’,2033,’Memory’,’Peripherals and Accessories’,203,’Peripherals and Accessories’,1,’U’,’P’,1,’STATUS’,112.99,112.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (26,’SIMM- 16MB PCMCIAII card’,’SIMM- 16MB PCMCIAII card’,’Memory’,2033,’Memory’,’Peripherals and Accessories’,203,’Peripherals and Accessories’,1,’U’,’P’,1,’STATUS’,149.99,149.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (27,’Multimedia speakers- 3″ cones’,’Multimedia speakers- 3″ cones’,’Accessories’,2031,’Accessories’,’Peripherals and Accessories’,203,’Peripherals and Accessories’,1,’U’,’P’,1,’STATUS’,44.99,44.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (28,’Unix/Windows 1-user pack’,’Unix/Windows 1-user pack’,’Operating Systems’,2052,’Operating Systems’,’Software/Other’,205,’Software/Other’,1,’U’,’P’,1,’STATUS’,199.99,199.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (29,’8.3 Minitower Speaker’,’8.3 Minitower Speaker’,’Home Audio’,2012,’Home Audio’,’Electronics’,201,’Electronics’,1,’U’,’P’,1,’STATUS’,499.99,499.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (30,’Mouse Pad’,’Mouse Pad’,’Accessories’,2051,’Accessories’,’Software/Other’,205,’Software/Other’,1,’U’,’P’,1,’STATUS’,9.99,9.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (31,’1.44MB External 3.5″ Diskette’,’1.44MB External 3.5″ Diskette’,’Accessories’,2051,’Accessories’,’Software/Other’,205,’Software/Other’,1,’U’,’P’,1,’STATUS’,8.99,8.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (32,’Multimedia speakers- 5″ cones’,’Multimedia speakers- 5″ cones’,’Accessories’,2031,’Accessories’,’Peripherals and Accessories’,203,’Peripherals and Accessories’,1,’U’,’P’,1,’STATUS’,67.99,67.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (33,’PCMCIA modem/fax 19200 baud’,’PCMCIA modem/fax 19200 baud’,’Modems/Fax’,2034,’Modems/Fax’,’Peripherals and Accessories’,203,’Peripherals and Accessories’,1,’U’,’P’,1,’STATUS’,44.99,44.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (34,’External 6X CD-ROM’,’External 6X CD-ROM’,’CD-ROM’,2032,’CD-ROM’,’Peripherals and Accessories’,203,’Peripherals and Accessories’,1,’U’,’P’,1,’STATUS’,39.99,39.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (35,’External 8X CD-ROM’,’External 8X CD-ROM’,’CD-ROM’,2032,’CD-ROM’,’Peripherals and Accessories’,203,’Peripherals and Accessories’,1,’U’,’P’,1,’STATUS’,49.99,49.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (36,’Envoy External 6X CD-ROM’,’Envoy External 6X CD-ROM’,’CD-ROM’,2032,’CD-ROM’,’Peripherals and Accessories’,203,’Peripherals and Accessories’,1,’U’,’P’,1,’STATUS’,44.99,44.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (37,’Envoy External 8X CD-ROM’,’Envoy External 8X CD-ROM’,’CD-ROM’,2032,’CD-ROM’,’Peripherals and Accessories’,203,’Peripherals and Accessories’,1,’U’,’P’,1,’STATUS’,54.99,54.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (38,’Internal 6X CD-ROM’,’Internal 6X CD-ROM’,’CD-ROM’,2032,’CD-ROM’,’Peripherals and Accessories’,203,’Peripherals and Accessories’,1,’U’,’P’,1,’STATUS’,29.99,29.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (39,’Internal 8X CD-ROM’,’Internal 8X CD-ROM’,’CD-ROM’,2032,’CD-ROM’,’Peripherals and Accessories’,203,’Peripherals and Accessories’,1,’U’,’P’,1,’STATUS’,34.99,34.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (40,’O/S Documentation Set – English’,’O/S Documentation Set – English’,’Documentation’,2054,’Documentation’,’Software/Other’,205,’Software/Other’,1,’U’,’P’,1,’STATUS’,44.99,44.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (41,’O/S Documentation Set – German’,’O/S Documentation Set – German’,’Documentation’,2054,’Documentation’,’Software/Other’,205,’Software/Other’,1,’U’,’P’,1,’STATUS’,44.99,44.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (42,’O/S Documentation Set – French’,’O/S Documentation Set – French’,’Documentation’,2054,’Documentation’,’Software/Other’,205,’Software/Other’,1,’U’,’P’,1,’STATUS’,44.99,44.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (43,’O/S Documentation Set – Spanish’,’O/S Documentation Set – Spanish’,’Documentation’,2054,’Documentation’,’Software/Other’,205,’Software/Other’,1,’U’,’P’,1,’STATUS’,44.99,44.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (44,’O/S Documentation Set – Italian’,’O/S Documentation Set – Italian’,’Documentation’,2054,’Documentation’,’Software/Other’,205,’Software/Other’,1,’U’,’P’,1,’STATUS’,44.99,44.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (45,’O/S Documentation Set – Kanji’,’O/S Documentation Set – Kanji’,’Documentation’,2054,’Documentation’,’Software/Other’,205,’Software/Other’,1,’U’,’P’,1,’STATUS’,44.99,44.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (46,’Standard Mouse’,’Standard Mouse’,’Accessories’,2031,’Accessories’,’Peripherals and Accessories’,203,’Peripherals and Accessories’,1,’U’,’P’,1,’STATUS’,22.99,22.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (47,’Deluxe Mouse’,’Deluxe Mouse’,’Accessories’,2031,’Accessories’,’Peripherals and Accessories’,203,’Peripherals and Accessories’,1,’U’,’P’,1,’STATUS’,28.99,28.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (48,’Keyboard Wrist Rest’,’Keyboard Wrist Rest’,’Accessories’,2051,’Accessories’,’Software/Other’,205,’Software/Other’,1,’U’,’P’,1,’STATUS’,11.99,11.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (113,’CD-R Mini Discs’,’CD-R Mini Discs with Jewel Case, 185MB, Pack of 5′,’Recordable CDs’,2055,’Recordable CDs’,’Software/Other’,205,’Software/Other’,1,’U’,’P’,1,’STATUS’,22.99,22.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (114,’Music CD-R’,’Music CD-R with Spindle, 700MB, Pack of 30′,’Recordable CDs’,2055,’Recordable CDs’,’Software/Other’,205,’Software/Other’,1,’U’,’P’,1,’STATUS’,18.99,18.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (115,’CD-RW, High Speed, Pack of 10′,’CD-RW, High Speed, Pack of 10′,’Recordable CDs’,2055,’Recordable CDs’,’Software/Other’,205,’Software/Other’,1,’U’,’P’,1,’STATUS’,8.99,8.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (116,’CD-RW, High Speed Pack of 5′,’CD-RW, High Speed 650MB/74 Minutes, Pack of 5′,’Recordable CDs’,2055,’Recordable CDs’,’Software/Other’,205,’Software/Other’,1,’U’,’P’,1,’STATUS’,11.99,11.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (117,’CD-R, Professional Grade, Pack of 10′,’CD-R, Professional Grade, Pack of 10′,’Recordable CDs’,2055,’Recordable CDs’,’Software/Other’,205,’Software/Other’,1,’U’,’P’,1,’STATUS’,8.99,8.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (118,’OraMusic CD-R, Pack of 10′,’OraMusic CD-R, Pack of 10′,’Recordable CDs’,2055,’Recordable CDs’,’Software/Other’,205,’Software/Other’,1,’U’,’P’,1,’STATUS’,7.99,7.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (119,’CD-R with Jewel Cases, pACK OF 12′,’CD-R with Jewel Cases, 700MB/80 Minutes, Pack of 12′,’Recordable CDs’,2055,’Recordable CDs’,’Software/Other’,205,’Software/Other’,1,’U’,’P’,1,’STATUS’,6.99,6.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (120,’DVD-R Disc with Jewel Case, 4.7 GB’,’DVD-R Disc with Jewel Case, 4.7 GB’,’Recordable DVD Discs’,2056,’Recordable DVD Discs’,’Software/Other’,205,’Software/Other’,1,’U’,’P’,1,’STATUS’,6.99,6.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (121,’DVD-RAM Jewel Case, Double-Sided, 9.4G’,’DVD-RAM Media, with Jewel Case, Double-Sided, 9.4GB’,’Recordable DVD Discs’,2056,’Recordable DVD Discs’,’Software/Other’,205,’Software/Other’,1,’U’,’P’,1,’STATUS’,10.99,10.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (122,’DVD-R Discs, 4.7GB, Pack of 5′,’DVD-R Discs, 4.7GB, Pack of 5′,’Recordable DVD Discs’,2056,’Recordable DVD Discs’,’Software/Other’,205,’Software/Other’,1,’U’,’P’,1,’STATUS’,18.99,18.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (123,’DVD-R Discs, 4.7GB, Pack of 5′,’DVD-R Discs, 4.7GB, Pack of 5′,’Recordable DVD Discs’,2056,’Recordable DVD Discs’,’Software/Other’,205,’Software/Other’,1,’U’,’P’,1,’STATUS’,49.99,49.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (124,’DVD-RW Discs, 4.7GB, Pack of 3′,’DVD-RW Discs, 4.7GB, Pack of 3′,’Recordable DVD Discs’,2056,’Recordable DVD Discs’,’Software/Other’,205,’Software/Other’,1,’U’,’P’,1,’STATUS’,18.99,18.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (125,’3 1/2″ Bulk diskettes, Box of 50′,’3 1/2″ Bulk diskettes, Box of 50′,’Bulk Pack Diskettes’,2053,’Bulk Pack Diskettes’,’Software/Other’,205,’Software/Other’,1,’U’,’P’,1,’STATUS’,15.99,15.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (126,’3 1/2″ Bulk diskettes, Box of 100′,’3 1/2″ Bulk diskettes, Box of 100′,’Bulk Pack Diskettes’,2053,’Bulk Pack Diskettes’,’Software/Other’,205,’Software/Other’,1,’U’,’P’,1,’STATUS’,28.99,28.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (127,’Model CD13272 Tricolor Ink Cartridge’,’Model CD13272 Tricolor Ink Cartridge’,’Printer Supplies’,2036,’Printer Supplies’,’Peripherals and Accessories’,203,’Peripherals and Accessories’,1,’U’,’P’,1,’STATUS’,36.99,36.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (128,’Model SM26273 Black Ink Cartridge’,’Model SM26273 Black Ink Cartridge’,’Printer Supplies’,2036,’Printer Supplies’,’Peripherals and Accessories’,203,’Peripherals and Accessories’,1,’U’,’P’,1,’STATUS’,27.99,27.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (129,’Model NM500X High Yield Toner Cartridge’,’Model NM500X High Yield Toner Cartridge’,’Printer Supplies’,2036,’Printer Supplies’,’Peripherals and Accessories’,203,’Peripherals and Accessories’,1,’U’,’P’,1,’STATUS’,192.99,192.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (130,’Model A3827H Black Image Cartridge’,’Model A3827H Black Image Cartridge’,’Printer Supplies’,2036,’Printer Supplies’,’Peripherals and Accessories’,203,’Peripherals and Accessories’,1,’U’,’P’,1,’STATUS’,89.99,89.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (131,’Model K3822L Cordless Phone Battery’,’Model K3822L Cordless Phone Battery’,’Camera Batteries’,2042,’Camera Batteries’,’Photo’,204,’Photo’,1,’U’,’P’,1,’STATUS’,18.99,18.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (132,’Model C9827B Cordless Phone Battery’,’Model C9827B Cordless Phone Battery’,’Camera Batteries’,2042,’Camera Batteries’,’Photo’,204,’Photo’,1,’U’,’P’,1,’STATUS’,24.99,24.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (133,’Model K8822S Cordless Phone Battery’,’Model K8822S Cordless Phone Battery’,’Camera Batteries’,2042,’Camera Batteries’,’Photo’,204,’Photo’,1,’U’,’P’,1,’STATUS’,30.99,30.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (134,’Model C93822D Wireless Phone Battery’,’Model C93822D Wireless Phone Battery’,’Camera Batteries’,2042,’Camera Batteries’,’Photo’,204,’Photo’,1,’U’,’P’,1,’STATUS’,20.99,20.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (135,’S27273M Extended Use w/l Phone Batt.’,’Model S27273M Extended Use Wireless Phone Battery’,’Camera Batteries’,2042,’Camera Batteries’,’Photo’,204,’Photo’,1,’U’,’P’,1,’STATUS’,49.99,49.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (136,’64MB Memory Card’,’64MB Memory Card’,’Camera Media’,2043,’Camera Media’,’Photo’,204,’Photo’,1,’U’,’P’,1,’STATUS’,32.99,32.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (137,’128MB Memory Card’,’128MB Memory Card’,’Camera Media’,2043,’Camera Media’,’Photo’,204,’Photo’,1,’U’,’P’,1,’STATUS’,52.99,52.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (138,’256MB Memory Card’,’256MB Memory Card’,’Camera Media’,2043,’Camera Media’,’Photo’,204,’Photo’,1,’U’,’P’,1,’STATUS’,69.99,69.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (139,’Bounce’,’Bounce’,’Y Box Games’,2014,’Y Box Games’,’Electronics’,201,’Electronics’,4,’U’,’P’,1,’STATUS’,19.99,19.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (140,’Endurance Racing’,’Endurance Racing’,’Y Box Games’,2014,’Y Box Games’,’Electronics’,201,’Electronics’,1,’U’,’P’,1,’STATUS’,29.99,29.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (141,’Smash up Boxing’,’Smash up Boxing’,’Y Box Games’,2014,’Y Box Games’,’Electronics’,201,’Electronics’,1,’U’,’P’,1,’STATUS’,29.99,29.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (142,’Martial Arts Champions’,’Martial Arts Champions’,’Y Box Games’,2014,’Y Box Games’,’Electronics’,201,’Electronics’,1,’U’,’P’,1,’STATUS’,19.99,19.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (143,’Comic Book Heroes’,’Comic Book Heroes’,’Y Box Games’,2014,’Y Box Games’,’Electronics’,201,’Electronics’,1,’U’,’P’,1,’STATUS’,19.99,19.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (144,’Fly Fishing’,’Fly Fishing’,’Y Box Games’,2014,’Y Box Games’,’Electronics’,201,’Electronics’,1,’U’,’P’,1,’STATUS’,7.99,7.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (145,’Finding Fido’,’Finding Fido’,’Y Box Games’,2014,’Y Box Games’,’Electronics’,201,’Electronics’,1,’U’,’P’,1,’STATUS’,12.99,12.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (146,’Adventures with Numbers’,’Adventures with Numbers’,’Y Box Games’,2014,’Y Box Games’,’Electronics’,201,’Electronics’,1,’U’,’P’,1,’STATUS’,11.99,11.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (147,’Extension Cable’,’Extension Cable’,’Y Box Accessories’,2013,’Y Box Accessories’,’Electronics’,201,’Electronics’,1,’U’,’P’,1,’STATUS’,7.99,7.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);
Insert into PRODUCTS (PROD_ID,PROD_NAME,PROD_DESC,PROD_SUBCATEGORY,PROD_SUBCATEGORY_ID,PROD_SUBCATEGORY_DESC,PROD_CATEGORY,PROD_CATEGORY_ID,PROD_CATEGORY_DESC,PROD_WEIGHT_CLASS,PROD_UNIT_OF_MEASURE,PROD_PACK_SIZE,SUPPLIER_ID,PROD_STATUS,PROD_LIST_PRICE,PROD_MIN_PRICE,PROD_TOTAL,PROD_TOTAL_ID,PROD_SRC_ID,PROD_EFF_FROM,PROD_EFF_TO,PROD_VALID) values (148,’Xtend Memory’,’Xtend Memory’,’Y Box Accessories’,2013,’Y Box Accessories’,’Electronics’,201,’Electronics’,1,’U’,’P’,1,’STATUS’,20.99,20.99,’TOTAL’,1,null,to_date(’01-JAN-98′,’DD-MON-RR’),null,’A’);

Time_table.sql

DROP TABLE time_dimension CASCADE CONSTRAINTS;
CREATE TABLE time_dimension (
date_key                     NUMBER NOT NULL,
full_date                    DATE,
day_of_week                  NUMBER,
day_num_in_month             NUMBER,
day_num_overall              NUMBER,
day_name                     VARCHAR2(9),
day_abbrev                   VARCHAR2(3),
weekday_flag                 VARCHAR2(1),
week_num_in_year             NUMBER,
week_num_overall             NUMBER,
week_begin_date              DATE,
month                        NUMBER,
month_num_overall            NUMBER,
month_name                   VARCHAR2(9),
month_abbrev                 VARCHAR2(3),
quarter                      NUMBER,
year                         NUMBER,
yearmo                       NUMBER,
fiscal_month                 NUMBER,
fiscal_quarter               NUMBER,
fiscal_year                  NUMBER,
last_day_in_month_flag       VARCHAR2(1),
same_weekday_year_ago_date   DATE
);
ALTER TABLE time_dimension ADD CONSTRAINT time_dimension_pk PRIMARY KEY ( date_key );

LEAVE A REPLY

Please enter your comment!
Please enter your name here