SET PAGESIZE 100 SET LINE 132 SET ECHO ON /******************************************************** REM Wk6 Group A Project - Task 4 Rem February 17, 2013 REM Michelle Linde, Matthew Ferry, Billy Clark REM REM H:\CIS336\Team_A_Task4.txt REM Spool H:\CIS336\Team_A_Task4_Spool.txt *********************************************************/ --DROPS Child to Parent DROP TABLE Customer_Master CASCADE CONSTRAINTS PURGE; DROP TABLE Package_Master CASCADE CONSTRAINTS PURGE; DROP TABLE Channel_Type_Master CASCADE CONSTRAINTS PURGE; DROP TABLE Supplier_Master CASCADE CONSTRAINTS PURGE; DROP TABLE Rating_Master CASCADE CONSTRAINTS PURGE; DROP TABLE Employee_Master CASCADE CONSTRAINTS PURGE; DROP TABLE Reason_Code_Master CASCADE CONSTRAINTS PURGE; DROP TABLE Package_Content CASCADE CONSTRAINTS PURGE; DROP TABLE Service_Order CASCADE CONSTRAINTS PURGE; DROP TABLE Channels CASCADE CONSTRAINTS PURGE; DROP TABLE Programs CASCADE CONSTRAINTS PURGE; DROP TABLE Guide CASCADE CONSTRAINTS PURGE; DROP TABLE Billing CASCADE CONSTRAINTS PURGE; DROP TABLE Customer_Survey CASCADE CONSTRAINTS PURGE; /********************************************************/ --CREATE STATEMENTS - Parent to Child /********************************************************/ CREATE TABLE Employee_Master ( EmpID Number(5) NOT NULL, EmpFName Varchar2(15), EmpLName Varchar2(20), EmpPhone Varchar2(15), EmptAddr Varchar2(20), EmpCity Varchar2(20), EmpST Varchar2(2), EmpZip Number(5), EmpEmail Varchar2(50), CONSTRAINT PKEmployee_EmpID PRIMARY KEY (EmpID)); CREATE TABLE Reason_code_Master ( ReasonCD Number(3) NOT NULL, Reason Varchar(20), CONSTRAINT PKReason_Code_Master PRIMARY KEY (ReasonCD)); CREATE TABLE Customer_Master ( CustNo Number(5) NOT NULL, CustFName Varchar2(15), CustLName Varchar2(20), CustMInit Varchar2(1), CustAddr Varchar2(20), CustCity Varchar2(20), CustST Varchar2(2), CustZip Number(5), CustPhone Varchar2(15), CustEmail Varchar2(50), CustStrtDate Date, CustLastMod Date, BillCycleDate Number(2), CM_Comment Varchar2(80), CustEndDate Date, CustStatus Varchar2(8), ReasonCD Number(3), EmpID Number(5), CONSTRAINT PKCustomer_Master PRIMARY KEY (CustNo), CONSTRAINT FKCust_ReasonCD FOREIGN KEY (ReasonCD) References Reason_Code_Master, CONSTRAINT FKCust_EmpID FOREIGN KEY (EmpID) References Employee_Master); CREATE TABLE Billing ( BillNo Number(5) NOT NULL, BillDate Date, CustNo Number(5) NOT NULL, BillTax Decimal(4,2), BillAmtDue Decimal(5,2), BillPastDue Decimal(5,2), BillPaymtDue Date, BillPaymtRec Date, BillPaymtType Varchar2(6), CONSTRAINT PKBilling_No PRIMARY KEY (BillNo), CONSTRAINT FKBillCust_No FOREIGN KEY (CustNo) References Customer_Master); CREATE TABLE Channel_Type_Master ( ChannelTypeID Number(2) NOT NULL, ChannelTypeDesc Varchar2(15), CONSTRAINT PKChannelTypeID PRIMARY KEY (ChannelTypeID)); CREATE TABLE Supplier_Master ( SuppNo Number(5) NOT NULL, Supplier VarChar2(40), SuppContctFName VarChar2(40), SuppContctLName Varchar2(20), SuppPhone VarChar2(15), SuppAddr Varchar2(50), SuppCity Varchar2(15), SuppST Varchar2(2), SuppZip Varchar2(10), CONSTRAINT PKSupplier_Master PRIMARY KEY (SuppNo)); CREATE TABLE Package_Master ( PackNo Varchar2(4) NOT NULL, PackDesc Varchar2(15), PackPrice Decimal(5,2), CONSTRAINT PKPackNo PRIMARY KEY (PackNo)); CREATE TABLE Channels ( ChannelNo Number(5) NOT NULL, ChannelTypeId Number(2) NOT NULL, ChannelName Varchar2(15) NOT NULL, CONSTRAINT PK_Channels PRIMARY KEY (ChannelNo), CONSTRAINT FK_Channels_ChannelTypeID FOREIGN KEY (ChannelTypeID) References Channel_type_Master); CREATE TABLE Rating_Master ( RatingCD Varchar2(5) NOT NULL, RatingDesc Varchar2(40), CONSTRAINT PKRating_Master PRIMARY KEY (RatingCD)); CREATE TABLE Customer_Survey ( CustSurvNo Number(5) NOT NULL, CustSurvDate Date, CustNo Number(5) NOT NULL, ChannelNo Number(5) NOT NULL, CONSTRAINT PKCust_Surv PRIMARY KEY (CustSurvNo), CONSTRAINT FKCustSurv_CustNo FOREIGN KEY (CustNo) References Customer_Master, CONSTRAINT FKCustSurv_ChannelNo FOREIGN KEY (ChannelNo) References Channels); CREATE TABLE Programs ( ProgID Varchar2(8) NOT NULL, ProgName Varchar2(30) NOT NULL, ProgDesc Varchar2(100) NOT NULL, ProgLength Number(3) NOT NULL, RatingCd Varchar2(5) NOT NULL, SuppNo Number(5) NOT NULL, ChannelTypeId Number(2) NOT NULL, CONSTRAINT PK_Programs PRIMARY KEY (ProgID), CONSTRAINT FK_Programs_RatingCode FOREIGN KEY (RatingCD) References Rating_Master, CONSTRAINT FK_Programs_SuppNo FOREIGN KEY (SuppNo) References Supplier_Master, CONSTRAINT FK_Programs_ChannelTypeId FOREIGN KEY (ChannelTypeId) References Channel_Type_Master); CREATE TABLE Package_Content ( PackNo Varchar2(4) NOT NULL, ChannelNo Number(5) NOT NULL, CONSTRAINT PKPackage_Content PRIMARY KEY (PackNo,ChannelNo), CONSTRAINT FKPackage_PackNo FOREIGN KEY (PackNo) References Package_Master, CONSTRAINT FKPackage_ChannelNo FOREIGN KEY (ChannelNo) References Channels); CREATE TABLE Guide ( GuideDate Date NOT NULL, ProgID Varchar2(8) NOT NULL, ChannelNo Number(5) NOT NULL, CONSTRAINT FK_Guide_ProgramID FOREIGN KEY (ProgID) References Programs, CONSTRAINT FK_Guide_ChannelNo FOREIGN KEY (ChannelNo) References Channels, CONSTRAINT PK_Guide PRIMARY KEY (GuideDate,ProgID,ChannelNo)); CREATE TABLE Service_Order ( ServiceOrderNo Number(5) NOT NULL, CustNo Number(5) NOT NULL, PackNo Varchar2(4) NOT NULL, ServiceOrdDate Date NOT NULL, ServiceOrdTerm Number NOT NULL, CONSTRAINT PK_Service_Order PRIMARY KEY (ServiceOrderNo), CONSTRAINT FK_Service_Order_CustNo FOREIGN KEY (CustNo) References Customer_Master, CONSTRAINT FK_Service_Order_PackNo FOREIGN KEY (PackNo) References Package_Master); PROMPT***************************************** PROMPT* INSERTS FOR Database rows * PROMPT***************************************** /* Inserts into the Employee-Master Table */ INSERT INTO Employee_Master VALUES (10010, 'MICHELLE', 'LINDE', '817-903-2131', '13033 FENCEROW ROAD', 'FORT WORTH', 'TX', '76244', 'MICHLINDEUSA@YAHOO.COM'); INSERT INTO Employee_Master VALUES (10020, 'Boss', 'Man', '214-555-1212', '145 PARK AVE', 'BURLESON', 'TX', '76445', 'JOHNGDOE@GMAIL.COM'); INSERT INTO Employee_Master VALUES (10030, 'Matthew', 'Ferry', '817-355-3212', '300 Maple Lane', 'GrapeVine', 'TX', '76651', 'MatthewFerry@GMAIL.COM'); INSERT INTO Employee_Master VALUES (10040, 'Billy', 'Clark', '685-455-4212', '434 Western Way', 'Rhome', 'TX', '77445', 'BillyClark@GMAIL.COM'); /* Inserts into the Reason_code_Master Table */ INSERT INTO Reason_code_Master VALUES (100, 'Paid and Current'); INSERT INTO Reason_code_Master VALUES (101, 'Moving Subscribers'); INSERT INTO Reason_code_Master VALUES (102, 'Moving State'); INSERT INTO Reason_code_Master VALUES (103, 'Unreliable Service'); INSERT INTO Reason_code_Master VALUES (104, 'Fed Up'); INSERT INTO Reason_code_Master VALUES (105, 'No Cable Hookups'); INSERT INTO Reason_code_Master VALUES (106, 'Better Offer'); INSERT INTO Reason_code_Master VALUES (107, 'OverDue Bill'); /* Inserts into the Customer_Master Table */ INSERT INTO Customer_Master VALUES (11663, 'Michelle', 'Linde', 'L', '13033 FENCEROW ROAD', 'FORT WORTH', 'TX', '76244', '817-903-2131', 'MICHLINDEUSA@YAHOO.COM', '12-JAN-2013', NULL, 15, 'NO PHONE CALLS AFTER 19H00', NULL, NULL, NULL, NULL); INSERT INTO Customer_Master VALUES (11789, 'John', 'Doe', 'G', '145 Park Ave', 'BURLESON', 'TX', '76234', '214-555-1212', 'JOHNGDOE@GMAIL.COM', '2-JAN-2011', '3-MAR-2012', 15, NULL, '3-MAR-2012', 'INACTIVE', 103, 10010); INSERT INTO Customer_Master VALUES (11123, 'Mary', 'Contrary', 'A', '1450 Swings Road', 'Keller', 'TX', '76234', '214-554-1214', 'MCOntrart@GMAIL.COM', '12-FEB-2001', NULL, 30, NULL, NULL, NULL, NULL, NULL); INSERT INTO Customer_Master VALUES (11098, 'Abraham', 'Fink', 'B', '3145 Slide Circle', 'SouthLake', 'TX', '76206', '214-545-1215', 'Finkabra@GMAIL.COM', '2-Mar-2008', NULL, 15, NULL, NULL, NULL, NULL, NULL); INSERT INTO Customer_Master VALUES (11033, 'Alexander', 'Swardt', 'C', '145 Apple Lane', 'Grapevine', 'TX', '76299', '214-556-1216', 'AlexSwardt@GMAIL.COM', '22-JAN-2010', NULL, 15, NULL, NULL, NULL, NULL, NULL); INSERT INTO Customer_Master VALUES (11444, 'Tyler', 'Smith', 'D', '1445 Puddle Street', 'Venice', 'TX', '76232', '214-575-1217', 'SmithTy@GMAIL.COM', '2-APR-2004', '13-Nov-2012', 30, NULL, '3-MAR-2012', 'INACTIVE', 102, 10020); INSERT INTO Customer_Master VALUES (11203, 'Rhiley', 'Jones', 'E', '1545 Poodle Lane', 'Flower Mound', 'TX', '76233', '214-585-1218', 'Rhones@GMAIL.COM', '10-JAN-2013', NULL, 15, NULL, NULL, NULL, NULL, NULL); INSERT INTO Customer_Master VALUES (11534, 'Samuel', 'Setzer', 'F', '1645 Generic Street', 'Florence', 'TX', '76724', '214-559-1219', 'SamAdams@GMAIL.COM', '13-SEP-2010', NULL, 15, NULL, NULL, NULL, NULL, NULL); INSERT INTO Customer_Master VALUES (11635, 'Adam', 'Marks', 'G', '7145 Center Road', 'Justin', 'TX', '76237', '214-550-1210', 'MarksAs@GMAIL.COM', '30-OCT-2006', NULL, 30, NULL, NULL, NULL, NULL, NULL); INSERT INTO Customer_Master VALUES (11121, 'Jason', 'Peck', 'H', '8145 Green Trace', 'Rhome', 'TX', '76244', '214-255-1213', 'GraphicDesign@GMAIL.COM', '9-MAY-2011', '3-MAR-2012', 15, NULL, NULL, NULL, NULL, NULL); INSERT INTO Customer_Master VALUES (11114, 'Juan', 'Gonzales', 'I', '1495 Random Road', 'Decatur', 'TX', '76098', '214-355-1211', 'GonzalesJJ@GMAIL.COM', '12-JAN-2003', '23-Dec-2011', 15, NULL, '3-MAR-2012', 'INACTIVE', 104, 10010); INSERT INTO Customer_Master VALUES (11183, 'Chan', 'Lee', 'J', '1458 Lost Way', 'Euless', 'TX', '76514', '214-554-1242', 'LeeChan@GMAIL.COM', '2-FEB-2012', NULL, 30, NULL, NULL, NULL, NULL, NULL); INSERT INTO Customer_Master VALUES (11287, 'Ludwig', 'vonBeethoven', 'K', '1945 Round Circle', 'Haltom City', 'TX', '76555', '214-567-1212', 'MusicCity@GMAIL.COM', '2-JAN-2011', NULL, 15, NULL, NULL, NULL, NULL, NULL); INSERT INTO Customer_Master VALUES (11035, 'Calliope', 'Torres', 'L', '1045 Cloud Ave', 'ColleyVille', 'TX', '76231', '214-577-1212', 'Bones@GMAIL.COM', '2-JAN-2011', NULL, 15, NULL, NULL, NULL, NULL, NULL); INSERT INTO Customer_Master VALUES (11020, 'Derek', 'Shepherd', 'M', '1405 Broken Bend', 'Waco', 'TX', '76134', '214-885-1212', 'McDreamy@GMAIL.COM', '12-JAN-2009', '20-July-2012', 30, NULL, '3-MAR-2012', 'INACTIVE', 103, 10020); INSERT INTO Customer_Master VALUES (11456, 'James', 'Chicago', 'O', '1145 Dead End', 'Dakota', 'TX', '76224', '214-549-1242', 'Bond007@GMAIL.COM', '4-Mar-2011', NULL, 15, NULL, NULL, NULL, NULL, NULL); INSERT INTO Customer_Master VALUES (11987, 'Bruce', 'Australia', 'P', '1415 Bumpy Lane', 'Paris', 'TX', '76244', '214-244-5212', 'SunShine@GMAIL.COM', '22-JUN-2011', NULL, 15, NULL, NULL, NULL, NULL, NULL); INSERT INTO Customer_Master VALUES (11223, 'Nathan', 'Jackson', 'Q', '1451 Lois Lane', 'Lewisville', 'TX', '76244', '214-766-1612', 'JacksonN@GMAIL.COM', '2-JUL-2011', NULL, 15, NULL, NULL, NULL, NULL, NULL); /* Inserts into the Channel_Type_Master Table */ INSERT INTO Channel_Type_Master VALUES (10, 'MOVIES'); INSERT INTO Channel_Type_Master VALUES (20, 'NEWS'); INSERT INTO Channel_Type_Master VALUES (30, 'LIFESTYLE'); INSERT INTO Channel_Type_Master VALUES (40, 'DOCUMENTARY'); INSERT INTO Channel_Type_Master VALUES (50, 'SPORTS'); /* Inserts into the Supplier_Master Table */ INSERT INTO Supplier_Master VALUES (11101, 'NBC', 'JEFF', 'KING', '310-369-5231', 'WILSHIRE BLVD # 1200', 'LOS ANGELES', 'CA', '75221'); INSERT INTO Supplier_Master VALUES (11201, 'ABC', 'JACK', 'CAVERISI', '310-840-9966', 'WILSHIRE BLVD # 6306', 'LOS ANGELES', 'CA', '75221'); INSERT INTO Supplier_Master VALUES (11301, 'FOX', 'JANIS', 'CARMIKEL', '310-235-5233', '10960 WILSHIRE BLVD # 1200', 'LOS ANGELES', 'CA', '75221'); INSERT INTO Supplier_Master VALUES (11401, 'WARNER', 'SIMON', 'PHILIPS', '765-555-8872', '3701 W. OAK STREET', 'BURBANK', 'CA', '75221'); /* Inserts into the Package_Master table */ INSERT INTO Package_Master VALUES (1, 'Movies Galore', 30.00); INSERT INTO Package_Master VALUES (2, 'News Galore', 30.00); INSERT INTO Package_Master VALUES (3, 'Total Watcher', 40.00); INSERT INTO Package_Master VALUES (4, 'Couch Potato', 50.00); /* Inserts into Channels table */ INSERT INTO Channels VALUES (1, 10, 'HBO Movies'); INSERT INTO Channels VALUES (2, 10, 'Stars Movies'); INSERT INTO Channels VALUES (3, 20, 'News 5 TX'); INSERT INTO Channels VALUES (4, 20, 'CNN News'); INSERT INTO Channels VALUES (5, 30, 'DIY Network'); INSERT INTO Channels VALUES (6, 30, 'OWN'); INSERT INTO Channels VALUES (7, 40, 'Animal Planet'); INSERT INTO Channels VALUES (8, 40, 'History Channel'); INSERT INTO Channels VALUES (9, 50, 'ESPN'); INSERT INTO Channels VALUES (10, 50, 'FOX'); /* Inserts into the Rating_Master Table */ INSERT INTO Rating_Master VALUES ('G', 'GENERAL EXHIBITION'); INSERT INTO Rating_Master VALUES ('PG', 'PARENTAL GUIDANCE'); INSERT INTO Rating_Master VALUES ('PG-13', 'PARENTAL GUIDANCE UNDER AGE 13'); INSERT INTO Rating_Master VALUES ('R', 'RESTRICTED - ADULTS ONLY'); INSERT INTO Rating_Master VALUES ('MA', 'MATURE AUDIENCE RECOMMENDED'); INSERT INTO Rating_Master VALUES ('M', 'MATURE AUDIENCE 15+'); /* Inserts into the Billing Table */ INSERT INTO Billing VALUES (11020, '30-MAR-2012', 11020, '8.25', 32.48, 0, '30-APR-2012', '16-MAY-2012', 'Check'); INSERT INTO Billing VALUES (11021, '15-JAN-2013', 11033, '8.25', 32.48, 0, '15-FEB-2013', NULL, NULL); INSERT INTO Billing VALUES (11022, '15-JAN-2013', 11035, '8.25', 43.40, 0, '15-FEB-2013', NULL, NULL); INSERT INTO Billing VALUES (11023, '15-JAN-2013', 11098, '8.25', 54.13, 0, '15-FEB-2013', NULL, NULL); INSERT INTO Billing VALUES (11024, '15-JAN-2013', 11121, '8.25', 32.48, 0, '15-FEB-2013', NULL, NULL); INSERT INTO Billing VALUES (11025, '30-JAN-2013', 11123, '8.25', 32.48, 0, '28-FEB-2013', NULL, NULL); INSERT INTO Billing VALUES (11026, '15-JAN-2013', 11203, '8.25', 54.13, 0, '15-FEB-2013', NULL, NULL); INSERT INTO Billing VALUES (11027, '15-JAN-2013', 11223, '8.25', 32.48, 0, '15-FEB-2013', NULL, NULL); INSERT INTO Billing VALUES (11028, '15-JAN-2013', 11287, '8.25', 32.48, 0, '15-FEB-2013', NULL, NULL); INSERT INTO Billing VALUES (11029, '30-JAN-2013', 11444, '8.25', 43.40, 43.40, '30-MAR-2012', NULL, NULL); INSERT INTO Billing VALUES (11030, '15-JAN-2013', 11456, '8.25', 54.13, 0, '15-FEB-2013', NULL, NULL); /* Inserts into the Customer_Survey Table */ INSERT INTO Customer_Survey VALUES (100, '03-JAN-2012', 11020, 3); INSERT INTO Customer_Survey VALUES (101, '04-JAN-2012', 11033, 6); INSERT INTO Customer_Survey VALUES (103, '05-JAN-2012', 11035, 8); INSERT INTO Customer_Survey VALUES (104, '05-JAN-2012', 11098, 9); INSERT INTO Customer_Survey VALUES (105, '05-JAN-2012', 11114, 7); INSERT INTO Customer_Survey VALUES (106, '10-JAN-2012', 11123, 4); INSERT INTO Customer_Survey VALUES (107, '10-JAN-2012', 11183, 8); INSERT INTO Customer_Survey VALUES (108, '11-JAN-2012', 11789, 1); INSERT INTO Customer_Survey VALUES (109, '11-JAN-2012', 11203, 10); INSERT INTO Customer_Survey VALUES (110, '19-JAN-2012', 11223, 1); INSERT INTO Customer_Survey VALUES (111, '23-JAN-2012', 11456, 1); INSERT INTO Customer_Survey VALUES (112, '27-JAN-2012', 11534, 1); /* Inserts into the Program Table */ /* MOVIES */ INSERT INTO PROGRAMS VALUES (3540,'Twinkle Toes in Paris','Romantic Drama about a Scottish Ballet Dancer making his fortune',180,'MA',11401, 10); INSERT INTO PROGRAMS VALUES (3541,'Segal in New York','Horror Action: Terrorists have taken over new York Cemetery. Can it be brought back under control?',120,'R',11201, 10); INSERT INTO PROGRAMS VALUES (3542,'Fantasia','Disney Favorite',145,'G',11301,10); INSERT INTO PROGRAMS VALUES (3566,'Dances with Fairies','New age movie showing the interaction of humans in the afterlife',120,'MA',11401,10); INSERT INTO PROGRAMS VALUES (4578,'Speed 34','The Space Shuttle is taken over aliens. Bruce Willis to fix the problem',120,'M',11201, 10); INSERT INTO PROGRAMS VALUES (50,'Prettier Woman','Drama: A Woman learns to deal with the truth in her life',120,'M',11301,10); INSERT INTO PROGRAMS VALUES (1008,'FLY KILLERS ARE BACK','FLIES ATTACK THE CITY ONCE AGAIN; THE BYGONE BRIGADE ARE BACK',175, 'MA',11101,10); INSERT INTO PROGRAMS VALUES (2003,'Angel Fire','Angel is back on the streets',120,'R',11201,10); INSERT INTO PROGRAMS VALUES (2635,'Star Wars the Trilogy','A Small rebel fleet takes on the Imperial Empire',270,'MA',11201,10); INSERT INTO PROGRAMS VALUES (1111,'Paid Programming','Paid Programming',30,'MA',11201,10); INSERT INTO PROGRAMS VALUES (2222,'Paid Programming','Paid Programming',30,'MA',11201,10); INSERT INTO PROGRAMS VALUES (3333,'Paid Programming','Paid Programming',30,'MA',11201,10); INSERT INTO PROGRAMS VALUES (4444,'Paid Programming','Paid Programming',30,'MA',11201,10); /* NEWS */ INSERT INTO PROGRAMS VALUES (2210,'NBC Tonight','News from around the world',360,'PG',11101, 20); INSERT INTO PROGRAMS VALUES (1688,'Weather Now','Weather updates about local and national weather',60,'G',11401,20); INSERT INTO PROGRAMS VALUES (9999,'CNN','CNN Latest News',60,'PG',11101,20); INSERT INTO PROGRAMS VALUES (8888,'The Morning Show','Daily Morning News',120,'PG',11301,20); INSERT INTO PROGRAMS VALUES (9658,'World News Now','World News',60,'PG',11101,20); INSERT INTO PROGRAMS VALUES (7458,'International Now','International World News',60,'PG',11301,20); /* LifeStyle */ INSERT INTO Programs VALUES (16, 'Sale of the Year', 'Game Show LifeStyle', 24, 'G', 11101, 30); INSERT INTO PROGRAMS VALUES (2564,'The Shopping Show','The Sites to see when you shope online',120,'G',11301,30); INSERT INTO PROGRAMS VALUES (998,'How I met your Mother','Comedy about How I met your mother',30,'PG',11401, 30); INSERT INTO PROGRAMS VALUES (2636,'GGomer Piles the Hero','Comedy Showing the advantages of being an army seargeant',30,'PG',11301,30); INSERT INTO PROGRAMS VALUES (6655,'You live in what?','Show about Odd places that people live',60,'G',11401,30); INSERT INTO PROGRAMS VALUES (5566,'Lets Shop','Show about International Shopping',60,'G',11401, 30); INSERT INTO PROGRAMS VALUES (2,'What not to Wear','Makeover show that stops people from wearing horrible clothes',60,'PG',11401, 30); INSERT INTO PROGRAMS VALUES (5544, 'Paid Programing','Paid Programming',60,'PG',11401,30); INSERT INTO PROGRAMS VALUES (4455, 'Paid Programing','Paid Programming',30,'PG',11401,30); INSERT INTO PROGRAMS VALUES (3344, 'Rednecks United','Rednecks on TV',60,'PG',11301,30); INSERT INTO PROGRAMS VALUES (5577, 'Fine Dining Tonight','All about Froofy Food',60,'PG',11301,30); INSERT INTO PROGRAMS VALUES (5543, 'Welcome to My World','Reality Show where people swap families',60,'PG',11101,30); /* Documentary */ INSERT INTO PROGRAMS VALUES (231,'OPERA BY THE NILE','LUCIANO PAVOROTTI SINGS OPERA ON THE NILE',240,'G',11201,40); INSERT INTO PROGRAMS VALUES (555,'Chef Wanted','Chefs compete for a Head Chef position',60,'PG',11401, 40); INSERT INTO PROGRAMS VALUES (777,'Pawn Stars','People selling stuff to people',30,'PG',11101, 40); INSERT INTO PROGRAMS VALUES (111,'I almost got away... ','Documentary about catching criminals that almost got away',60,'PG',11401, 40); INSERT INTO PROGRAMS VALUES (711,'Modern Marvels','History Show on Modern Technologies and where they came from',60,'PG',11101, 40); INSERT INTO PROGRAMS VALUES (811,'Strip this City','Inside Look at How cities survive and exist',60,'PG',11401, 40); INSERT INTO PROGRAMS VALUES (922,'Ice Road Truckers','Freight Hauling on ICE',60,'PG',11301, 40); INSERT INTO PROGRAMS VALUES (411,'American Pickers','Guys buying JUNK',60,'PG',11201, 40); INSERT INTO PROGRAMS VALUES (311,'Gold Rush','Wanna Be Miners',60,'PG',11201, 40); /* SPORTS */ INSERT INTO PROGRAMS VALUES (2889,'Lawn Bowl Championships','Live from Canberra',400,'G',11301,50); INSERT INTO PROGRAMS VALUES (2344,'Mud Wrestling','The mud pits come alive for the muddy challenge',120,'M',11101,50); INSERT INTO PROGRAMS VALUES (1399,'F1: 2012 Recap','Recap of the 2012 Season before 2013 begins',120,'PG',11401,50); INSERT INTO PROGRAMS VALUES (4888,'NBA Finals','NBA Playoff games',360,'G',11401, 50); INSERT INTO PROGRAMS VALUES (3331,'MLBA: Pre Season','Major League Baseball Pre Season News',90,'G',11401, 50); INSERT INTO PROGRAMS VALUES (3334,'NASCAR NATIONWIDE','NASCAR RACING',120,'G',11301,50); INSERT INTO PROGRAMS VALUES (3335,'NASCAR POST RACE','Post Race News',60,'G',11101,50); INSERT INTO PROGRAMS VALUES (4887,'World Racing News','Racing News from around the world',60,'G',11301,50); INSERT INTO PROGRAMS VALUES (4889,'HOCKEY GAME 1','HOCKEY',240,'G',11101,50); INSERT INTO PROGRAMS VALUES (7896,'HOCKEY GAME 2','HOCKEY',240,'G',11301,50); INSERT INTO PROGRAMS VALUES (7897,'GOLF PRO SERIES','Professional Golfing',120,'G',11101,50); INSERT INTO PROGRAMS VALUES (7898,'TENNIS PRO SERIES','Profession Tennis',60,'G',11301,50); INSERT INTO PROGRAMS VALUES (7888,'Swimming Finals','Swimming Competition',60,'G',11101,50); INSERT INTO PROGRAMS VALUES (9898,'NFL POST SEASON Lookback','Lookback at Last season highlights',60,'G',11301,50); INSERT INTO PROGRAMS VALUES (6565,'INSIDE NASCAR','Behing the Scenes of NASCAR',30,'G',11101,50); INSERT INTO PROGRAMS VALUES (2121,'Victory Lane','Drivers Talk about Winning',30,'G',11101,50); INSERT INTO PROGRAMS VALUES (3131,'Redneck Racers','People Racing cars that are hazardous because they exist',60,'G',11301,50); /* Inserts into the Package_Content Table */ INSERT INTO Package_Content VALUES (1, 1); INSERT INTO Package_Content VALUES (1, 2); INSERT INTO Package_Content VALUES (1, 3); INSERT INTO Package_Content VALUES (1, 6); INSERT INTO Package_Content VALUES (1, 7); INSERT INTO Package_Content VALUES (1, 9); INSERT INTO Package_Content VALUES (2, 1); INSERT INTO Package_Content VALUES (2, 3); INSERT INTO Package_Content VALUES (2, 4); INSERT INTO Package_Content VALUES (2, 6); INSERT INTO Package_Content VALUES (2, 7); INSERT INTO Package_Content VALUES (2, 9); INSERT INTO Package_Content VALUES (3, 1); INSERT INTO Package_Content VALUES (3, 2); INSERT INTO Package_Content VALUES (3, 3); INSERT INTO Package_Content VALUES (3, 6); INSERT INTO Package_Content VALUES (3, 7); INSERT INTO Package_Content VALUES (3, 8); INSERT INTO Package_Content VALUES (3, 9); INSERT INTO Package_Content VALUES (3, 10); INSERT INTO Package_Content VALUES (4, 1); INSERT INTO Package_Content VALUES (4, 2); INSERT INTO Package_Content VALUES (4, 3); INSERT INTO Package_Content VALUES (4, 4); INSERT INTO Package_Content VALUES (4, 5); INSERT INTO Package_Content VALUES (4, 6); INSERT INTO Package_Content VALUES (4, 7); INSERT INTO Package_Content VALUES (4, 8); INSERT INTO Package_Content VALUES (4, 9); INSERT INTO Package_Content VALUES (4, 10); /* Inserts into the Guide table */ INSERT INTO Guide VALUES (To_Date('01Mar2013 0000','DDMonYYYY HH24MI'),3541, 1); INSERT INTO Guide VALUES (To_Date('01Mar2013 0200','DDMonYYYY HH24MI'),4578, 1); INSERT INTO Guide VALUES (To_Date('01Mar2013 0400','DDMonYYYY HH24MI'),1008, 1); INSERT INTO Guide VALUES (To_Date('01Mar2013 0700','DDMonYYYY HH24MI'),2635, 1); INSERT INTO Guide VALUES (To_Date('01Mar2013 1130','DDMonYYYY HH24MI'),2003, 1); INSERT INTO Guide VALUES (To_Date('01Mar2013 1330','DDMonYYYY HH24MI'),50, 1); INSERT INTO Guide VALUES (To_Date('01Mar2013 1530','DDMonYYYY HH24MI'),3566, 1); INSERT INTO Guide VALUES (To_Date('01Mar2013 1730','DDMonYYYY HH24MI'),3542, 1); INSERT INTO Guide VALUES (To_Date('01Mar2013 2000','DDMonYYYY HH24MI'),3540, 1); INSERT INTO Guide VALUES (To_Date('01Mar2013 2330','DDMonYYYY HH24MI'),2222, 1); INSERT INTO Guide VALUES (To_Date('02Mar2013 0000','DDMonYYYY HH24MI'),3541, 1); INSERT INTO Guide VALUES (To_Date('02Mar2013 0200','DDMonYYYY HH24MI'),4578, 1); INSERT INTO Guide VALUES (To_Date('02Mar2013 0400','DDMonYYYY HH24MI'),1008, 1); INSERT INTO Guide VALUES (To_Date('02Mar2013 0700','DDMonYYYY HH24MI'),2635, 1); INSERT INTO Guide VALUES (To_Date('02Mar2013 1130','DDMonYYYY HH24MI'),2003, 1); INSERT INTO Guide VALUES (To_Date('02Mar2013 1330','DDMonYYYY HH24MI'),50, 1); INSERT INTO Guide VALUES (To_Date('02Mar2013 1530','DDMonYYYY HH24MI'),3566, 1); INSERT INTO Guide VALUES (To_Date('02Mar2013 1730','DDMonYYYY HH24MI'),3542, 1); INSERT INTO Guide VALUES (To_Date('02Mar2013 2000','DDMonYYYY HH24MI'),3540, 1); INSERT INTO Guide VALUES (To_Date('02Mar2013 2330','DDMonYYYY HH24MI'),3333, 1); INSERT INTO Guide VALUES (To_Date('03Mar2013 0000','DDMonYYYY HH24MI'),3541, 1); INSERT INTO Guide VALUES (To_Date('03Mar2013 0200','DDMonYYYY HH24MI'),4578, 1); INSERT INTO Guide VALUES (To_Date('03Mar2013 0400','DDMonYYYY HH24MI'),1008, 1); INSERT INTO Guide VALUES (To_Date('03Mar2013 0700','DDMonYYYY HH24MI'),2635, 1); INSERT INTO Guide VALUES (To_Date('03Mar2013 1130','DDMonYYYY HH24MI'),2003, 1); INSERT INTO Guide VALUES (To_Date('03Mar2013 1330','DDMonYYYY HH24MI'),50, 1); INSERT INTO Guide VALUES (To_Date('03Mar2013 1530','DDMonYYYY HH24MI'),3566, 1); INSERT INTO Guide VALUES (To_Date('03Mar2013 1730','DDMonYYYY HH24MI'),3542, 1); INSERT INTO Guide VALUES (To_Date('03Mar2013 2000','DDMonYYYY HH24MI'),3540, 1); INSERT INTO Guide VALUES (To_Date('03Mar2013 2330','DDMonYYYY HH24MI'),4444, 1); INSERT INTO Guide VALUES (To_Date('01Mar2013 0000','DDMonYYYY HH24MI'),3540, 2); INSERT INTO Guide VALUES (To_Date('01Mar2013 0300','DDMonYYYY HH24MI'),3541, 2); INSERT INTO Guide VALUES (To_Date('01Mar2013 0500','DDMonYYYY HH24MI'),3542, 2); INSERT INTO Guide VALUES (To_Date('01Mar2013 0730','DDMonYYYY HH24MI'),3566, 2); INSERT INTO Guide VALUES (To_Date('01Mar2013 0930','DDMonYYYY HH24MI'),4578, 2); INSERT INTO Guide VALUES (To_Date('01Mar2013 1130','DDMonYYYY HH24MI'),50, 2); INSERT INTO Guide VALUES (To_Date('01Mar2013 1330','DDMonYYYY HH24MI'),1008, 2); INSERT INTO Guide VALUES (To_Date('01Mar2013 1630','DDMonYYYY HH24MI'),2003, 2); INSERT INTO Guide VALUES (To_Date('01Mar2013 1830','DDMonYYYY HH24MI'),2635, 2); INSERT INTO Guide VALUES (To_Date('01Mar2013 2300','DDMonYYYY HH24MI'),1111, 2); INSERT INTO Guide VALUES (To_Date('01Mar2013 2330','DDMonYYYY HH24MI'),2222, 2); INSERT INTO Guide VALUES (To_Date('02Mar2013 0000','DDMonYYYY HH24MI'),3540, 2); INSERT INTO Guide VALUES (To_Date('02Mar2013 0300','DDMonYYYY HH24MI'),3541, 2); INSERT INTO Guide VALUES (To_Date('02Mar2013 0500','DDMonYYYY HH24MI'),3542, 2); INSERT INTO Guide VALUES (To_Date('02Mar2013 0730','DDMonYYYY HH24MI'),3566, 2); INSERT INTO Guide VALUES (To_Date('02Mar2013 0930','DDMonYYYY HH24MI'),4578, 2); INSERT INTO Guide VALUES (To_Date('02Mar2013 1130','DDMonYYYY HH24MI'),50, 2); INSERT INTO Guide VALUES (To_Date('02Mar2013 1330','DDMonYYYY HH24MI'),1008, 2); INSERT INTO Guide VALUES (To_Date('02Mar2013 1630','DDMonYYYY HH24MI'),2003, 2); INSERT INTO Guide VALUES (To_Date('02Mar2013 1830','DDMonYYYY HH24MI'),2635, 2); INSERT INTO Guide VALUES (To_Date('02Mar2013 2300','DDMonYYYY HH24MI'),3333, 2); INSERT INTO Guide VALUES (To_Date('02Mar2013 2330','DDMonYYYY HH24MI'),4444, 2); INSERT INTO Guide VALUES (To_Date('03Mar2013 0000','DDMonYYYY HH24MI'),3540, 2); INSERT INTO Guide VALUES (To_Date('03Mar2013 0300','DDMonYYYY HH24MI'),3541, 2); INSERT INTO Guide VALUES (To_Date('03Mar2013 0500','DDMonYYYY HH24MI'),3542, 2); INSERT INTO Guide VALUES (To_Date('03Mar2013 0730','DDMonYYYY HH24MI'),3566, 2); INSERT INTO Guide VALUES (To_Date('03Mar2013 0930','DDMonYYYY HH24MI'),4578, 2); INSERT INTO Guide VALUES (To_Date('03Mar2013 1130','DDMonYYYY HH24MI'),50, 2); INSERT INTO Guide VALUES (To_Date('03Mar2013 1330','DDMonYYYY HH24MI'),1008, 2); INSERT INTO Guide VALUES (To_Date('03Mar2013 1630','DDMonYYYY HH24MI'),2003, 2); INSERT INTO Guide VALUES (To_Date('03Mar2013 1830','DDMonYYYY HH24MI'),2635, 2); INSERT INTO Guide VALUES (To_Date('03Mar2013 2300','DDMonYYYY HH24MI'),1111, 2); INSERT INTO Guide VALUES (To_Date('03Mar2013 2330','DDMonYYYY HH24MI'),4444, 2); INSERT INTO Guide VALUES (To_Date('01Mar2013 0000','DDMonYYYY HH24MI'),2210, 3); INSERT INTO Guide VALUES (To_Date('01Mar2013 0600','DDMonYYYY HH24MI'),9999, 3); INSERT INTO Guide VALUES (To_Date('01Mar2013 0700','DDMonYYYY HH24MI'),9999, 3); INSERT INTO Guide VALUES (To_Date('01Mar2013 0800','DDMonYYYY HH24MI'),9999, 3); INSERT INTO Guide VALUES (To_Date('01Mar2013 0900','DDMonYYYY HH24MI'),9999, 3); INSERT INTO Guide VALUES (To_Date('01Mar2013 1000','DDMonYYYY HH24MI'),9999, 3); INSERT INTO Guide VALUES (To_Date('01Mar2013 1100','DDMonYYYY HH24MI'),9999, 3); INSERT INTO Guide VALUES (To_Date('01Mar2013 1200','DDMonYYYY HH24MI'),9999, 3); INSERT INTO Guide VALUES (To_Date('01Mar2013 1300','DDMonYYYY HH24MI'),9658, 3); INSERT INTO Guide VALUES (To_Date('01Mar2013 1400','DDMonYYYY HH24MI'),9658, 3); INSERT INTO Guide VALUES (To_Date('01Mar2013 1500','DDMonYYYY HH24MI'),9658, 3); INSERT INTO Guide VALUES (To_Date('01Mar2013 1600','DDMonYYYY HH24MI'),9658, 3); INSERT INTO Guide VALUES (To_Date('01Mar2013 1700','DDMonYYYY HH24MI'),9658, 3); INSERT INTO Guide VALUES (To_Date('01Mar2013 1800','DDMonYYYY HH24MI'),9658, 3); INSERT INTO Guide VALUES (To_Date('01Mar2013 1900','DDMonYYYY HH24MI'),7458, 3); INSERT INTO Guide VALUES (To_Date('01Mar2013 2000','DDMonYYYY HH24MI'),7458, 3); INSERT INTO Guide VALUES (To_Date('01Mar2013 2100','DDMonYYYY HH24MI'),7458, 3); INSERT INTO Guide VALUES (To_Date('01Mar2013 2200','DDMonYYYY HH24MI'),7458, 3); INSERT INTO Guide VALUES (To_Date('01Mar2013 2300','DDMonYYYY HH24MI'),7458, 3); INSERT INTO Guide VALUES (To_Date('02Mar2013 0000','DDMonYYYY HH24MI'),2210, 3); INSERT INTO Guide VALUES (To_Date('02Mar2013 0600','DDMonYYYY HH24MI'),9999, 3); INSERT INTO Guide VALUES (To_Date('02Mar2013 0700','DDMonYYYY HH24MI'),9999, 3); INSERT INTO Guide VALUES (To_Date('02Mar2013 0800','DDMonYYYY HH24MI'),9999, 3); INSERT INTO Guide VALUES (To_Date('02Mar2013 0900','DDMonYYYY HH24MI'),9999, 3); INSERT INTO Guide VALUES (To_Date('02Mar2013 1000','DDMonYYYY HH24MI'),9999, 3); INSERT INTO Guide VALUES (To_Date('02Mar2013 1100','DDMonYYYY HH24MI'),9999, 3); INSERT INTO Guide VALUES (To_Date('02Mar2013 1200','DDMonYYYY HH24MI'),9999, 3); INSERT INTO Guide VALUES (To_Date('02Mar2013 1300','DDMonYYYY HH24MI'),9658, 3); INSERT INTO Guide VALUES (To_Date('02Mar2013 1400','DDMonYYYY HH24MI'),9658, 3); INSERT INTO Guide VALUES (To_Date('02Mar2013 1500','DDMonYYYY HH24MI'),9658, 3); INSERT INTO Guide VALUES (To_Date('02Mar2013 1600','DDMonYYYY HH24MI'),9658, 3); INSERT INTO Guide VALUES (To_Date('02Mar2013 1700','DDMonYYYY HH24MI'),9658, 3); INSERT INTO Guide VALUES (To_Date('02Mar2013 1800','DDMonYYYY HH24MI'),9658, 3); INSERT INTO Guide VALUES (To_Date('02Mar2013 1900','DDMonYYYY HH24MI'),7458, 3); INSERT INTO Guide VALUES (To_Date('02Mar2013 2000','DDMonYYYY HH24MI'),7458, 3); INSERT INTO Guide VALUES (To_Date('02Mar2013 2100','DDMonYYYY HH24MI'),7458, 3); INSERT INTO Guide VALUES (To_Date('02Mar2013 2200','DDMonYYYY HH24MI'),7458, 3); INSERT INTO Guide VALUES (To_Date('02Mar2013 2300','DDMonYYYY HH24MI'),7458, 3); INSERT INTO Guide VALUES (To_Date('03Mar2013 0000','DDMonYYYY HH24MI'),2210, 3); INSERT INTO Guide VALUES (To_Date('03Mar2013 0600','DDMonYYYY HH24MI'),9999, 3); INSERT INTO Guide VALUES (To_Date('03Mar2013 0700','DDMonYYYY HH24MI'),9999, 3); INSERT INTO Guide VALUES (To_Date('03Mar2013 0800','DDMonYYYY HH24MI'),9999, 3); INSERT INTO Guide VALUES (To_Date('03Mar2013 0900','DDMonYYYY HH24MI'),9999, 3); INSERT INTO Guide VALUES (To_Date('03Mar2013 1000','DDMonYYYY HH24MI'),9999, 3); INSERT INTO Guide VALUES (To_Date('03Mar2013 1100','DDMonYYYY HH24MI'),9999, 3); INSERT INTO Guide VALUES (To_Date('03Mar2013 1200','DDMonYYYY HH24MI'),9999, 3); INSERT INTO Guide VALUES (To_Date('03Mar2013 1300','DDMonYYYY HH24MI'),9658, 3); INSERT INTO Guide VALUES (To_Date('03Mar2013 1400','DDMonYYYY HH24MI'),9658, 3); INSERT INTO Guide VALUES (To_Date('03Mar2013 1500','DDMonYYYY HH24MI'),9658, 3); INSERT INTO Guide VALUES (To_Date('03Mar2013 1600','DDMonYYYY HH24MI'),9658, 3); INSERT INTO Guide VALUES (To_Date('03Mar2013 1700','DDMonYYYY HH24MI'),9658, 3); INSERT INTO Guide VALUES (To_Date('03Mar2013 1800','DDMonYYYY HH24MI'),9658, 3); INSERT INTO Guide VALUES (To_Date('03Mar2013 1900','DDMonYYYY HH24MI'),7458, 3); INSERT INTO Guide VALUES (To_Date('03Mar2013 2000','DDMonYYYY HH24MI'),7458, 3); INSERT INTO Guide VALUES (To_Date('03Mar2013 2100','DDMonYYYY HH24MI'),7458, 3); INSERT INTO Guide VALUES (To_Date('03Mar2013 2200','DDMonYYYY HH24MI'),7458, 3); INSERT INTO Guide VALUES (To_Date('03Mar2013 2300','DDMonYYYY HH24MI'),7458, 3); INSERT INTO Guide VALUES (To_Date('01Mar2013 0000','DDMonYYYY HH24MI'),9658, 4); INSERT INTO Guide VALUES (To_Date('01Mar2013 0100','DDMonYYYY HH24MI'),9658, 4); INSERT INTO Guide VALUES (To_Date('01Mar2013 0200','DDMonYYYY HH24MI'),9658, 4); INSERT INTO Guide VALUES (To_Date('01Mar2013 0300','DDMonYYYY HH24MI'),9658, 4); INSERT INTO Guide VALUES (To_Date('01Mar2013 0400','DDMonYYYY HH24MI'),9658, 4); INSERT INTO Guide VALUES (To_Date('01Mar2013 0500','DDMonYYYY HH24MI'),9658, 4); INSERT INTO Guide VALUES (To_Date('01Mar2013 0600','DDMonYYYY HH24MI'),8888, 4); INSERT INTO Guide VALUES (To_Date('01Mar2013 0800','DDMonYYYY HH24MI'),8888, 4); INSERT INTO Guide VALUES (To_Date('01Mar2013 1000','DDMonYYYY HH24MI'),1688, 4); INSERT INTO Guide VALUES (To_Date('01Mar2013 1100','DDMonYYYY HH24MI'),9999, 4); INSERT INTO Guide VALUES (To_Date('01Mar2013 1200','DDMonYYYY HH24MI'),1688, 4); INSERT INTO Guide VALUES (To_Date('01Mar2013 1300','DDMonYYYY HH24MI'),9999, 4); INSERT INTO Guide VALUES (To_Date('01Mar2013 1400','DDMonYYYY HH24MI'),1688, 4); INSERT INTO Guide VALUES (To_Date('01Mar2013 1500','DDMonYYYY HH24MI'),9999, 4); INSERT INTO Guide VALUES (To_Date('01Mar2013 1600','DDMonYYYY HH24MI'),1688, 4); INSERT INTO Guide VALUES (To_Date('01Mar2013 1700','DDMonYYYY HH24MI'),8888, 4); INSERT INTO Guide VALUES (To_Date('01Mar2013 1800','DDMonYYYY HH24MI'),2210, 4); INSERT INTO Guide VALUES (To_Date('02Mar2013 0000','DDMonYYYY HH24MI'),9658, 4); INSERT INTO Guide VALUES (To_Date('02Mar2013 0100','DDMonYYYY HH24MI'),9658, 4); INSERT INTO Guide VALUES (To_Date('02Mar2013 0200','DDMonYYYY HH24MI'),9658, 4); INSERT INTO Guide VALUES (To_Date('02Mar2013 0300','DDMonYYYY HH24MI'),9658, 4); INSERT INTO Guide VALUES (To_Date('02Mar2013 0400','DDMonYYYY HH24MI'),9658, 4); INSERT INTO Guide VALUES (To_Date('02Mar2013 0500','DDMonYYYY HH24MI'),9658, 4); INSERT INTO Guide VALUES (To_Date('02Mar2013 0600','DDMonYYYY HH24MI'),8888, 4); INSERT INTO Guide VALUES (To_Date('02Mar2013 0800','DDMonYYYY HH24MI'),8888, 4); INSERT INTO Guide VALUES (To_Date('02Mar2013 1000','DDMonYYYY HH24MI'),1688, 4); INSERT INTO Guide VALUES (To_Date('02Mar2013 1100','DDMonYYYY HH24MI'),9999, 4); INSERT INTO Guide VALUES (To_Date('02Mar2013 1200','DDMonYYYY HH24MI'),1688, 4); INSERT INTO Guide VALUES (To_Date('02Mar2013 1300','DDMonYYYY HH24MI'),9999, 4); INSERT INTO Guide VALUES (To_Date('02Mar2013 1400','DDMonYYYY HH24MI'),1688, 4); INSERT INTO Guide VALUES (To_Date('02Mar2013 1500','DDMonYYYY HH24MI'),9999, 4); INSERT INTO Guide VALUES (To_Date('02Mar2013 1600','DDMonYYYY HH24MI'),1688, 4); INSERT INTO Guide VALUES (To_Date('02Mar2013 1700','DDMonYYYY HH24MI'),8888, 4); INSERT INTO Guide VALUES (To_Date('02Mar2013 1800','DDMonYYYY HH24MI'),2210, 4); INSERT INTO Guide VALUES (To_Date('03Mar2013 0000','DDMonYYYY HH24MI'),9658, 4); INSERT INTO Guide VALUES (To_Date('03Mar2013 0100','DDMonYYYY HH24MI'),9658, 4); INSERT INTO Guide VALUES (To_Date('03Mar2013 0200','DDMonYYYY HH24MI'),9658, 4); INSERT INTO Guide VALUES (To_Date('03Mar2013 0300','DDMonYYYY HH24MI'),9658, 4); INSERT INTO Guide VALUES (To_Date('03Mar2013 0400','DDMonYYYY HH24MI'),9658, 4); INSERT INTO Guide VALUES (To_Date('03Mar2013 0500','DDMonYYYY HH24MI'),9658, 4); INSERT INTO Guide VALUES (To_Date('03Mar2013 0600','DDMonYYYY HH24MI'),8888, 4); INSERT INTO Guide VALUES (To_Date('03Mar2013 0800','DDMonYYYY HH24MI'),8888, 4); INSERT INTO Guide VALUES (To_Date('03Mar2013 1000','DDMonYYYY HH24MI'),1688, 4); INSERT INTO Guide VALUES (To_Date('03Mar2013 1100','DDMonYYYY HH24MI'),9999, 4); INSERT INTO Guide VALUES (To_Date('03Mar2013 1200','DDMonYYYY HH24MI'),1688, 4); INSERT INTO Guide VALUES (To_Date('03Mar2013 1300','DDMonYYYY HH24MI'),9999, 4); INSERT INTO Guide VALUES (To_Date('03Mar2013 1400','DDMonYYYY HH24MI'),1688, 4); INSERT INTO Guide VALUES (To_Date('03Mar2013 1500','DDMonYYYY HH24MI'),9999, 4); INSERT INTO Guide VALUES (To_Date('03Mar2013 1600','DDMonYYYY HH24MI'),1688, 4); INSERT INTO Guide VALUES (To_Date('03Mar2013 1700','DDMonYYYY HH24MI'),8888, 4); INSERT INTO Guide VALUES (To_Date('03Mar2013 1800','DDMonYYYY HH24MI'),2210, 4); INSERT INTO Guide VALUES (To_Date('01Mar2013 0000','DDMonYYYY HH24MI'),5544, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 0100','DDMonYYYY HH24MI'),4455, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 0130','DDMonYYYY HH24MI'),4455, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 0200','DDMonYYYY HH24MI'),5544, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 0300','DDMonYYYY HH24MI'),4455, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 0330','DDMonYYYY HH24MI'),4455, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 0400','DDMonYYYY HH24MI'),5544, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 0500','DDMonYYYY HH24MI'),4455, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 0530','DDMonYYYY HH24MI'),4455, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 0600','DDMonYYYY HH24MI'),2564, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 0800','DDMonYYYY HH24MI'),16, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 0830','DDMonYYYY HH24MI'),998, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 0900','DDMonYYYY HH24MI'),5566, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 1000','DDMonYYYY HH24MI'),6655, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 1100','DDMonYYYY HH24MI'),5566, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 1200','DDMonYYYY HH24MI'),6655, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 1300','DDMonYYYY HH24MI'),5566, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 1400','DDMonYYYY HH24MI'),6655, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 1500','DDMonYYYY HH24MI'),998, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 1530','DDMonYYYY HH24MI'),998, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 1600','DDMonYYYY HH24MI'),998, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 1630','DDMonYYYY HH24MI'),998, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 1700','DDMonYYYY HH24MI'),998, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 1730','DDMonYYYY HH24MI'),998, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 1800','DDMonYYYY HH24MI'),998, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 1830','DDMonYYYY HH24MI'),998, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 1900','DDMonYYYY HH24MI'),2564, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 2100','DDMonYYYY HH24MI'),2636, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 2130','DDMonYYYY HH24MI'),2636, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 2200','DDMonYYYY HH24MI'),2636, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 2230','DDMonYYYY HH24MI'),2636, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 2300','DDMonYYYY HH24MI'),2636, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 2330','DDMonYYYY HH24MI'),2636, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 0000','DDMonYYYY HH24MI'),5544, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 0100','DDMonYYYY HH24MI'),4455, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 0130','DDMonYYYY HH24MI'),4455, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 0200','DDMonYYYY HH24MI'),5544, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 0300','DDMonYYYY HH24MI'),4455, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 0330','DDMonYYYY HH24MI'),4455, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 0400','DDMonYYYY HH24MI'),5544, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 0500','DDMonYYYY HH24MI'),4455, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 0530','DDMonYYYY HH24MI'),4455, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 0600','DDMonYYYY HH24MI'),2564, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 0800','DDMonYYYY HH24MI'),16, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 0830','DDMonYYYY HH24MI'),998, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 0900','DDMonYYYY HH24MI'),5566, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 1000','DDMonYYYY HH24MI'),6655, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 1100','DDMonYYYY HH24MI'),5566, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 1200','DDMonYYYY HH24MI'),6655, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 1300','DDMonYYYY HH24MI'),5566, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 1400','DDMonYYYY HH24MI'),6655, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 1500','DDMonYYYY HH24MI'),998, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 1530','DDMonYYYY HH24MI'),998, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 1600','DDMonYYYY HH24MI'),998, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 1630','DDMonYYYY HH24MI'),998, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 1700','DDMonYYYY HH24MI'),998, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 1730','DDMonYYYY HH24MI'),998, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 1800','DDMonYYYY HH24MI'),998, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 1830','DDMonYYYY HH24MI'),998, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 1900','DDMonYYYY HH24MI'),2564, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 2100','DDMonYYYY HH24MI'),2636, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 2130','DDMonYYYY HH24MI'),2636, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 2200','DDMonYYYY HH24MI'),2636, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 2230','DDMonYYYY HH24MI'),2636, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 2300','DDMonYYYY HH24MI'),2636, 5); INSERT INTO Guide VALUES (To_Date('02Mar2013 2330','DDMonYYYY HH24MI'),2636, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 0000','DDMonYYYY HH24MI'),5544, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 0100','DDMonYYYY HH24MI'),4455, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 0130','DDMonYYYY HH24MI'),4455, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 0200','DDMonYYYY HH24MI'),5544, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 0300','DDMonYYYY HH24MI'),4455, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 0330','DDMonYYYY HH24MI'),4455, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 0400','DDMonYYYY HH24MI'),5544, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 0500','DDMonYYYY HH24MI'),4455, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 0530','DDMonYYYY HH24MI'),4455, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 0600','DDMonYYYY HH24MI'),2564, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 0800','DDMonYYYY HH24MI'),16, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 0830','DDMonYYYY HH24MI'),998, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 0900','DDMonYYYY HH24MI'),5566, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 1000','DDMonYYYY HH24MI'),6655, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 1100','DDMonYYYY HH24MI'),5566, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 1200','DDMonYYYY HH24MI'),6655, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 1300','DDMonYYYY HH24MI'),5566, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 1400','DDMonYYYY HH24MI'),6655, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 1500','DDMonYYYY HH24MI'),998, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 1530','DDMonYYYY HH24MI'),998, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 1600','DDMonYYYY HH24MI'),998, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 1630','DDMonYYYY HH24MI'),998, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 1700','DDMonYYYY HH24MI'),998, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 1730','DDMonYYYY HH24MI'),998, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 1800','DDMonYYYY HH24MI'),998, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 1830','DDMonYYYY HH24MI'),998, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 1900','DDMonYYYY HH24MI'),2564, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 2100','DDMonYYYY HH24MI'),2636, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 2130','DDMonYYYY HH24MI'),2636, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 2200','DDMonYYYY HH24MI'),2636, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 2230','DDMonYYYY HH24MI'),2636, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 2300','DDMonYYYY HH24MI'),2636, 5); INSERT INTO Guide VALUES (To_Date('03Mar2013 2330','DDMonYYYY HH24MI'),2636, 5); INSERT INTO Guide VALUES (To_Date('01Mar2013 0000','DDMonYYYY HH24MI'),4455, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 0030','DDMonYYYY HH24MI'),4455, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 0100','DDMonYYYY HH24MI'),5544, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 0200','DDMonYYYY HH24MI'),4455, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 0230','DDMonYYYY HH24MI'),4455, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 0300','DDMonYYYY HH24MI'),5544, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 0400','DDMonYYYY HH24MI'),4455, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 0430','DDMonYYYY HH24MI'),4455, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 0500','DDMonYYYY HH24MI'),5544, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 0600','DDMonYYYY HH24MI'),2, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 0700','DDMonYYYY HH24MI'),2, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 0800','DDMonYYYY HH24MI'),2, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 0900','DDMonYYYY HH24MI'),2, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 1000','DDMonYYYY HH24MI'),3344, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 0100','DDMonYYYY HH24MI'),3344, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 1200','DDMonYYYY HH24MI'),3344, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 1300','DDMonYYYY HH24MI'),5544, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 1400','DDMonYYYY HH24MI'),5566, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 1500','DDMonYYYY HH24MI'),5566, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 1600','DDMonYYYY HH24MI'),5566, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 1700','DDMonYYYY HH24MI'),5577, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 1800','DDMonYYYY HH24MI'),5577, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 1900','DDMonYYYY HH24MI'),5577, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 2000','DDMonYYYY HH24MI'),2564, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 2200','DDMonYYYY HH24MI'),998, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 2230','DDMonYYYY HH24MI'),998, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 2300','DDMonYYYY HH24MI'),998, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 2330','DDMonYYYY HH24MI'),998, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 0000','DDMonYYYY HH24MI'),4455, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 0030','DDMonYYYY HH24MI'),4455, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 0100','DDMonYYYY HH24MI'),5544, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 0200','DDMonYYYY HH24MI'),4455, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 0230','DDMonYYYY HH24MI'),4455, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 0300','DDMonYYYY HH24MI'),5544, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 0400','DDMonYYYY HH24MI'),4455, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 0430','DDMonYYYY HH24MI'),4455, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 0500','DDMonYYYY HH24MI'),5544, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 0600','DDMonYYYY HH24MI'),2, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 0700','DDMonYYYY HH24MI'),2, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 0800','DDMonYYYY HH24MI'),2, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 0900','DDMonYYYY HH24MI'),2, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 1000','DDMonYYYY HH24MI'),3344, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 0100','DDMonYYYY HH24MI'),3344, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 1200','DDMonYYYY HH24MI'),3344, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 1300','DDMonYYYY HH24MI'),5544, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 1400','DDMonYYYY HH24MI'),5566, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 1500','DDMonYYYY HH24MI'),5566, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 1600','DDMonYYYY HH24MI'),5566, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 1700','DDMonYYYY HH24MI'),5577, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 1800','DDMonYYYY HH24MI'),5577, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 1900','DDMonYYYY HH24MI'),5577, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 2000','DDMonYYYY HH24MI'),2564, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 2200','DDMonYYYY HH24MI'),998, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 2230','DDMonYYYY HH24MI'),998, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 2300','DDMonYYYY HH24MI'),998, 6); INSERT INTO Guide VALUES (To_Date('02Mar2013 2330','DDMonYYYY HH24MI'),998, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 0000','DDMonYYYY HH24MI'),4455, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 0030','DDMonYYYY HH24MI'),4455, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 0100','DDMonYYYY HH24MI'),5544, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 0200','DDMonYYYY HH24MI'),4455, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 0230','DDMonYYYY HH24MI'),4455, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 0300','DDMonYYYY HH24MI'),5544, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 0400','DDMonYYYY HH24MI'),4455, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 0430','DDMonYYYY HH24MI'),4455, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 0500','DDMonYYYY HH24MI'),5544, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 0600','DDMonYYYY HH24MI'),2, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 0700','DDMonYYYY HH24MI'),2, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 0800','DDMonYYYY HH24MI'),2, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 0900','DDMonYYYY HH24MI'),2, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 1000','DDMonYYYY HH24MI'),3344, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 0100','DDMonYYYY HH24MI'),3344, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 1200','DDMonYYYY HH24MI'),3344, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 1300','DDMonYYYY HH24MI'),5544, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 1400','DDMonYYYY HH24MI'),5566, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 1500','DDMonYYYY HH24MI'),5566, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 1600','DDMonYYYY HH24MI'),5566, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 1700','DDMonYYYY HH24MI'),5577, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 1800','DDMonYYYY HH24MI'),5577, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 1900','DDMonYYYY HH24MI'),5577, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 2000','DDMonYYYY HH24MI'),2564, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 2200','DDMonYYYY HH24MI'),998, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 2230','DDMonYYYY HH24MI'),998, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 2300','DDMonYYYY HH24MI'),998, 6); INSERT INTO Guide VALUES (To_Date('03Mar2013 2330','DDMonYYYY HH24MI'),998, 6); INSERT INTO Guide VALUES (To_Date('01Mar2013 0000','DDMonYYYY HH24MI'),231, 7); INSERT INTO Guide VALUES (To_Date('01Mar2013 0400','DDMonYYYY HH24MI'),777, 7); INSERT INTO Guide VALUES (To_Date('01Mar2013 0430','DDMonYYYY HH24MI'),777, 7); INSERT INTO Guide VALUES (To_Date('01Mar2013 0500','DDMonYYYY HH24MI'),777, 7); INSERT INTO Guide VALUES (To_Date('01Mar2013 0530','DDMonYYYY HH24MI'),777, 7); INSERT INTO Guide VALUES (To_Date('01Mar2013 0600','DDMonYYYY HH24MI'),711, 7); INSERT INTO Guide VALUES (To_Date('01Mar2013 0700','DDMonYYYY HH24MI'),811, 7); INSERT INTO Guide VALUES (To_Date('01Mar2013 0800','DDMonYYYY HH24MI'),922, 7); INSERT INTO Guide VALUES (To_Date('01Mar2013 0900','DDMonYYYY HH24MI'),922, 7); INSERT INTO Guide VALUES (To_Date('01Mar2013 1000','DDMonYYYY HH24MI'),811, 7); INSERT INTO Guide VALUES (To_Date('01Mar2013 1100','DDMonYYYY HH24MI'),711, 7); INSERT INTO Guide VALUES (To_Date('01Mar2013 1200','DDMonYYYY HH24MI'),555, 7); INSERT INTO Guide VALUES (To_Date('01Mar2013 1300','DDMonYYYY HH24MI'),411, 7); INSERT INTO Guide VALUES (To_Date('01Mar2013 1400','DDMonYYYY HH24MI'),311, 7); INSERT INTO Guide VALUES (To_Date('01Mar2013 1500','DDMonYYYY HH24MI'),411, 7); INSERT INTO Guide VALUES (To_Date('01Mar2013 1600','DDMonYYYY HH24MI'),311, 7); INSERT INTO Guide VALUES (To_Date('01Mar2013 1700','DDMonYYYY HH24MI'),111, 7); INSERT INTO Guide VALUES (To_Date('01Mar2013 1800','DDMonYYYY HH24MI'),111, 7); INSERT INTO Guide VALUES (To_Date('01Mar2013 1900','DDMonYYYY HH24MI'),555, 7); INSERT INTO Guide VALUES (To_Date('01Mar2013 2000','DDMonYYYY HH24MI'),555, 7); INSERT INTO Guide VALUES (To_Date('01Mar2013 2100','DDMonYYYY HH24MI'),111, 7); INSERT INTO Guide VALUES (To_Date('01Mar2013 2200','DDMonYYYY HH24MI'),711, 7); INSERT INTO Guide VALUES (To_Date('01Mar2013 2300','DDMonYYYY HH24MI'),711, 7); INSERT INTO Guide VALUES (To_Date('02Mar2013 0000','DDMonYYYY HH24MI'),231, 7); INSERT INTO Guide VALUES (To_Date('02Mar2013 0400','DDMonYYYY HH24MI'),777, 7); INSERT INTO Guide VALUES (To_Date('02Mar2013 0430','DDMonYYYY HH24MI'),777, 7); INSERT INTO Guide VALUES (To_Date('02Mar2013 0500','DDMonYYYY HH24MI'),777, 7); INSERT INTO Guide VALUES (To_Date('02Mar2013 0530','DDMonYYYY HH24MI'),777, 7); INSERT INTO Guide VALUES (To_Date('02Mar2013 0600','DDMonYYYY HH24MI'),711, 7); INSERT INTO Guide VALUES (To_Date('02Mar2013 0700','DDMonYYYY HH24MI'),811, 7); INSERT INTO Guide VALUES (To_Date('02Mar2013 0800','DDMonYYYY HH24MI'),922, 7); INSERT INTO Guide VALUES (To_Date('02Mar2013 0900','DDMonYYYY HH24MI'),922, 7); INSERT INTO Guide VALUES (To_Date('02Mar2013 1000','DDMonYYYY HH24MI'),811, 7); INSERT INTO Guide VALUES (To_Date('02Mar2013 1100','DDMonYYYY HH24MI'),711, 7); INSERT INTO Guide VALUES (To_Date('02Mar2013 1200','DDMonYYYY HH24MI'),555, 7); INSERT INTO Guide VALUES (To_Date('02Mar2013 1300','DDMonYYYY HH24MI'),411, 7); INSERT INTO Guide VALUES (To_Date('02Mar2013 1400','DDMonYYYY HH24MI'),311, 7); INSERT INTO Guide VALUES (To_Date('02Mar2013 1500','DDMonYYYY HH24MI'),411, 7); INSERT INTO Guide VALUES (To_Date('02Mar2013 1600','DDMonYYYY HH24MI'),311, 7); INSERT INTO Guide VALUES (To_Date('02Mar2013 1700','DDMonYYYY HH24MI'),111, 7); INSERT INTO Guide VALUES (To_Date('02Mar2013 1800','DDMonYYYY HH24MI'),111, 7); INSERT INTO Guide VALUES (To_Date('02Mar2013 1900','DDMonYYYY HH24MI'),555, 7); INSERT INTO Guide VALUES (To_Date('02Mar2013 2000','DDMonYYYY HH24MI'),555, 7); INSERT INTO Guide VALUES (To_Date('02Mar2013 2100','DDMonYYYY HH24MI'),111, 7); INSERT INTO Guide VALUES (To_Date('02Mar2013 2200','DDMonYYYY HH24MI'),711, 7); INSERT INTO Guide VALUES (To_Date('02Mar2013 2300','DDMonYYYY HH24MI'),711, 7); INSERT INTO Guide VALUES (To_Date('03Mar2013 0000','DDMonYYYY HH24MI'),231, 7); INSERT INTO Guide VALUES (To_Date('03Mar2013 0400','DDMonYYYY HH24MI'),777, 7); INSERT INTO Guide VALUES (To_Date('03Mar2013 0430','DDMonYYYY HH24MI'),777, 7); INSERT INTO Guide VALUES (To_Date('03Mar2013 0500','DDMonYYYY HH24MI'),777, 7); INSERT INTO Guide VALUES (To_Date('03Mar2013 0530','DDMonYYYY HH24MI'),777, 7); INSERT INTO Guide VALUES (To_Date('03Mar2013 0600','DDMonYYYY HH24MI'),711, 7); INSERT INTO Guide VALUES (To_Date('03Mar2013 0700','DDMonYYYY HH24MI'),811, 7); INSERT INTO Guide VALUES (To_Date('03Mar2013 0800','DDMonYYYY HH24MI'),922, 7); INSERT INTO Guide VALUES (To_Date('03Mar2013 0900','DDMonYYYY HH24MI'),922, 7); INSERT INTO Guide VALUES (To_Date('03Mar2013 1000','DDMonYYYY HH24MI'),811, 7); INSERT INTO Guide VALUES (To_Date('03Mar2013 1100','DDMonYYYY HH24MI'),711, 7); INSERT INTO Guide VALUES (To_Date('03Mar2013 1200','DDMonYYYY HH24MI'),555, 7); INSERT INTO Guide VALUES (To_Date('03Mar2013 1300','DDMonYYYY HH24MI'),411, 7); INSERT INTO Guide VALUES (To_Date('03Mar2013 1400','DDMonYYYY HH24MI'),311, 7); INSERT INTO Guide VALUES (To_Date('03Mar2013 1500','DDMonYYYY HH24MI'),411, 7); INSERT INTO Guide VALUES (To_Date('03Mar2013 1600','DDMonYYYY HH24MI'),311, 7); INSERT INTO Guide VALUES (To_Date('03Mar2013 1700','DDMonYYYY HH24MI'),111, 7); INSERT INTO Guide VALUES (To_Date('03Mar2013 1800','DDMonYYYY HH24MI'),111, 7); INSERT INTO Guide VALUES (To_Date('03Mar2013 1900','DDMonYYYY HH24MI'),555, 7); INSERT INTO Guide VALUES (To_Date('03Mar2013 2000','DDMonYYYY HH24MI'),555, 7); INSERT INTO Guide VALUES (To_Date('03Mar2013 2100','DDMonYYYY HH24MI'),111, 7); INSERT INTO Guide VALUES (To_Date('03Mar2013 2200','DDMonYYYY HH24MI'),711, 7); INSERT INTO Guide VALUES (To_Date('03Mar2013 2300','DDMonYYYY HH24MI'),711, 7); INSERT INTO Guide VALUES (To_Date('01Mar2013 0000','DDMonYYYY HH24MI'),311, 8); INSERT INTO Guide VALUES (To_Date('01Mar2013 0100','DDMonYYYY HH24MI'),311, 8); INSERT INTO Guide VALUES (To_Date('01Mar2013 0200','DDMonYYYY HH24MI'),311, 8); INSERT INTO Guide VALUES (To_Date('01Mar2013 0300','DDMonYYYY HH24MI'),311, 8); INSERT INTO Guide VALUES (To_Date('01Mar2013 0400','DDMonYYYY HH24MI'),311, 8); INSERT INTO Guide VALUES (To_Date('01Mar2013 0500','DDMonYYYY HH24MI'),922, 8); INSERT INTO Guide VALUES (To_Date('01Mar2013 0600','DDMonYYYY HH24MI'),922, 8); INSERT INTO Guide VALUES (To_Date('01Mar2013 0700','DDMonYYYY HH24MI'),922, 8); INSERT INTO Guide VALUES (To_Date('01Mar2013 0800','DDMonYYYY HH24MI'),111, 8); INSERT INTO Guide VALUES (To_Date('01Mar2013 0900','DDMonYYYY HH24MI'),111, 8); INSERT INTO Guide VALUES (To_Date('01Mar2013 1000','DDMonYYYY HH24MI'),111, 8); INSERT INTO Guide VALUES (To_Date('01Mar2013 1100','DDMonYYYY HH24MI'),555, 8); INSERT INTO Guide VALUES (To_Date('01Mar2013 1200','DDMonYYYY HH24MI'),555, 8); INSERT INTO Guide VALUES (To_Date('01Mar2013 1230','DDMonYYYY HH24MI'),777, 8); INSERT INTO Guide VALUES (To_Date('01Mar2013 1300','DDMonYYYY HH24MI'),777, 8); INSERT INTO Guide VALUES (To_Date('01Mar2013 1330','DDMonYYYY HH24MI'),777, 8); INSERT INTO Guide VALUES (To_Date('01Mar2013 1430','DDMonYYYY HH24MI'),811, 8); INSERT INTO Guide VALUES (To_Date('01Mar2013 1530','DDMonYYYY HH24MI'),811, 8); INSERT INTO Guide VALUES (To_Date('01Mar2013 1630','DDMonYYYY HH24MI'),411, 8); INSERT INTO Guide VALUES (To_Date('01Mar2013 1730','DDMonYYYY HH24MI'),777, 8); INSERT INTO Guide VALUES (To_Date('01Mar2013 1800','DDMonYYYY HH24MI'),777, 8); INSERT INTO Guide VALUES (To_Date('01Mar2013 1830','DDMonYYYY HH24MI'),777, 8); INSERT INTO Guide VALUES (To_Date('01Mar2013 1900','DDMonYYYY HH24MI'),231, 8); INSERT INTO Guide VALUES (To_Date('02Mar2013 0000','DDMonYYYY HH24MI'),311, 8); INSERT INTO Guide VALUES (To_Date('02Mar2013 0100','DDMonYYYY HH24MI'),311, 8); INSERT INTO Guide VALUES (To_Date('02Mar2013 0200','DDMonYYYY HH24MI'),311, 8); INSERT INTO Guide VALUES (To_Date('02Mar2013 0300','DDMonYYYY HH24MI'),311, 8); INSERT INTO Guide VALUES (To_Date('02Mar2013 0400','DDMonYYYY HH24MI'),311, 8); INSERT INTO Guide VALUES (To_Date('02Mar2013 0500','DDMonYYYY HH24MI'),922, 8); INSERT INTO Guide VALUES (To_Date('02Mar2013 0600','DDMonYYYY HH24MI'),922, 8); INSERT INTO Guide VALUES (To_Date('02Mar2013 0700','DDMonYYYY HH24MI'),922, 8); INSERT INTO Guide VALUES (To_Date('02Mar2013 0800','DDMonYYYY HH24MI'),111, 8); INSERT INTO Guide VALUES (To_Date('02Mar2013 0900','DDMonYYYY HH24MI'),111, 8); INSERT INTO Guide VALUES (To_Date('02Mar2013 1000','DDMonYYYY HH24MI'),111, 8); INSERT INTO Guide VALUES (To_Date('02Mar2013 1100','DDMonYYYY HH24MI'),555, 8); INSERT INTO Guide VALUES (To_Date('02Mar2013 1200','DDMonYYYY HH24MI'),555, 8); INSERT INTO Guide VALUES (To_Date('21Mar2013 1230','DDMonYYYY HH24MI'),777, 8); INSERT INTO Guide VALUES (To_Date('02Mar2013 1300','DDMonYYYY HH24MI'),777, 8); INSERT INTO Guide VALUES (To_Date('02Mar2013 1330','DDMonYYYY HH24MI'),777, 8); INSERT INTO Guide VALUES (To_Date('02Mar2013 1430','DDMonYYYY HH24MI'),811, 8); INSERT INTO Guide VALUES (To_Date('02Mar2013 1530','DDMonYYYY HH24MI'),811, 8); INSERT INTO Guide VALUES (To_Date('02Mar2013 1630','DDMonYYYY HH24MI'),411, 8); INSERT INTO Guide VALUES (To_Date('02Mar2013 1730','DDMonYYYY HH24MI'),777, 8); INSERT INTO Guide VALUES (To_Date('02Mar2013 1800','DDMonYYYY HH24MI'),777, 8); INSERT INTO Guide VALUES (To_Date('02Mar2013 1830','DDMonYYYY HH24MI'),777, 8); INSERT INTO Guide VALUES (To_Date('02Mar2013 1900','DDMonYYYY HH24MI'),231, 8); INSERT INTO Guide VALUES (To_Date('03Mar2013 0000','DDMonYYYY HH24MI'),311, 8); INSERT INTO Guide VALUES (To_Date('03Mar2013 0100','DDMonYYYY HH24MI'),311, 8); INSERT INTO Guide VALUES (To_Date('03Mar2013 0200','DDMonYYYY HH24MI'),311, 8); INSERT INTO Guide VALUES (To_Date('03Mar2013 0300','DDMonYYYY HH24MI'),311, 8); INSERT INTO Guide VALUES (To_Date('03Mar2013 0400','DDMonYYYY HH24MI'),311, 8); INSERT INTO Guide VALUES (To_Date('03Mar2013 0500','DDMonYYYY HH24MI'),922, 8); INSERT INTO Guide VALUES (To_Date('03Mar2013 0600','DDMonYYYY HH24MI'),922, 8); INSERT INTO Guide VALUES (To_Date('03Mar2013 0700','DDMonYYYY HH24MI'),922, 8); INSERT INTO Guide VALUES (To_Date('03Mar2013 0800','DDMonYYYY HH24MI'),111, 8); INSERT INTO Guide VALUES (To_Date('03Mar2013 0900','DDMonYYYY HH24MI'),111, 8); INSERT INTO Guide VALUES (To_Date('03Mar2013 1000','DDMonYYYY HH24MI'),111, 8); INSERT INTO Guide VALUES (To_Date('03Mar2013 1100','DDMonYYYY HH24MI'),555, 8); INSERT INTO Guide VALUES (To_Date('03Mar2013 1200','DDMonYYYY HH24MI'),555, 8); INSERT INTO Guide VALUES (To_Date('03Mar2013 1230','DDMonYYYY HH24MI'),777, 8); INSERT INTO Guide VALUES (To_Date('03Mar2013 1300','DDMonYYYY HH24MI'),777, 8); INSERT INTO Guide VALUES (To_Date('03Mar2013 1330','DDMonYYYY HH24MI'),777, 8); INSERT INTO Guide VALUES (To_Date('03Mar2013 1430','DDMonYYYY HH24MI'),811, 8); INSERT INTO Guide VALUES (To_Date('03Mar2013 1530','DDMonYYYY HH24MI'),811, 8); INSERT INTO Guide VALUES (To_Date('03Mar2013 1630','DDMonYYYY HH24MI'),411, 8); INSERT INTO Guide VALUES (To_Date('03Mar2013 1730','DDMonYYYY HH24MI'),777, 8); INSERT INTO Guide VALUES (To_Date('03Mar2013 1800','DDMonYYYY HH24MI'),777, 8); INSERT INTO Guide VALUES (To_Date('03Mar2013 1830','DDMonYYYY HH24MI'),777, 8); INSERT INTO Guide VALUES (To_Date('03Mar2013 1900','DDMonYYYY HH24MI'),231, 8); INSERT INTO Guide VALUES (To_Date('01Mar2013 0000','DDMonYYYY HH24MI'),2344, 9); INSERT INTO Guide VALUES (To_Date('01Mar2013 0200','DDMonYYYY HH24MI'),1399, 9); INSERT INTO Guide VALUES (To_Date('01Mar2013 0400','DDMonYYYY HH24MI'),3334, 9); INSERT INTO Guide VALUES (To_Date('01Mar2013 0600','DDMonYYYY HH24MI'),7888, 9); INSERT INTO Guide VALUES (To_Date('01Mar2013 0700','DDMonYYYY HH24MI'),9898, 9); INSERT INTO Guide VALUES (To_Date('01Mar2013 0800','DDMonYYYY HH24MI'),3131, 9); INSERT INTO Guide VALUES (To_Date('01Mar2013 0900','DDMonYYYY HH24MI'),2121, 9); INSERT INTO Guide VALUES (To_Date('01Mar2013 0930','DDMonYYYY HH24MI'),2121, 9); INSERT INTO Guide VALUES (To_Date('01Mar2013 1000','DDMonYYYY HH24MI'),4889, 9); INSERT INTO Guide VALUES (To_Date('01Mar2013 1400','DDMonYYYY HH24MI'),3334, 9); INSERT INTO Guide VALUES (To_Date('01Mar2013 1600','DDMonYYYY HH24MI'),7897, 9); INSERT INTO Guide VALUES (To_Date('01Mar2013 1800','DDMonYYYY HH24MI'),7898, 9); INSERT INTO Guide VALUES (To_Date('01Mar2013 1900','DDMonYYYY HH24MI'),6565, 9); INSERT INTO Guide VALUES (To_Date('01Mar2013 1930','DDMonYYYY HH24MI'),2121, 9); INSERT INTO Guide VALUES (To_Date('01Mar2013 2000','DDMonYYYY HH24MI'),3131, 9); INSERT INTO Guide VALUES (To_Date('01Mar2013 2100','DDMonYYYY HH24MI'),1399, 9); INSERT INTO Guide VALUES (To_Date('01Mar2013 2300','DDMonYYYY HH24MI'),9898, 9); INSERT INTO Guide VALUES (To_Date('02Mar2013 0000','DDMonYYYY HH24MI'),2344, 9); INSERT INTO Guide VALUES (To_Date('02Mar2013 0200','DDMonYYYY HH24MI'),1399, 9); INSERT INTO Guide VALUES (To_Date('02Mar2013 0400','DDMonYYYY HH24MI'),3334, 9); INSERT INTO Guide VALUES (To_Date('02Mar2013 0600','DDMonYYYY HH24MI'),7888, 9); INSERT INTO Guide VALUES (To_Date('02Mar2013 0700','DDMonYYYY HH24MI'),9898, 9); INSERT INTO Guide VALUES (To_Date('02Mar2013 0800','DDMonYYYY HH24MI'),3131, 9); INSERT INTO Guide VALUES (To_Date('02Mar2013 0900','DDMonYYYY HH24MI'),2121, 9); INSERT INTO Guide VALUES (To_Date('02Mar2013 0930','DDMonYYYY HH24MI'),2121, 9); INSERT INTO Guide VALUES (To_Date('02Mar2013 1000','DDMonYYYY HH24MI'),4889, 9); INSERT INTO Guide VALUES (To_Date('02Mar2013 1400','DDMonYYYY HH24MI'),3334, 9); INSERT INTO Guide VALUES (To_Date('02Mar2013 1600','DDMonYYYY HH24MI'),7897, 9); INSERT INTO Guide VALUES (To_Date('02Mar2013 1800','DDMonYYYY HH24MI'),7898, 9); INSERT INTO Guide VALUES (To_Date('02Mar2013 1900','DDMonYYYY HH24MI'),6565, 9); INSERT INTO Guide VALUES (To_Date('02Mar2013 1930','DDMonYYYY HH24MI'),2121, 9); INSERT INTO Guide VALUES (To_Date('02Mar2013 2000','DDMonYYYY HH24MI'),3131, 9); INSERT INTO Guide VALUES (To_Date('02Mar2013 2100','DDMonYYYY HH24MI'),1399, 9); INSERT INTO Guide VALUES (To_Date('02Mar2013 2300','DDMonYYYY HH24MI'),9898, 9); INSERT INTO Guide VALUES (To_Date('03Mar2013 0000','DDMonYYYY HH24MI'),2344, 9); INSERT INTO Guide VALUES (To_Date('03Mar2013 0200','DDMonYYYY HH24MI'),1399, 9); INSERT INTO Guide VALUES (To_Date('03Mar2013 0400','DDMonYYYY HH24MI'),3334, 9); INSERT INTO Guide VALUES (To_Date('03Mar2013 0600','DDMonYYYY HH24MI'),7888, 9); INSERT INTO Guide VALUES (To_Date('03Mar2013 0700','DDMonYYYY HH24MI'),9898, 9); INSERT INTO Guide VALUES (To_Date('03Mar2013 0800','DDMonYYYY HH24MI'),3131, 9); INSERT INTO Guide VALUES (To_Date('03Mar2013 0900','DDMonYYYY HH24MI'),2121, 9); INSERT INTO Guide VALUES (To_Date('03Mar2013 0930','DDMonYYYY HH24MI'),2121, 9); INSERT INTO Guide VALUES (To_Date('03Mar2013 1000','DDMonYYYY HH24MI'),4889, 9); INSERT INTO Guide VALUES (To_Date('03Mar2013 1400','DDMonYYYY HH24MI'),3334, 9); INSERT INTO Guide VALUES (To_Date('03Mar2013 1600','DDMonYYYY HH24MI'),7897, 9); INSERT INTO Guide VALUES (To_Date('03Mar2013 1800','DDMonYYYY HH24MI'),7898, 9); INSERT INTO Guide VALUES (To_Date('03Mar2013 1900','DDMonYYYY HH24MI'),6565, 9); INSERT INTO Guide VALUES (To_Date('03Mar2013 1930','DDMonYYYY HH24MI'),2121, 9); INSERT INTO Guide VALUES (To_Date('03Mar2013 2000','DDMonYYYY HH24MI'),3131, 9); INSERT INTO Guide VALUES (To_Date('03Mar2013 2100','DDMonYYYY HH24MI'),1399, 9); INSERT INTO Guide VALUES (To_Date('03Mar2013 2300','DDMonYYYY HH24MI'),9898, 9); INSERT INTO Guide VALUES (To_Date('01Mar2013 0000','DDMonYYYY HH24MI'),4888,10); INSERT INTO Guide VALUES (To_Date('01Mar2013 0600','DDMonYYYY HH24MI'),1399,10); INSERT INTO Guide VALUES (To_Date('01Mar2013 0800','DDMonYYYY HH24MI'),7896,10); INSERT INTO Guide VALUES (To_Date('01Mar2013 1200','DDMonYYYY HH24MI'),7898,10); INSERT INTO Guide VALUES (To_Date('01Mar2013 1300','DDMonYYYY HH24MI'),3334,10); INSERT INTO Guide VALUES (To_Date('01Mar2013 1500','DDMonYYYY HH24MI'),3335,10); INSERT INTO Guide VALUES (To_Date('01Mar2013 1600','DDMonYYYY HH24MI'),6565,10); INSERT INTO Guide VALUES (To_Date('01Mar2013 1630','DDMonYYYY HH24MI'),2121,10); INSERT INTO Guide VALUES (To_Date('01Mar2013 1700','DDMonYYYY HH24MI'),7897,10); INSERT INTO Guide VALUES (To_Date('01Mar2013 1900','DDMonYYYY HH24MI'),4887,10); INSERT INTO Guide VALUES (To_Date('01Mar2013 2000','DDMonYYYY HH24MI'),2344,10); INSERT INTO Guide VALUES (To_Date('01Mar2013 2200','DDMonYYYY HH24MI'),7888,10); INSERT INTO Guide VALUES (To_Date('01Mar2013 2300','DDMonYYYY HH24MI'),3131,10); INSERT INTO Guide VALUES (To_Date('02Mar2013 0000','DDMonYYYY HH24MI'),4888,10); INSERT INTO Guide VALUES (To_Date('02Mar2013 0600','DDMonYYYY HH24MI'),1399,10); INSERT INTO Guide VALUES (To_Date('02Mar2013 0800','DDMonYYYY HH24MI'),7896,10); INSERT INTO Guide VALUES (To_Date('02Mar2013 1200','DDMonYYYY HH24MI'),7898,10); INSERT INTO Guide VALUES (To_Date('02Mar2013 1300','DDMonYYYY HH24MI'),3334,10); INSERT INTO Guide VALUES (To_Date('02Mar2013 1500','DDMonYYYY HH24MI'),3335,10); INSERT INTO Guide VALUES (To_Date('02Mar2013 1600','DDMonYYYY HH24MI'),6565,10); INSERT INTO Guide VALUES (To_Date('02Mar2013 1630','DDMonYYYY HH24MI'),2121,10); INSERT INTO Guide VALUES (To_Date('02Mar2013 1700','DDMonYYYY HH24MI'),7897,10); INSERT INTO Guide VALUES (To_Date('02Mar2013 1900','DDMonYYYY HH24MI'),4887,10); INSERT INTO Guide VALUES (To_Date('02Mar2013 2000','DDMonYYYY HH24MI'),2344,10); INSERT INTO Guide VALUES (To_Date('02Mar2013 2200','DDMonYYYY HH24MI'),7888,10); INSERT INTO Guide VALUES (To_Date('02Mar2013 2300','DDMonYYYY HH24MI'),3131,10); INSERT INTO Guide VALUES (To_Date('03Mar2013 0000','DDMonYYYY HH24MI'),4888,10); INSERT INTO Guide VALUES (To_Date('03Mar2013 0600','DDMonYYYY HH24MI'),1399,10); INSERT INTO Guide VALUES (To_Date('03Mar2013 0800','DDMonYYYY HH24MI'),7896,10); INSERT INTO Guide VALUES (To_Date('03Mar2013 1200','DDMonYYYY HH24MI'),7898,10); INSERT INTO Guide VALUES (To_Date('03Mar2013 1300','DDMonYYYY HH24MI'),3334,10); INSERT INTO Guide VALUES (To_Date('03Mar2013 1500','DDMonYYYY HH24MI'),3335,10); INSERT INTO Guide VALUES (To_Date('03Mar2013 1600','DDMonYYYY HH24MI'),6565,10); INSERT INTO Guide VALUES (To_Date('03Mar2013 1630','DDMonYYYY HH24MI'),2121,10); INSERT INTO Guide VALUES (To_Date('03Mar2013 1700','DDMonYYYY HH24MI'),7897,10); INSERT INTO Guide VALUES (To_Date('03Mar2013 1900','DDMonYYYY HH24MI'),4887,10); INSERT INTO Guide VALUES (To_Date('03Mar2013 2000','DDMonYYYY HH24MI'),2344,10); INSERT INTO Guide VALUES (To_Date('03Mar2013 2200','DDMonYYYY HH24MI'),7888,10); INSERT INTO Guide VALUES (To_Date('03Mar2013 2300','DDMonYYYY HH24MI'),3131,10); /* Inserts into the Service_Order Table */ INSERT INTO Service_Order VALUES (10006, 11020, 2, '12-JAN-09', 24); INSERT INTO Service_Order VALUES (10007, 11033, 1, '22-JAN-10', 36); INSERT INTO Service_Order VALUES (10010, 11035, 3, '02-JAN-11', 18); INSERT INTO Service_Order VALUES (10005, 11098, 4, '02-MAR-08', 18); INSERT INTO Service_Order VALUES (10002, 11114, 3, '12-JAN-03', 24); INSERT INTO Service_Order VALUES (10013, 11121, 2, '09-MAY-11', 36); INSERT INTO Service_Order VALUES (10001, 11123, 2, '1-JAN-12', 18); INSERT INTO Service_Order VALUES (10016, 11183, 3, '02-FEB-12', 12); INSERT INTO Service_Order VALUES (10017, 11203, 4, '10-JAN-13', 24); INSERT INTO Service_Order VALUES (10015, 11223, 1, '02-JUL-11', 12); INSERT INTO Service_Order VALUES (10011, 11287, 2, '02-JAN-11', 36); INSERT INTO Service_Order VALUES (10003, 11444, 3, '02-APR-04', 12); INSERT INTO Service_Order VALUES (10012, 11456, 4, '04-MAR-11', 24); INSERT INTO Service_Order VALUES (10008, 11534, 1, '13-SEP-10', 36); INSERT INTO Service_Order VALUES (10004, 11635, 2, '30-OCT-06', 24); INSERT INTO Service_Order VALUES (10018, 11663, 1, '12-JAN-13', 36); INSERT INTO Service_Order VALUES (10009, 11789, 2, '02-JAN-11', 12); INSERT INTO Service_Order VALUES (10014, 11987, 4, '22-JUN-11', 12); /********************************************************/ -- Query ALL columns and ALL records for each table; /********************************************************/ SELECT * FROM Customer_Master; SELECT * FROM Package_Master; SELECT * FROM Channel_Type_Master; SELECT * FROM Supplier_Master; SELECT * FROM Rating_Master; SELECT * FROM Employee_Master; SELECT * FROM Reason_Code_Master; SELECT * FROM Package_Content; SELECT * FROM Service_Order; SELECT * FROM Channels; SELECT * FROM Programs; SELECT * FROM Guide; SELECT * FROM Billing; SELECT * FROM Customer_Survey; /********************************************************/ -- Modify Statements; /********************************************************/ SELECT A.CustNO, A.BillAMTDue, A.BillDate, BillPastDue, B.CustStatus, B.ReasonCD, B.EmpID From Billing A, Customer_Master B Where A.Billdate < (Sysdate - 30) and A.CustNo = B.CustNo and B.CustStatus IS NULL; -- Setting and overdue Bill Customer to INACTIVE -- Employee ID Prompt will add the supplied Employee ID to Records with Null EmployeeID -- Valid EMPID's: 10010 (Michelle, Linde), 10020 (Boss, Man), 10030 (Matthew, Ferry), 10040 (Billy, Clark) -- ENTER ONLY THE NUMBER UPDATE Customer_Master Set CustStatus = 'INACTIVE', ReasonCD = '107', EmpID = &EmpID Where CustNo in (SELECT A.CustNO From Billing A, Customer_Master B Where A.Billdate < (Sysdate - 30) and A.CustNo = B.CustNo and B.CustStatus IS NULL); -- Update the Billing table to show the overdue value SET VERIFY OFF Update Billing Set BillPastDue = BillAmtDue Where CustNo IN (SELECT A.CustNO From Billing A, Customer_Master B Where A.Billdate < (Sysdate - 30) and A.CustNo = B.CustNo and B.CustStatus = 'INACTIVE' and A.BILLPAYMTREC IS NULL and BillPastDue <= 0); -- Select shows that there are no Customers that have bills over due and that have not been updated SELECT A.CustNO, A.BillAMTDue, A.BillDate, BillPastDue, B.CustStatus, B.ReasonCD, B.EmpID From Billing A, Customer_Master B Where A.Billdate < (Sysdate - 30) and A.CustNo = B.CustNo and B.CustStatus IS NULL; -- Select confirms that Customers and Bills have been updated. SELECT A.CustNO, A.BillAMTDue, A.BillDate, BillPastDue, B.CustStatus, B.ReasonCD, A.BillPayMtRec, B.EmpID, C.EmpFName || ' ' || C.EmpLName as "Employee" From Billing A, Customer_Master B, Employee_Master C Where A.Billdate < (Sysdate - 30) and A.CustNo = B.CustNo and C.EmpID = B.EmpID; spool off;