--------------------------------------------------------
--  File created - Friday-December-09-2016   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table PROMOTIONS
--------------------------------------------------------

  CREATE TABLE "PROMOTIONS" 
   (	"PROMO_ID" NUMBER(6,0), 
	"PROMO_NAME" VARCHAR2(20), 
	"PROMO_SUBCATEGORY" VARCHAR2(30), 
	"PROMO_CATEGORY" VARCHAR2(30), 
	"PROMO_COST" NUMBER(10,2), 
	"PROMO_BEGIN_DATE" DATE, 
	"PROMO_END_DATE" DATE
   ) ;

REM INSERTING into PROMOTIONS
SET DEFINE OFF;
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (1,'promotion name# 1','downtown billboard','post',77200,to_date('15-SEP-98','DD-MON-RR'),to_date('15-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (2,'promotion name# 2','hospital flyer','flyer',47100,to_date('13-APR-99','DD-MON-RR'),to_date('13-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (3,'promotion name# 3','coupon news','newspaper',23900,to_date('25-AUG-00','DD-MON-RR'),to_date('25-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (4,'promotion name# 4','manufacture rebate news','newspaper',8700,to_date('18-NOV-98','DD-MON-RR'),to_date('18-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (5,'promotion name# 5','TV program sponsorship','TV',5700,to_date('17-MAR-99','DD-MON-RR'),to_date('17-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (6,'promotion name# 6','ad news','newspaper',76800,to_date('08-MAY-00','DD-MON-RR'),to_date('08-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (7,'promotion name# 7','online discount','internet',36400,to_date('30-JUN-98','DD-MON-RR'),to_date('30-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (8,'promotion name# 8','manufacture rebate news','newspaper',65600,to_date('26-OCT-99','DD-MON-RR'),to_date('26-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (9,'promotion name# 9','billboard','post',39500,to_date('11-DEC-00','DD-MON-RR'),to_date('11-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (10,'promotion name# 10','coupon news','newspaper',22400,to_date('16-JUL-98','DD-MON-RR'),to_date('16-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (11,'promotion name# 11','TV commercial','TV',94700,to_date('23-JAN-99','DD-MON-RR'),to_date('23-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (12,'promotion name# 12','loyal customer discount','internet',86400,to_date('22-FEB-00','DD-MON-RR'),to_date('22-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (13,'promotion name# 13','hospital flyer','flyer',91400,to_date('19-SEP-98','DD-MON-RR'),to_date('19-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (14,'promotion name# 14','downtown billboard','post',73800,to_date('21-APR-99','DD-MON-RR'),to_date('21-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (15,'promotion name# 15','online discount','internet',6600,to_date('03-AUG-00','DD-MON-RR'),to_date('03-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (16,'promotion name# 16','TV program sponsorship','TV',25200,to_date('05-NOV-98','DD-MON-RR'),to_date('05-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (17,'promotion name# 17','freeway billboard','post',68700,to_date('06-MAR-99','DD-MON-RR'),to_date('06-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (18,'promotion name# 18','radio program sponsorship','radio',97200,to_date('10-MAY-00','DD-MON-RR'),to_date('10-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (19,'promotion name# 19','loyal customer discount','internet',77600,to_date('27-JUN-98','DD-MON-RR'),to_date('27-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (20,'promotion name# 20','downtown billboard','post',57800,to_date('12-OCT-99','DD-MON-RR'),to_date('12-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (21,'promotion name# 21','downtown billboard','post',83100,to_date('20-DEC-00','DD-MON-RR'),to_date('20-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (22,'promotion name# 22','TV commercial','TV',78800,to_date('24-JUL-98','DD-MON-RR'),to_date('24-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (23,'promotion name# 23','coupon news','newspaper',89900,to_date('07-JAN-99','DD-MON-RR'),to_date('07-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (24,'promotion name# 24','hospital flyer','flyer',58900,to_date('01-FEB-00','DD-MON-RR'),to_date('01-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (25,'promotion name# 25','online discount','internet',87300,to_date('29-SEP-98','DD-MON-RR'),to_date('29-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (26,'promotion name# 26','coupon news','newspaper',39800,to_date('14-APR-99','DD-MON-RR'),to_date('14-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (27,'promotion name# 27','TV program sponsorship','TV',5200,to_date('02-AUG-00','DD-MON-RR'),to_date('02-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (28,'promotion name# 28','online discount','internet',38200,to_date('09-NOV-98','DD-MON-RR'),to_date('09-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (29,'promotion name# 29','manufacture rebate magazine','magazine',63300,to_date('28-MAR-99','DD-MON-RR'),to_date('28-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (30,'promotion name# 30','manufacture rebate magazine','magazine',3200,to_date('04-MAY-00','DD-MON-RR'),to_date('04-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (31,'promotion name# 31','online discount','internet',85600,to_date('15-JUN-98','DD-MON-RR'),to_date('15-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (32,'promotion name# 32','online discount','internet',70000,to_date('31-OCT-99','DD-MON-RR'),to_date('31-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (33,'promotion name# 33','radio program sponsorship','radio',56300,to_date('13-DEC-00','DD-MON-RR'),to_date('13-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (34,'promotion name# 34','downtown billboard','post',68200,to_date('25-JUL-98','DD-MON-RR'),to_date('25-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (35,'promotion name# 35','freeway billboard','post',58600,to_date('18-JAN-99','DD-MON-RR'),to_date('18-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (36,'promotion name# 36','ad news','newspaper',3600,to_date('17-FEB-00','DD-MON-RR'),to_date('17-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (37,'promotion name# 37','online discount','internet',96300,to_date('08-SEP-98','DD-MON-RR'),to_date('08-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (38,'promotion name# 38','coupon news','newspaper',28300,to_date('30-APR-99','DD-MON-RR'),to_date('30-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (39,'promotion name# 39','coupon news','newspaper',25500,to_date('26-AUG-00','DD-MON-RR'),to_date('26-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (40,'promotion name# 40','TV program sponsorship','TV',51500,to_date('11-NOV-98','DD-MON-RR'),to_date('11-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (41,'promotion name# 41','TV program sponsorship','TV',40700,to_date('16-MAR-99','DD-MON-RR'),to_date('16-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (42,'promotion name# 42','coupon news','newspaper',54500,to_date('23-MAY-00','DD-MON-RR'),to_date('23-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (43,'promotion name# 43','coupon news','newspaper',70500,to_date('22-JUN-98','DD-MON-RR'),to_date('22-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (44,'promotion name# 44','coupon news','newspaper',94900,to_date('19-OCT-99','DD-MON-RR'),to_date('19-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (45,'promotion name# 45','loyal customer discount','internet',41300,to_date('21-DEC-00','DD-MON-RR'),to_date('21-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (46,'promotion name# 46','ad','internet',20100,to_date('03-JUL-98','DD-MON-RR'),to_date('03-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (47,'promotion name# 47','freeway billboard','post',58400,to_date('05-JAN-99','DD-MON-RR'),to_date('05-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (48,'promotion name# 48','coupon magazine','magazine',48700,to_date('06-FEB-00','DD-MON-RR'),to_date('06-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (49,'promotion name# 49','downtown billboard','post',66700,to_date('10-SEP-98','DD-MON-RR'),to_date('10-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (50,'promotion name# 50','general flyer','flyer',43700,to_date('27-APR-99','DD-MON-RR'),to_date('27-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (51,'promotion name# 51','TV program sponsorship','TV',84300,to_date('12-AUG-00','DD-MON-RR'),to_date('12-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (52,'promotion name# 52','TV program sponsorship','TV',10000,to_date('20-NOV-98','DD-MON-RR'),to_date('20-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (53,'promotion name# 53','coupon magazine','magazine',65700,to_date('24-MAR-99','DD-MON-RR'),to_date('24-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (54,'promotion name# 54','ad','internet',67400,to_date('07-MAY-00','DD-MON-RR'),to_date('07-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (55,'promotion name# 55','hospital flyer','flyer',37200,to_date('01-JUN-98','DD-MON-RR'),to_date('01-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (56,'promotion name# 56','manufacture rebate magazine','magazine',87000,to_date('29-OCT-99','DD-MON-RR'),to_date('29-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (57,'promotion name# 57','coupon news','newspaper',57000,to_date('14-DEC-00','DD-MON-RR'),to_date('14-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (58,'promotion name# 58','ad','internet',61700,to_date('02-JUL-98','DD-MON-RR'),to_date('02-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (59,'promotion name# 59','TV commercial','TV',61300,to_date('09-JAN-99','DD-MON-RR'),to_date('09-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (60,'promotion name# 60','coupon magazine','magazine',50600,to_date('28-FEB-00','DD-MON-RR'),to_date('28-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (61,'promotion name# 61','general flyer','flyer',92300,to_date('04-SEP-98','DD-MON-RR'),to_date('04-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (62,'promotion name# 62','ad news','newspaper',22200,to_date('15-APR-99','DD-MON-RR'),to_date('15-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (63,'promotion name# 63','TV program sponsorship','TV',38900,to_date('31-AUG-00','DD-MON-RR'),to_date('30-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (64,'promotion name# 64','TV program sponsorship','TV',56800,to_date('13-NOV-98','DD-MON-RR'),to_date('13-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (65,'promotion name# 65','ad news','newspaper',5900,to_date('25-MAR-99','DD-MON-RR'),to_date('25-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (66,'promotion name# 66','freeway billboard','post',31700,to_date('18-MAY-00','DD-MON-RR'),to_date('18-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (67,'promotion name# 67','promotion movie','TV',66000,to_date('17-JUN-98','DD-MON-RR'),to_date('17-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (68,'promotion name# 68','online discount','internet',50200,to_date('08-OCT-99','DD-MON-RR'),to_date('08-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (69,'promotion name# 69','radio commercial','radio',81600,to_date('30-DEC-00','DD-MON-RR'),to_date('30-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (70,'promotion name# 70','TV program sponsorship','TV',63900,to_date('26-JUL-98','DD-MON-RR'),to_date('26-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (71,'promotion name# 71','TV program sponsorship','TV',69700,to_date('11-JAN-99','DD-MON-RR'),to_date('11-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (72,'promotion name# 72','downtown billboard','post',73500,to_date('16-FEB-00','DD-MON-RR'),to_date('16-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (73,'promotion name# 73','coupon magazine','magazine',23800,to_date('23-SEP-98','DD-MON-RR'),to_date('23-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (74,'promotion name# 74','TV program sponsorship','TV',81700,to_date('22-APR-99','DD-MON-RR'),to_date('22-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (75,'promotion name# 75','coupon news','newspaper',91800,to_date('19-AUG-00','DD-MON-RR'),to_date('19-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (76,'promotion name# 76','coupon magazine','magazine',84500,to_date('21-NOV-98','DD-MON-RR'),to_date('21-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (77,'promotion name# 77','downtown billboard','post',65800,to_date('03-MAR-99','DD-MON-RR'),to_date('03-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (78,'promotion name# 78','radio program sponsorship','radio',95300,to_date('05-MAY-00','DD-MON-RR'),to_date('05-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (79,'promotion name# 79','ad news','newspaper',52000,to_date('06-JUN-98','DD-MON-RR'),to_date('06-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (80,'promotion name# 80','ad magazine','magazine',79300,to_date('10-OCT-99','DD-MON-RR'),to_date('10-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (81,'promotion name# 81','coupon news','newspaper',27600,to_date('27-DEC-00','DD-MON-RR'),to_date('27-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (82,'promotion name# 82','ad news','newspaper',32000,to_date('12-JUL-98','DD-MON-RR'),to_date('12-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (83,'promotion name# 83','online discount','internet',48800,to_date('20-JAN-99','DD-MON-RR'),to_date('20-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (84,'promotion name# 84','TV program sponsorship','TV',94600,to_date('24-FEB-00','DD-MON-RR'),to_date('24-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (85,'promotion name# 85','promotion movie','TV',58500,to_date('07-SEP-98','DD-MON-RR'),to_date('07-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (86,'promotion name# 86','manufacture rebate magazine','magazine',76600,to_date('01-APR-99','DD-MON-RR'),to_date('01-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (87,'promotion name# 87','TV program sponsorship','TV',81500,to_date('29-AUG-00','DD-MON-RR'),to_date('29-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (88,'promotion name# 88','coupon magazine','magazine',36000,to_date('14-NOV-98','DD-MON-RR'),to_date('14-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (89,'promotion name# 89','coupon magazine','magazine',54900,to_date('02-MAR-99','DD-MON-RR'),to_date('02-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (90,'promotion name# 90','household flyer','flyer',81200,to_date('09-MAY-00','DD-MON-RR'),to_date('09-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (91,'promotion name# 91','hospital flyer','flyer',53200,to_date('28-JUN-98','DD-MON-RR'),to_date('28-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (92,'promotion name# 92','ad','internet',10500,to_date('04-OCT-99','DD-MON-RR'),to_date('04-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (93,'promotion name# 93','online discount','internet',3400,to_date('15-DEC-00','DD-MON-RR'),to_date('15-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (94,'promotion name# 94','ad magazine','magazine',40500,to_date('31-JUL-98','DD-MON-RR'),to_date('30-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (95,'promotion name# 95','TV commercial','TV',99600,to_date('13-JAN-99','DD-MON-RR'),to_date('13-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (96,'promotion name# 96','manufacture rebate news','newspaper',40900,to_date('25-FEB-00','DD-MON-RR'),to_date('25-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (97,'promotion name# 97','promotion movie','TV',9400,to_date('18-SEP-98','DD-MON-RR'),to_date('18-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (98,'promotion name# 98','coupon news','newspaper',79500,to_date('17-APR-99','DD-MON-RR'),to_date('17-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (99,'promotion name# 99','TV program sponsorship','TV',83400,to_date('08-AUG-00','DD-MON-RR'),to_date('08-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (100,'promotion name# 100','TV commercial','TV',61600,to_date('30-NOV-98','DD-MON-RR'),to_date('30-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (101,'promotion name# 101','downtown billboard','post',33400,to_date('26-MAR-99','DD-MON-RR'),to_date('26-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (102,'promotion name# 102','hospital flyer','flyer',35800,to_date('11-MAY-00','DD-MON-RR'),to_date('11-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (103,'promotion name# 103','coupon news','newspaper',100000,to_date('16-JUN-98','DD-MON-RR'),to_date('16-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (104,'promotion name# 104','manufacture rebate news','newspaper',51600,to_date('23-OCT-99','DD-MON-RR'),to_date('23-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (105,'promotion name# 105','TV program sponsorship','TV',68600,to_date('22-DEC-00','DD-MON-RR'),to_date('22-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (106,'promotion name# 106','ad news','newspaper',69300,to_date('19-JUL-98','DD-MON-RR'),to_date('19-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (107,'promotion name# 107','online discount','internet',62800,to_date('21-JAN-99','DD-MON-RR'),to_date('21-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (108,'promotion name# 108','manufacture rebate news','newspaper',65500,to_date('03-FEB-00','DD-MON-RR'),to_date('03-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (109,'promotion name# 109','billboard','post',11600,to_date('05-SEP-98','DD-MON-RR'),to_date('05-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (110,'promotion name# 110','coupon news','newspaper',7600,to_date('06-APR-99','DD-MON-RR'),to_date('06-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (111,'promotion name# 111','TV commercial','TV',1500,to_date('10-AUG-00','DD-MON-RR'),to_date('10-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (112,'promotion name# 112','loyal customer discount','internet',14900,to_date('27-NOV-98','DD-MON-RR'),to_date('27-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (113,'promotion name# 113','hospital flyer','flyer',20200,to_date('12-MAR-99','DD-MON-RR'),to_date('12-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (114,'promotion name# 114','downtown billboard','post',86300,to_date('20-MAY-00','DD-MON-RR'),to_date('20-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (115,'promotion name# 115','online discount','internet',63500,to_date('24-JUN-98','DD-MON-RR'),to_date('24-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (116,'promotion name# 116','TV program sponsorship','TV',59000,to_date('07-OCT-99','DD-MON-RR'),to_date('07-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (117,'promotion name# 117','freeway billboard','post',14300,to_date('01-DEC-00','DD-MON-RR'),to_date('01-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (118,'promotion name# 118','radio program sponsorship','radio',54600,to_date('29-JUL-98','DD-MON-RR'),to_date('29-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (119,'promotion name# 119','loyal customer discount','internet',98400,to_date('14-JAN-99','DD-MON-RR'),to_date('14-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (120,'promotion name# 120','downtown billboard','post',8800,to_date('02-FEB-00','DD-MON-RR'),to_date('02-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (121,'promotion name# 121','downtown billboard','post',33600,to_date('09-SEP-98','DD-MON-RR'),to_date('09-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (122,'promotion name# 122','TV commercial','TV',91600,to_date('28-APR-99','DD-MON-RR'),to_date('28-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (123,'promotion name# 123','coupon news','newspaper',28700,to_date('04-AUG-00','DD-MON-RR'),to_date('04-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (124,'promotion name# 124','hospital flyer','flyer',36200,to_date('15-NOV-98','DD-MON-RR'),to_date('15-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (125,'promotion name# 125','online discount','internet',9800,to_date('31-MAR-99','DD-MON-RR'),to_date('30-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (126,'promotion name# 126','coupon news','newspaper',9900,to_date('13-MAY-00','DD-MON-RR'),to_date('13-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (127,'promotion name# 127','TV program sponsorship','TV',37800,to_date('25-JUN-98','DD-MON-RR'),to_date('25-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (128,'promotion name# 128','online discount','internet',52600,to_date('18-OCT-99','DD-MON-RR'),to_date('18-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (129,'promotion name# 129','manufacture rebate magazine','magazine',44900,to_date('17-DEC-00','DD-MON-RR'),to_date('17-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (130,'promotion name# 130','manufacture rebate magazine','magazine',15500,to_date('08-JUL-98','DD-MON-RR'),to_date('08-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (131,'promotion name# 131','online discount','internet',86700,to_date('30-JAN-99','DD-MON-RR'),to_date('30-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (132,'promotion name# 132','online discount','internet',74200,to_date('26-FEB-00','DD-MON-RR'),to_date('26-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (133,'promotion name# 133','radio program sponsorship','radio',17300,to_date('11-SEP-98','DD-MON-RR'),to_date('11-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (134,'promotion name# 134','downtown billboard','post',84400,to_date('16-APR-99','DD-MON-RR'),to_date('16-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (135,'promotion name# 135','freeway billboard','post',37900,to_date('23-AUG-00','DD-MON-RR'),to_date('23-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (136,'promotion name# 136','ad news','newspaper',80500,to_date('22-NOV-98','DD-MON-RR'),to_date('22-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (137,'promotion name# 137','online discount','internet',59700,to_date('19-MAR-99','DD-MON-RR'),to_date('19-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (138,'promotion name# 138','coupon news','newspaper',7800,to_date('21-MAY-00','DD-MON-RR'),to_date('21-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (139,'promotion name# 139','coupon news','newspaper',57300,to_date('03-JUN-98','DD-MON-RR'),to_date('03-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (140,'promotion name# 140','TV program sponsorship','TV',44500,to_date('05-OCT-99','DD-MON-RR'),to_date('05-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (141,'promotion name# 141','TV program sponsorship','TV',4800,to_date('06-DEC-00','DD-MON-RR'),to_date('06-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (142,'promotion name# 142','coupon news','newspaper',27500,to_date('10-JUL-98','DD-MON-RR'),to_date('10-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (143,'promotion name# 143','coupon news','newspaper',4100,to_date('27-JAN-99','DD-MON-RR'),to_date('27-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (144,'promotion name# 144','coupon news','newspaper',34000,to_date('12-FEB-00','DD-MON-RR'),to_date('12-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (145,'promotion name# 145','loyal customer discount','internet',1400,to_date('20-SEP-98','DD-MON-RR'),to_date('20-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (146,'promotion name# 146','ad','internet',87900,to_date('24-APR-99','DD-MON-RR'),to_date('24-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (147,'promotion name# 147','freeway billboard','post',5400,to_date('07-AUG-00','DD-MON-RR'),to_date('07-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (148,'promotion name# 148','coupon magazine','magazine',94000,to_date('01-NOV-98','DD-MON-RR'),to_date('01-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (149,'promotion name# 149','downtown billboard','post',92900,to_date('29-MAR-99','DD-MON-RR'),to_date('29-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (150,'promotion name# 150','general flyer','flyer',88700,to_date('14-MAY-00','DD-MON-RR'),to_date('14-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (151,'promotion name# 151','TV program sponsorship','TV',26800,to_date('02-JUN-98','DD-MON-RR'),to_date('02-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (152,'promotion name# 152','TV program sponsorship','TV',10600,to_date('09-OCT-99','DD-MON-RR'),to_date('09-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (153,'promotion name# 153','coupon magazine','magazine',31300,to_date('28-DEC-00','DD-MON-RR'),to_date('28-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (154,'promotion name# 154','ad','internet',55300,to_date('04-JUL-98','DD-MON-RR'),to_date('04-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (155,'promotion name# 155','hospital flyer','flyer',91900,to_date('15-JAN-99','DD-MON-RR'),to_date('15-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (156,'promotion name# 156','manufacture rebate magazine','magazine',11500,to_date('13-FEB-00','DD-MON-RR'),to_date('13-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (157,'promotion name# 157','coupon news','newspaper',80600,to_date('25-SEP-98','DD-MON-RR'),to_date('25-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (158,'promotion name# 158','ad','internet',87600,to_date('18-APR-99','DD-MON-RR'),to_date('18-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (159,'promotion name# 159','TV commercial','TV',22600,to_date('17-AUG-00','DD-MON-RR'),to_date('17-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (160,'promotion name# 160','coupon magazine','magazine',49600,to_date('08-NOV-98','DD-MON-RR'),to_date('08-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (161,'promotion name# 161','general flyer','flyer',15100,to_date('30-MAR-99','DD-MON-RR'),to_date('30-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (162,'promotion name# 162','ad news','newspaper',76000,to_date('26-MAY-00','DD-MON-RR'),to_date('26-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (163,'promotion name# 163','TV program sponsorship','TV',15000,to_date('11-JUN-98','DD-MON-RR'),to_date('11-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (164,'promotion name# 164','TV program sponsorship','TV',48100,to_date('16-OCT-99','DD-MON-RR'),to_date('16-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (165,'promotion name# 165','ad news','newspaper',200,to_date('23-DEC-00','DD-MON-RR'),to_date('23-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (166,'promotion name# 166','freeway billboard','post',55800,to_date('22-JUL-98','DD-MON-RR'),to_date('22-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (167,'promotion name# 167','promotion movie','TV',29600,to_date('19-JAN-99','DD-MON-RR'),to_date('19-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (168,'promotion name# 168','online discount','internet',85500,to_date('21-FEB-00','DD-MON-RR'),to_date('21-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (169,'promotion name# 169','radio commercial','radio',42100,to_date('03-SEP-98','DD-MON-RR'),to_date('03-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (170,'promotion name# 170','TV program sponsorship','TV',41500,to_date('05-APR-99','DD-MON-RR'),to_date('05-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (171,'promotion name# 171','TV program sponsorship','TV',75900,to_date('06-AUG-00','DD-MON-RR'),to_date('06-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (172,'promotion name# 172','downtown billboard','post',88000,to_date('10-NOV-98','DD-MON-RR'),to_date('10-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (173,'promotion name# 173','coupon magazine','magazine',33300,to_date('27-MAR-99','DD-MON-RR'),to_date('27-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (174,'promotion name# 174','TV program sponsorship','TV',7900,to_date('12-MAY-00','DD-MON-RR'),to_date('12-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (175,'promotion name# 175','coupon news','newspaper',85200,to_date('20-JUN-98','DD-MON-RR'),to_date('20-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (176,'promotion name# 176','coupon magazine','magazine',59300,to_date('24-OCT-99','DD-MON-RR'),to_date('24-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (177,'promotion name# 177','downtown billboard','post',98000,to_date('07-DEC-00','DD-MON-RR'),to_date('07-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (178,'promotion name# 178','radio program sponsorship','radio',99000,to_date('01-JUL-98','DD-MON-RR'),to_date('01-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (179,'promotion name# 179','ad news','newspaper',75300,to_date('29-JAN-99','DD-MON-RR'),to_date('29-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (180,'promotion name# 180','ad magazine','magazine',21500,to_date('14-FEB-00','DD-MON-RR'),to_date('14-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (181,'promotion name# 181','coupon news','newspaper',45400,to_date('02-SEP-98','DD-MON-RR'),to_date('02-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (182,'promotion name# 182','ad news','newspaper',54100,to_date('09-APR-99','DD-MON-RR'),to_date('09-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (183,'promotion name# 183','online discount','internet',59800,to_date('28-AUG-00','DD-MON-RR'),to_date('28-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (184,'promotion name# 184','TV program sponsorship','TV',35700,to_date('04-NOV-98','DD-MON-RR'),to_date('04-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (185,'promotion name# 185','promotion movie','TV',72100,to_date('15-MAR-99','DD-MON-RR'),to_date('15-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (186,'promotion name# 186','manufacture rebate magazine','magazine',36800,to_date('31-MAY-00','DD-MON-RR'),to_date('30-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (187,'promotion name# 187','TV program sponsorship','TV',76300,to_date('13-JUN-98','DD-MON-RR'),to_date('13-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (188,'promotion name# 188','coupon magazine','magazine',98700,to_date('25-OCT-99','DD-MON-RR'),to_date('25-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (189,'promotion name# 189','coupon magazine','magazine',92500,to_date('18-DEC-00','DD-MON-RR'),to_date('18-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (190,'promotion name# 190','household flyer','flyer',78000,to_date('17-JUL-98','DD-MON-RR'),to_date('17-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (191,'promotion name# 191','hospital flyer','flyer',68500,to_date('08-JAN-99','DD-MON-RR'),to_date('08-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (192,'promotion name# 192','ad','internet',41400,to_date('26-FEB-00','DD-MON-RR'),to_date('26-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (193,'promotion name# 193','online discount','internet',48000,to_date('11-SEP-98','DD-MON-RR'),to_date('11-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (194,'promotion name# 194','ad magazine','magazine',73200,to_date('16-APR-99','DD-MON-RR'),to_date('16-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (195,'promotion name# 195','TV commercial','TV',41000,to_date('23-AUG-00','DD-MON-RR'),to_date('23-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (196,'promotion name# 196','manufacture rebate news','newspaper',37300,to_date('22-NOV-98','DD-MON-RR'),to_date('22-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (197,'promotion name# 197','promotion movie','TV',14000,to_date('19-MAR-99','DD-MON-RR'),to_date('19-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (198,'promotion name# 198','coupon news','newspaper',71800,to_date('21-MAY-00','DD-MON-RR'),to_date('21-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (199,'promotion name# 199','TV program sponsorship','TV',54000,to_date('03-JUN-98','DD-MON-RR'),to_date('03-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (200,'promotion name# 200','TV commercial','TV',31900,to_date('05-OCT-99','DD-MON-RR'),to_date('05-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (201,'promotion name# 201','downtown billboard','post',20900,to_date('06-DEC-00','DD-MON-RR'),to_date('06-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (202,'promotion name# 202','hospital flyer','flyer',79800,to_date('10-JUL-98','DD-MON-RR'),to_date('10-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (203,'promotion name# 203','coupon news','newspaper',66200,to_date('27-JAN-99','DD-MON-RR'),to_date('27-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (204,'promotion name# 204','manufacture rebate news','newspaper',5100,to_date('12-FEB-00','DD-MON-RR'),to_date('12-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (205,'promotion name# 205','TV program sponsorship','TV',10300,to_date('20-SEP-98','DD-MON-RR'),to_date('20-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (206,'promotion name# 206','ad news','newspaper',48500,to_date('24-APR-99','DD-MON-RR'),to_date('24-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (207,'promotion name# 207','online discount','internet',10900,to_date('07-AUG-00','DD-MON-RR'),to_date('07-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (208,'promotion name# 208','manufacture rebate news','newspaper',14100,to_date('01-NOV-98','DD-MON-RR'),to_date('01-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (209,'promotion name# 209','billboard','post',99700,to_date('29-MAR-99','DD-MON-RR'),to_date('29-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (210,'promotion name# 210','coupon news','newspaper',68800,to_date('14-MAY-00','DD-MON-RR'),to_date('14-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (211,'promotion name# 211','TV commercial','TV',24200,to_date('02-JUN-98','DD-MON-RR'),to_date('02-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (212,'promotion name# 212','loyal customer discount','internet',92400,to_date('09-OCT-99','DD-MON-RR'),to_date('09-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (213,'promotion name# 213','hospital flyer','flyer',50100,to_date('28-DEC-00','DD-MON-RR'),to_date('28-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (214,'promotion name# 214','downtown billboard','post',53700,to_date('04-JUL-98','DD-MON-RR'),to_date('04-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (215,'promotion name# 215','online discount','internet',49100,to_date('15-JAN-99','DD-MON-RR'),to_date('15-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (216,'promotion name# 216','TV program sponsorship','TV',77400,to_date('13-FEB-00','DD-MON-RR'),to_date('13-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (217,'promotion name# 217','freeway billboard','post',2000,to_date('25-SEP-98','DD-MON-RR'),to_date('25-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (218,'promotion name# 218','radio program sponsorship','radio',53500,to_date('18-APR-99','DD-MON-RR'),to_date('18-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (219,'promotion name# 219','loyal customer discount','internet',94200,to_date('17-AUG-00','DD-MON-RR'),to_date('17-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (220,'promotion name# 220','downtown billboard','post',47800,to_date('08-NOV-98','DD-MON-RR'),to_date('08-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (221,'promotion name# 221','downtown billboard','post',17400,to_date('30-MAR-99','DD-MON-RR'),to_date('30-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (222,'promotion name# 222','TV commercial','TV',11400,to_date('26-MAY-00','DD-MON-RR'),to_date('26-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (223,'promotion name# 223','coupon news','newspaper',52700,to_date('11-JUN-98','DD-MON-RR'),to_date('11-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (224,'promotion name# 224','hospital flyer','flyer',72800,to_date('16-OCT-99','DD-MON-RR'),to_date('16-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (225,'promotion name# 225','online discount','internet',30300,to_date('23-DEC-00','DD-MON-RR'),to_date('23-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (226,'promotion name# 226','coupon news','newspaper',79000,to_date('22-JUL-98','DD-MON-RR'),to_date('22-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (227,'promotion name# 227','TV program sponsorship','TV',44800,to_date('19-JAN-99','DD-MON-RR'),to_date('19-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (228,'promotion name# 228','online discount','internet',88500,to_date('21-FEB-00','DD-MON-RR'),to_date('21-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (229,'promotion name# 229','manufacture rebate magazine','magazine',71900,to_date('03-SEP-98','DD-MON-RR'),to_date('03-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (230,'promotion name# 230','manufacture rebate magazine','magazine',81900,to_date('05-APR-99','DD-MON-RR'),to_date('05-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (231,'promotion name# 231','online discount','internet',46700,to_date('06-AUG-00','DD-MON-RR'),to_date('06-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (232,'promotion name# 232','online discount','internet',13200,to_date('10-NOV-98','DD-MON-RR'),to_date('10-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (233,'promotion name# 233','radio program sponsorship','radio',50400,to_date('27-MAR-99','DD-MON-RR'),to_date('27-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (234,'promotion name# 234','downtown billboard','post',36500,to_date('12-MAY-00','DD-MON-RR'),to_date('12-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (235,'promotion name# 235','freeway billboard','post',93500,to_date('20-JUN-98','DD-MON-RR'),to_date('20-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (236,'promotion name# 236','ad news','newspaper',54300,to_date('24-OCT-99','DD-MON-RR'),to_date('24-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (237,'promotion name# 237','online discount','internet',14700,to_date('07-DEC-00','DD-MON-RR'),to_date('07-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (238,'promotion name# 238','coupon news','newspaper',65300,to_date('01-JUL-98','DD-MON-RR'),to_date('01-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (239,'promotion name# 239','coupon news','newspaper',56700,to_date('29-JAN-99','DD-MON-RR'),to_date('29-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (240,'promotion name# 240','TV program sponsorship','TV',78900,to_date('14-FEB-00','DD-MON-RR'),to_date('14-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (241,'promotion name# 241','TV program sponsorship','TV',16900,to_date('02-SEP-98','DD-MON-RR'),to_date('02-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (242,'promotion name# 242','coupon news','newspaper',73700,to_date('09-APR-99','DD-MON-RR'),to_date('09-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (243,'promotion name# 243','coupon news','newspaper',79600,to_date('28-AUG-00','DD-MON-RR'),to_date('28-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (244,'promotion name# 244','coupon news','newspaper',10400,to_date('04-NOV-98','DD-MON-RR'),to_date('04-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (245,'promotion name# 245','loyal customer discount','internet',76400,to_date('15-MAR-99','DD-MON-RR'),to_date('15-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (246,'promotion name# 246','ad','internet',25700,to_date('31-MAY-00','DD-MON-RR'),to_date('30-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (247,'promotion name# 247','freeway billboard','post',6400,to_date('13-JUN-98','DD-MON-RR'),to_date('13-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (248,'promotion name# 248','coupon magazine','magazine',70300,to_date('25-OCT-99','DD-MON-RR'),to_date('25-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (249,'promotion name# 249','downtown billboard','post',39100,to_date('18-DEC-00','DD-MON-RR'),to_date('18-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (250,'promotion name# 250','general flyer','flyer',11700,to_date('17-JUL-98','DD-MON-RR'),to_date('17-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (251,'promotion name# 251','TV program sponsorship','TV',35500,to_date('08-JAN-99','DD-MON-RR'),to_date('08-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (252,'promotion name# 252','TV program sponsorship','TV',16300,to_date('26-FEB-00','DD-MON-RR'),to_date('26-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (253,'promotion name# 253','coupon magazine','magazine',7200,to_date('11-SEP-98','DD-MON-RR'),to_date('11-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (254,'promotion name# 254','ad','internet',91700,to_date('16-APR-99','DD-MON-RR'),to_date('16-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (255,'promotion name# 255','hospital flyer','flyer',56600,to_date('23-AUG-00','DD-MON-RR'),to_date('23-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (256,'promotion name# 256','manufacture rebate magazine','magazine',51000,to_date('22-NOV-98','DD-MON-RR'),to_date('22-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (257,'promotion name# 257','coupon news','newspaper',2100,to_date('19-MAR-99','DD-MON-RR'),to_date('19-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (258,'promotion name# 258','ad','internet',81400,to_date('21-MAY-00','DD-MON-RR'),to_date('21-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (259,'promotion name# 259','TV commercial','TV',8100,to_date('03-JUN-98','DD-MON-RR'),to_date('03-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (260,'promotion name# 260','coupon magazine','magazine',40100,to_date('05-OCT-99','DD-MON-RR'),to_date('05-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (261,'promotion name# 261','general flyer','flyer',88900,to_date('06-DEC-00','DD-MON-RR'),to_date('06-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (262,'promotion name# 262','ad news','newspaper',82600,to_date('10-JUL-98','DD-MON-RR'),to_date('10-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (263,'promotion name# 263','TV program sponsorship','TV',40200,to_date('27-JAN-99','DD-MON-RR'),to_date('27-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (264,'promotion name# 264','TV program sponsorship','TV',15900,to_date('12-FEB-00','DD-MON-RR'),to_date('12-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (265,'promotion name# 265','ad news','newspaper',97400,to_date('20-SEP-98','DD-MON-RR'),to_date('20-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (266,'promotion name# 266','freeway billboard','post',32500,to_date('24-APR-99','DD-MON-RR'),to_date('24-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (267,'promotion name# 267','promotion movie','TV',87400,to_date('07-AUG-00','DD-MON-RR'),to_date('07-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (268,'promotion name# 268','online discount','internet',67700,to_date('01-NOV-98','DD-MON-RR'),to_date('01-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (269,'promotion name# 269','radio commercial','radio',20000,to_date('29-MAR-99','DD-MON-RR'),to_date('29-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (270,'promotion name# 270','TV program sponsorship','TV',30500,to_date('14-MAY-00','DD-MON-RR'),to_date('14-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (271,'promotion name# 271','TV program sponsorship','TV',33900,to_date('02-JUN-98','DD-MON-RR'),to_date('02-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (272,'promotion name# 272','downtown billboard','post',74400,to_date('09-OCT-99','DD-MON-RR'),to_date('09-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (273,'promotion name# 273','coupon magazine','magazine',73100,to_date('28-DEC-00','DD-MON-RR'),to_date('28-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (274,'promotion name# 274','TV program sponsorship','TV',13100,to_date('04-JUL-98','DD-MON-RR'),to_date('04-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (275,'promotion name# 275','coupon news','newspaper',22500,to_date('15-JAN-99','DD-MON-RR'),to_date('15-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (276,'promotion name# 276','coupon magazine','magazine',21700,to_date('13-FEB-00','DD-MON-RR'),to_date('13-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (277,'promotion name# 277','downtown billboard','post',300,to_date('25-SEP-98','DD-MON-RR'),to_date('25-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (278,'promotion name# 278','radio program sponsorship','radio',83700,to_date('18-APR-99','DD-MON-RR'),to_date('18-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (279,'promotion name# 279','ad news','newspaper',44400,to_date('17-AUG-00','DD-MON-RR'),to_date('17-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (280,'promotion name# 280','ad magazine','magazine',77800,to_date('08-NOV-98','DD-MON-RR'),to_date('08-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (281,'promotion name# 281','coupon news','newspaper',12700,to_date('30-MAR-99','DD-MON-RR'),to_date('30-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (282,'promotion name# 282','ad news','newspaper',11800,to_date('26-MAY-00','DD-MON-RR'),to_date('26-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (283,'promotion name# 283','online discount','internet',63400,to_date('11-JUN-98','DD-MON-RR'),to_date('11-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (284,'promotion name# 284','TV program sponsorship','TV',31100,to_date('16-OCT-99','DD-MON-RR'),to_date('16-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (285,'promotion name# 285','promotion movie','TV',62300,to_date('23-DEC-00','DD-MON-RR'),to_date('23-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (286,'promotion name# 286','manufacture rebate magazine','magazine',26900,to_date('22-JUL-98','DD-MON-RR'),to_date('22-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (287,'promotion name# 287','TV program sponsorship','TV',38500,to_date('19-JAN-99','DD-MON-RR'),to_date('19-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (288,'promotion name# 288','coupon magazine','magazine',46100,to_date('21-FEB-00','DD-MON-RR'),to_date('21-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (289,'promotion name# 289','coupon magazine','magazine',47600,to_date('03-SEP-98','DD-MON-RR'),to_date('03-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (290,'promotion name# 290','household flyer','flyer',62500,to_date('05-APR-99','DD-MON-RR'),to_date('05-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (291,'promotion name# 291','hospital flyer','flyer',82700,to_date('06-AUG-00','DD-MON-RR'),to_date('06-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (292,'promotion name# 292','ad','internet',68100,to_date('10-NOV-98','DD-MON-RR'),to_date('10-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (293,'promotion name# 293','online discount','internet',30700,to_date('27-MAR-99','DD-MON-RR'),to_date('27-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (294,'promotion name# 294','ad magazine','magazine',89700,to_date('12-MAY-00','DD-MON-RR'),to_date('12-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (295,'promotion name# 295','TV commercial','TV',3100,to_date('20-JUN-98','DD-MON-RR'),to_date('20-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (296,'promotion name# 296','manufacture rebate news','newspaper',57700,to_date('24-OCT-99','DD-MON-RR'),to_date('24-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (297,'promotion name# 297','promotion movie','TV',55200,to_date('07-DEC-00','DD-MON-RR'),to_date('07-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (298,'promotion name# 298','coupon news','newspaper',64000,to_date('01-JUL-98','DD-MON-RR'),to_date('01-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (299,'promotion name# 299','TV program sponsorship','TV',97600,to_date('29-JAN-99','DD-MON-RR'),to_date('29-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (300,'promotion name# 300','TV commercial','TV',88300,to_date('14-FEB-00','DD-MON-RR'),to_date('14-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (301,'promotion name# 301','downtown billboard','post',16100,to_date('02-SEP-98','DD-MON-RR'),to_date('02-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (302,'promotion name# 302','hospital flyer','flyer',52300,to_date('09-APR-99','DD-MON-RR'),to_date('09-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (303,'promotion name# 303','coupon news','newspaper',62100,to_date('28-AUG-00','DD-MON-RR'),to_date('28-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (304,'promotion name# 304','manufacture rebate news','newspaper',72000,to_date('04-NOV-98','DD-MON-RR'),to_date('04-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (305,'promotion name# 305','TV program sponsorship','TV',8900,to_date('15-MAR-99','DD-MON-RR'),to_date('15-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (306,'promotion name# 306','ad news','newspaper',61500,to_date('31-MAY-00','DD-MON-RR'),to_date('30-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (307,'promotion name# 307','online discount','internet',5500,to_date('13-JUN-98','DD-MON-RR'),to_date('13-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (308,'promotion name# 308','manufacture rebate news','newspaper',21000,to_date('25-OCT-99','DD-MON-RR'),to_date('25-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (309,'promotion name# 309','billboard','post',6800,to_date('18-DEC-00','DD-MON-RR'),to_date('18-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (310,'promotion name# 310','coupon news','newspaper',81000,to_date('17-JUL-98','DD-MON-RR'),to_date('17-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (311,'promotion name# 311','TV commercial','TV',98300,to_date('08-JAN-99','DD-MON-RR'),to_date('08-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (312,'promotion name# 312','loyal customer discount','internet',81800,to_date('26-FEB-00','DD-MON-RR'),to_date('26-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (313,'promotion name# 313','hospital flyer','flyer',18800,to_date('11-SEP-98','DD-MON-RR'),to_date('11-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (314,'promotion name# 314','downtown billboard','post',99300,to_date('16-APR-99','DD-MON-RR'),to_date('16-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (315,'promotion name# 315','online discount','internet',58100,to_date('23-AUG-00','DD-MON-RR'),to_date('23-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (316,'promotion name# 316','TV program sponsorship','TV',65900,to_date('22-NOV-98','DD-MON-RR'),to_date('22-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (317,'promotion name# 317','freeway billboard','post',22300,to_date('19-MAR-99','DD-MON-RR'),to_date('19-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (318,'promotion name# 318','radio program sponsorship','radio',66800,to_date('21-MAY-00','DD-MON-RR'),to_date('21-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (319,'promotion name# 319','loyal customer discount','internet',71600,to_date('03-JUN-98','DD-MON-RR'),to_date('03-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (320,'promotion name# 320','downtown billboard','post',99100,to_date('05-OCT-99','DD-MON-RR'),to_date('05-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (321,'promotion name# 321','downtown billboard','post',2300,to_date('06-DEC-00','DD-MON-RR'),to_date('06-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (322,'promotion name# 322','TV commercial','TV',36300,to_date('10-JUL-98','DD-MON-RR'),to_date('10-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (323,'promotion name# 323','coupon news','newspaper',37700,to_date('27-JAN-99','DD-MON-RR'),to_date('27-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (324,'promotion name# 324','hospital flyer','flyer',24700,to_date('12-FEB-00','DD-MON-RR'),to_date('12-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (325,'promotion name# 325','online discount','internet',30100,to_date('20-SEP-98','DD-MON-RR'),to_date('20-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (326,'promotion name# 326','coupon news','newspaper',23200,to_date('24-APR-99','DD-MON-RR'),to_date('24-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (327,'promotion name# 327','TV program sponsorship','TV',15200,to_date('07-AUG-00','DD-MON-RR'),to_date('07-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (328,'promotion name# 328','online discount','internet',3000,to_date('01-NOV-98','DD-MON-RR'),to_date('01-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (329,'promotion name# 329','manufacture rebate magazine','magazine',29800,to_date('29-MAR-99','DD-MON-RR'),to_date('29-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (330,'promotion name# 330','manufacture rebate magazine','magazine',40400,to_date('14-MAY-00','DD-MON-RR'),to_date('14-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (331,'promotion name# 331','online discount','internet',71700,to_date('02-JUN-98','DD-MON-RR'),to_date('02-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (332,'promotion name# 332','online discount','internet',26100,to_date('09-OCT-99','DD-MON-RR'),to_date('09-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (333,'promotion name# 333','radio program sponsorship','radio',17100,to_date('28-DEC-00','DD-MON-RR'),to_date('28-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (334,'promotion name# 334','downtown billboard','post',28600,to_date('04-JUL-98','DD-MON-RR'),to_date('04-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (335,'promotion name# 335','freeway billboard','post',8300,to_date('15-JAN-99','DD-MON-RR'),to_date('15-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (336,'promotion name# 336','ad news','newspaper',95900,to_date('13-FEB-00','DD-MON-RR'),to_date('13-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (337,'promotion name# 337','online discount','internet',17600,to_date('25-SEP-98','DD-MON-RR'),to_date('25-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (338,'promotion name# 338','coupon news','newspaper',67200,to_date('18-APR-99','DD-MON-RR'),to_date('18-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (339,'promotion name# 339','coupon news','newspaper',82300,to_date('17-AUG-00','DD-MON-RR'),to_date('17-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (340,'promotion name# 340','TV program sponsorship','TV',57400,to_date('08-NOV-98','DD-MON-RR'),to_date('08-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (341,'promotion name# 341','TV program sponsorship','TV',72400,to_date('30-MAR-99','DD-MON-RR'),to_date('30-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (342,'promotion name# 342','coupon news','newspaper',19600,to_date('26-MAY-00','DD-MON-RR'),to_date('26-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (343,'promotion name# 343','coupon news','newspaper',19800,to_date('11-JUN-98','DD-MON-RR'),to_date('11-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (344,'promotion name# 344','coupon news','newspaper',75600,to_date('16-OCT-99','DD-MON-RR'),to_date('16-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (345,'promotion name# 345','loyal customer discount','internet',4300,to_date('23-DEC-00','DD-MON-RR'),to_date('23-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (346,'promotion name# 346','ad','internet',89800,to_date('22-JUL-98','DD-MON-RR'),to_date('22-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (347,'promotion name# 347','freeway billboard','post',31000,to_date('19-JAN-99','DD-MON-RR'),to_date('19-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (348,'promotion name# 348','coupon magazine','magazine',72500,to_date('21-FEB-00','DD-MON-RR'),to_date('21-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (349,'promotion name# 349','downtown billboard','post',47500,to_date('03-SEP-98','DD-MON-RR'),to_date('03-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (350,'promotion name# 350','general flyer','flyer',34600,to_date('05-APR-99','DD-MON-RR'),to_date('05-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (351,'promotion name# 351','TV program sponsorship','TV',67900,to_date('06-AUG-00','DD-MON-RR'),to_date('06-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (352,'promotion name# 352','TV program sponsorship','TV',75800,to_date('10-NOV-98','DD-MON-RR'),to_date('10-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (353,'promotion name# 353','coupon magazine','magazine',60100,to_date('27-MAR-99','DD-MON-RR'),to_date('27-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (354,'promotion name# 354','ad','internet',18500,to_date('12-MAY-00','DD-MON-RR'),to_date('12-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (355,'promotion name# 355','hospital flyer','flyer',15600,to_date('20-JUN-98','DD-MON-RR'),to_date('20-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (356,'promotion name# 356','manufacture rebate magazine','magazine',13700,to_date('24-OCT-99','DD-MON-RR'),to_date('24-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (357,'promotion name# 357','coupon news','newspaper',89000,to_date('07-DEC-00','DD-MON-RR'),to_date('07-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (358,'promotion name# 358','ad','internet',9600,to_date('01-JUL-98','DD-MON-RR'),to_date('01-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (359,'promotion name# 359','TV commercial','TV',55000,to_date('29-JAN-99','DD-MON-RR'),to_date('29-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (360,'promotion name# 360','coupon magazine','magazine',8200,to_date('14-FEB-00','DD-MON-RR'),to_date('14-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (361,'promotion name# 361','general flyer','flyer',68000,to_date('02-SEP-98','DD-MON-RR'),to_date('02-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (362,'promotion name# 362','ad news','newspaper',2800,to_date('09-APR-99','DD-MON-RR'),to_date('09-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (363,'promotion name# 363','TV program sponsorship','TV',74900,to_date('28-AUG-00','DD-MON-RR'),to_date('28-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (364,'promotion name# 364','TV program sponsorship','TV',10800,to_date('04-NOV-98','DD-MON-RR'),to_date('04-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (365,'promotion name# 365','ad news','newspaper',87100,to_date('15-MAR-99','DD-MON-RR'),to_date('15-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (366,'promotion name# 366','freeway billboard','post',84900,to_date('31-MAY-00','DD-MON-RR'),to_date('30-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (367,'promotion name# 367','promotion movie','TV',76500,to_date('13-JUN-98','DD-MON-RR'),to_date('13-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (368,'promotion name# 368','online discount','internet',53600,to_date('25-OCT-99','DD-MON-RR'),to_date('25-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (369,'promotion name# 369','radio commercial','radio',21200,to_date('18-DEC-00','DD-MON-RR'),to_date('18-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (370,'promotion name# 370','TV program sponsorship','TV',62600,to_date('17-JUL-98','DD-MON-RR'),to_date('17-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (371,'promotion name# 371','TV program sponsorship','TV',9700,to_date('08-JAN-99','DD-MON-RR'),to_date('08-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (372,'promotion name# 372','downtown billboard','post',82900,to_date('26-FEB-00','DD-MON-RR'),to_date('26-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (373,'promotion name# 373','coupon magazine','magazine',23000,to_date('11-SEP-98','DD-MON-RR'),to_date('11-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (374,'promotion name# 374','TV program sponsorship','TV',60300,to_date('16-APR-99','DD-MON-RR'),to_date('16-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (375,'promotion name# 375','coupon news','newspaper',74300,to_date('23-AUG-00','DD-MON-RR'),to_date('23-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (376,'promotion name# 376','coupon magazine','magazine',45200,to_date('22-NOV-98','DD-MON-RR'),to_date('22-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (377,'promotion name# 377','downtown billboard','post',99200,to_date('19-MAR-99','DD-MON-RR'),to_date('19-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (378,'promotion name# 378','radio program sponsorship','radio',30200,to_date('21-MAY-00','DD-MON-RR'),to_date('21-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (379,'promotion name# 379','ad news','newspaper',51100,to_date('03-JUN-98','DD-MON-RR'),to_date('03-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (380,'promotion name# 380','ad magazine','magazine',30000,to_date('05-OCT-99','DD-MON-RR'),to_date('05-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (381,'promotion name# 381','coupon news','newspaper',96200,to_date('06-DEC-00','DD-MON-RR'),to_date('06-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (382,'promotion name# 382','ad news','newspaper',400,to_date('10-JUL-98','DD-MON-RR'),to_date('10-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (383,'promotion name# 383','online discount','internet',10700,to_date('27-JAN-99','DD-MON-RR'),to_date('27-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (384,'promotion name# 384','TV program sponsorship','TV',59200,to_date('12-FEB-00','DD-MON-RR'),to_date('12-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (385,'promotion name# 385','promotion movie','TV',70100,to_date('20-SEP-98','DD-MON-RR'),to_date('20-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (386,'promotion name# 386','manufacture rebate magazine','magazine',84200,to_date('24-APR-99','DD-MON-RR'),to_date('24-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (387,'promotion name# 387','TV program sponsorship','TV',83000,to_date('07-AUG-00','DD-MON-RR'),to_date('07-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (388,'promotion name# 388','coupon magazine','magazine',50900,to_date('01-NOV-98','DD-MON-RR'),to_date('01-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (389,'promotion name# 389','coupon magazine','magazine',75100,to_date('29-MAR-99','DD-MON-RR'),to_date('29-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (390,'promotion name# 390','household flyer','flyer',66600,to_date('14-MAY-00','DD-MON-RR'),to_date('14-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (391,'promotion name# 391','hospital flyer','flyer',15800,to_date('02-JUN-98','DD-MON-RR'),to_date('02-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (392,'promotion name# 392','ad','internet',69500,to_date('09-OCT-99','DD-MON-RR'),to_date('09-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (393,'promotion name# 393','online discount','internet',17700,to_date('28-DEC-00','DD-MON-RR'),to_date('28-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (394,'promotion name# 394','ad magazine','magazine',95100,to_date('04-JUL-98','DD-MON-RR'),to_date('04-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (395,'promotion name# 395','TV commercial','TV',97100,to_date('15-JAN-99','DD-MON-RR'),to_date('15-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (396,'promotion name# 396','manufacture rebate news','newspaper',49700,to_date('13-FEB-00','DD-MON-RR'),to_date('13-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (397,'promotion name# 397','promotion movie','TV',43000,to_date('25-SEP-98','DD-MON-RR'),to_date('25-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (398,'promotion name# 398','coupon news','newspaper',90800,to_date('18-APR-99','DD-MON-RR'),to_date('18-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (399,'promotion name# 399','TV program sponsorship','TV',7300,to_date('17-AUG-00','DD-MON-RR'),to_date('17-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (400,'promotion name# 400','TV commercial','TV',18700,to_date('08-NOV-98','DD-MON-RR'),to_date('08-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (401,'promotion name# 401','downtown billboard','post',71400,to_date('30-MAR-99','DD-MON-RR'),to_date('30-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (402,'promotion name# 402','hospital flyer','flyer',43300,to_date('26-MAY-00','DD-MON-RR'),to_date('26-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (403,'promotion name# 403','coupon news','newspaper',73600,to_date('11-JUN-98','DD-MON-RR'),to_date('11-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (404,'promotion name# 404','manufacture rebate news','newspaper',51700,to_date('16-OCT-99','DD-MON-RR'),to_date('16-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (405,'promotion name# 405','TV program sponsorship','TV',96500,to_date('23-DEC-00','DD-MON-RR'),to_date('23-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (406,'promotion name# 406','ad news','newspaper',84100,to_date('22-JUL-98','DD-MON-RR'),to_date('22-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (407,'promotion name# 407','online discount','internet',55100,to_date('19-JAN-99','DD-MON-RR'),to_date('19-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (408,'promotion name# 408','manufacture rebate news','newspaper',36100,to_date('21-FEB-00','DD-MON-RR'),to_date('21-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (409,'promotion name# 409','billboard','post',82800,to_date('03-SEP-98','DD-MON-RR'),to_date('03-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (410,'promotion name# 410','coupon news','newspaper',96000,to_date('05-APR-99','DD-MON-RR'),to_date('05-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (411,'promotion name# 411','TV commercial','TV',45500,to_date('06-AUG-00','DD-MON-RR'),to_date('06-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (412,'promotion name# 412','loyal customer discount','internet',82000,to_date('10-NOV-98','DD-MON-RR'),to_date('10-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (413,'promotion name# 413','hospital flyer','flyer',74600,to_date('27-MAR-99','DD-MON-RR'),to_date('27-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (414,'promotion name# 414','downtown billboard','post',28000,to_date('12-MAY-00','DD-MON-RR'),to_date('12-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (415,'promotion name# 415','online discount','internet',42700,to_date('20-JUN-98','DD-MON-RR'),to_date('20-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (416,'promotion name# 416','TV program sponsorship','TV',7100,to_date('24-OCT-99','DD-MON-RR'),to_date('24-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (417,'promotion name# 417','freeway billboard','post',63800,to_date('07-DEC-00','DD-MON-RR'),to_date('07-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (418,'promotion name# 418','radio program sponsorship','radio',41800,to_date('01-JUL-98','DD-MON-RR'),to_date('01-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (419,'promotion name# 419','loyal customer discount','internet',58700,to_date('29-JAN-99','DD-MON-RR'),to_date('29-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (420,'promotion name# 420','downtown billboard','post',31500,to_date('14-FEB-00','DD-MON-RR'),to_date('14-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (421,'promotion name# 421','downtown billboard','post',10200,to_date('02-SEP-98','DD-MON-RR'),to_date('02-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (422,'promotion name# 422','TV commercial','TV',20600,to_date('09-APR-99','DD-MON-RR'),to_date('09-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (423,'promotion name# 423','coupon news','newspaper',97000,to_date('28-AUG-00','DD-MON-RR'),to_date('28-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (424,'promotion name# 424','hospital flyer','flyer',21800,to_date('04-NOV-98','DD-MON-RR'),to_date('04-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (425,'promotion name# 425','online discount','internet',28200,to_date('15-MAR-99','DD-MON-RR'),to_date('15-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (426,'promotion name# 426','coupon news','newspaper',98500,to_date('31-MAY-00','DD-MON-RR'),to_date('30-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (427,'promotion name# 427','TV program sponsorship','TV',36700,to_date('13-JUN-98','DD-MON-RR'),to_date('13-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (428,'promotion name# 428','online discount','internet',48400,to_date('25-OCT-99','DD-MON-RR'),to_date('25-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (429,'promotion name# 429','manufacture rebate magazine','magazine',83900,to_date('18-DEC-00','DD-MON-RR'),to_date('18-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (430,'promotion name# 430','manufacture rebate magazine','magazine',6500,to_date('17-JUL-98','DD-MON-RR'),to_date('17-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (431,'promotion name# 431','online discount','internet',98200,to_date('08-JAN-99','DD-MON-RR'),to_date('08-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (432,'promotion name# 432','online discount','internet',53900,to_date('26-FEB-00','DD-MON-RR'),to_date('26-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (433,'promotion name# 433','radio program sponsorship','radio',4000,to_date('11-SEP-98','DD-MON-RR'),to_date('11-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (434,'promotion name# 434','downtown billboard','post',6100,to_date('16-APR-99','DD-MON-RR'),to_date('16-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (435,'promotion name# 435','freeway billboard','post',87500,to_date('23-AUG-00','DD-MON-RR'),to_date('23-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (436,'promotion name# 436','ad news','newspaper',95600,to_date('22-NOV-98','DD-MON-RR'),to_date('22-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (437,'promotion name# 437','online discount','internet',34800,to_date('19-MAR-99','DD-MON-RR'),to_date('19-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (438,'promotion name# 438','coupon news','newspaper',22800,to_date('21-MAY-00','DD-MON-RR'),to_date('21-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (439,'promotion name# 439','coupon news','newspaper',4500,to_date('03-JUN-98','DD-MON-RR'),to_date('03-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (440,'promotion name# 440','TV program sponsorship','TV',44700,to_date('05-OCT-99','DD-MON-RR'),to_date('05-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (441,'promotion name# 441','TV program sponsorship','TV',60600,to_date('06-DEC-00','DD-MON-RR'),to_date('06-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (442,'promotion name# 442','coupon news','newspaper',57100,to_date('10-JUL-98','DD-MON-RR'),to_date('10-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (443,'promotion name# 443','coupon news','newspaper',89600,to_date('27-JAN-99','DD-MON-RR'),to_date('27-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (444,'promotion name# 444','coupon news','newspaper',76100,to_date('12-FEB-00','DD-MON-RR'),to_date('12-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (445,'promotion name# 445','loyal customer discount','internet',42900,to_date('20-SEP-98','DD-MON-RR'),to_date('20-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (446,'promotion name# 446','ad','internet',62900,to_date('24-APR-99','DD-MON-RR'),to_date('24-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (447,'promotion name# 447','freeway billboard','post',93400,to_date('07-AUG-00','DD-MON-RR'),to_date('07-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (448,'promotion name# 448','coupon magazine','magazine',26400,to_date('01-NOV-98','DD-MON-RR'),to_date('01-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (449,'promotion name# 449','downtown billboard','post',73000,to_date('29-MAR-99','DD-MON-RR'),to_date('29-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (450,'promotion name# 450','general flyer','flyer',86100,to_date('14-MAY-00','DD-MON-RR'),to_date('14-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (451,'promotion name# 451','TV program sponsorship','TV',7700,to_date('02-JUN-98','DD-MON-RR'),to_date('02-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (452,'promotion name# 452','TV program sponsorship','TV',29400,to_date('09-OCT-99','DD-MON-RR'),to_date('09-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (453,'promotion name# 453','coupon magazine','magazine',29700,to_date('28-DEC-00','DD-MON-RR'),to_date('28-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (454,'promotion name# 454','ad','internet',12500,to_date('04-JUL-98','DD-MON-RR'),to_date('04-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (455,'promotion name# 455','hospital flyer','flyer',56900,to_date('15-JAN-99','DD-MON-RR'),to_date('15-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (456,'promotion name# 456','manufacture rebate magazine','magazine',33800,to_date('13-FEB-00','DD-MON-RR'),to_date('13-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (457,'promotion name# 457','coupon news','newspaper',46500,to_date('25-SEP-98','DD-MON-RR'),to_date('25-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (458,'promotion name# 458','ad','internet',58300,to_date('18-APR-99','DD-MON-RR'),to_date('18-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (459,'promotion name# 459','TV commercial','TV',20800,to_date('17-AUG-00','DD-MON-RR'),to_date('17-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (460,'promotion name# 460','coupon magazine','magazine',51900,to_date('08-NOV-98','DD-MON-RR'),to_date('08-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (461,'promotion name# 461','general flyer','flyer',51400,to_date('30-MAR-99','DD-MON-RR'),to_date('30-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (462,'promotion name# 462','ad news','newspaper',12800,to_date('26-MAY-00','DD-MON-RR'),to_date('26-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (463,'promotion name# 463','TV program sponsorship','TV',39700,to_date('11-JUN-98','DD-MON-RR'),to_date('11-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (464,'promotion name# 464','TV program sponsorship','TV',78200,to_date('16-OCT-99','DD-MON-RR'),to_date('16-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (465,'promotion name# 465','ad news','newspaper',23400,to_date('23-DEC-00','DD-MON-RR'),to_date('23-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (466,'promotion name# 466','freeway billboard','post',71000,to_date('22-JUL-98','DD-MON-RR'),to_date('22-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (467,'promotion name# 467','promotion movie','TV',32600,to_date('19-JAN-99','DD-MON-RR'),to_date('19-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (468,'promotion name# 468','online discount','internet',14400,to_date('21-FEB-00','DD-MON-RR'),to_date('21-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (469,'promotion name# 469','radio commercial','radio',82500,to_date('03-SEP-98','DD-MON-RR'),to_date('03-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (470,'promotion name# 470','TV program sponsorship','TV',12300,to_date('05-APR-99','DD-MON-RR'),to_date('05-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (471,'promotion name# 471','TV program sponsorship','TV',1100,to_date('06-AUG-00','DD-MON-RR'),to_date('06-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (472,'promotion name# 472','downtown billboard','post',4200,to_date('10-NOV-98','DD-MON-RR'),to_date('10-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (473,'promotion name# 473','coupon magazine','magazine',61900,to_date('27-MAR-99','DD-MON-RR'),to_date('27-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (474,'promotion name# 474','TV program sponsorship','TV',16200,to_date('12-MAY-00','DD-MON-RR'),to_date('12-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (475,'promotion name# 475','coupon news','newspaper',80200,to_date('20-JUN-98','DD-MON-RR'),to_date('20-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (476,'promotion name# 476','coupon magazine','magazine',76900,to_date('24-OCT-99','DD-MON-RR'),to_date('24-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (477,'promotion name# 477','downtown billboard','post',64300,to_date('07-DEC-00','DD-MON-RR'),to_date('07-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (478,'promotion name# 478','radio program sponsorship','radio',80400,to_date('01-JUL-98','DD-MON-RR'),to_date('01-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (479,'promotion name# 479','ad news','newspaper',31800,to_date('29-JAN-99','DD-MON-RR'),to_date('29-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (480,'promotion name# 480','ad magazine','magazine',93900,to_date('14-FEB-00','DD-MON-RR'),to_date('14-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (481,'promotion name# 481','coupon news','newspaper',65000,to_date('02-SEP-98','DD-MON-RR'),to_date('02-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (482,'promotion name# 482','ad news','newspaper',73900,to_date('09-APR-99','DD-MON-RR'),to_date('09-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (483,'promotion name# 483','online discount','internet',34500,to_date('28-AUG-00','DD-MON-RR'),to_date('28-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (484,'promotion name# 484','TV program sponsorship','TV',40000,to_date('04-NOV-98','DD-MON-RR'),to_date('04-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (485,'promotion name# 485','promotion movie','TV',61000,to_date('15-MAR-99','DD-MON-RR'),to_date('15-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (486,'promotion name# 486','manufacture rebate magazine','magazine',67800,to_date('31-MAY-00','DD-MON-RR'),to_date('30-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (487,'promotion name# 487','TV program sponsorship','TV',47900,to_date('13-JUN-98','DD-MON-RR'),to_date('13-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (488,'promotion name# 488','coupon magazine','magazine',45300,to_date('25-OCT-99','DD-MON-RR'),to_date('25-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (489,'promotion name# 489','coupon magazine','magazine',26200,to_date('18-DEC-00','DD-MON-RR'),to_date('18-JAN-01','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (490,'promotion name# 490','household flyer','flyer',45000,to_date('17-JUL-98','DD-MON-RR'),to_date('17-SEP-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (491,'promotion name# 491','hospital flyer','flyer',43400,to_date('08-JAN-99','DD-MON-RR'),to_date('08-APR-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (492,'promotion name# 492','ad','internet',600,to_date('26-FEB-00','DD-MON-RR'),to_date('26-MAR-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (493,'promotion name# 493','online discount','internet',66500,to_date('11-SEP-98','DD-MON-RR'),to_date('11-NOV-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (494,'promotion name# 494','ad magazine','magazine',88800,to_date('16-APR-99','DD-MON-RR'),to_date('16-JUL-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (495,'promotion name# 495','TV commercial','TV',54700,to_date('23-AUG-00','DD-MON-RR'),to_date('23-SEP-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (496,'promotion name# 496','manufacture rebate news','newspaper',25400,to_date('22-NOV-98','DD-MON-RR'),to_date('22-JAN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (497,'promotion name# 497','promotion movie','TV',23600,to_date('19-MAR-99','DD-MON-RR'),to_date('19-JUN-99','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (498,'promotion name# 498','coupon news','newspaper',25900,to_date('21-MAY-00','DD-MON-RR'),to_date('21-JUN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (499,'promotion name# 499','TV program sponsorship','TV',62200,to_date('03-JUN-98','DD-MON-RR'),to_date('03-AUG-98','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (500,'promotion name# 500','TV commercial','TV',99900,to_date('05-OCT-99','DD-MON-RR'),to_date('05-JAN-00','DD-MON-RR'));
Insert into PROMOTIONS (PROMO_ID,PROMO_NAME,PROMO_SUBCATEGORY,PROMO_CATEGORY,PROMO_COST,PROMO_BEGIN_DATE,PROMO_END_DATE) values (9999,'NO PROMOTION','NO RPOMOTION','NO PROMOTION',0,to_date('01-JAN-99','DD-MON-RR'),to_date('01-JAN-99','DD-MON-RR'));
--------------------------------------------------------
--  DDL for Index PROMO_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "PROMO_PK" ON "PROMOTIONS" ("PROMO_ID") 
  ;
--------------------------------------------------------
--  Constraints for Table PROMOTIONS
--------------------------------------------------------

  ALTER TABLE "PROMOTIONS" MODIFY ("PROMO_NAME" CONSTRAINT "PROMO_NAME_NN" NOT NULL ENABLE);
  ALTER TABLE "PROMOTIONS" MODIFY ("PROMO_SUBCATEGORY" CONSTRAINT "PROMO_SUBCAT_NN" NOT NULL ENABLE);
  ALTER TABLE "PROMOTIONS" MODIFY ("PROMO_CATEGORY" CONSTRAINT "PROMO_CAT_NN" NOT NULL ENABLE);
  ALTER TABLE "PROMOTIONS" MODIFY ("PROMO_COST" CONSTRAINT "PROMO_COST_NN" NOT NULL ENABLE);
  ALTER TABLE "PROMOTIONS" MODIFY ("PROMO_BEGIN_DATE" CONSTRAINT "PROMO_BEGIN_DATE_NN" NOT NULL ENABLE);
  ALTER TABLE "PROMOTIONS" MODIFY ("PROMO_END_DATE" CONSTRAINT "PROMO_END_DATE_NN" NOT NULL ENABLE);
  ALTER TABLE "PROMOTIONS" ADD CONSTRAINT "PROMO_PK" PRIMARY KEY ("PROMO_ID") RELY
  USING INDEX  ENABLE;
