INSERT INTO Camera VALUES (1,'IN');
INSERT INTO Camera VALUES (2,'IN');
INSERT INTO Camera VALUES (3,'IN');
INSERT INTO Camera VALUES (4,'IN');
INSERT INTO Camera VALUES (5,'IN');
INSERT INTO Camera VALUES (6,'IN');
INSERT INTO Camera VALUES (7,'IN');
INSERT INTO Camera VALUES (8,'IN');
INSERT INTO Camera VALUES (9,'OUT');
INSERT INTO Camera VALUES (10,'OUT');
INSERT INTO Camera VALUES (11,'OUT');
INSERT INTO Camera VALUES (12,'OUT');
INSERT INTO Camera VALUES (13,'OUT');
INSERT INTO Camera VALUES (14,'OUT');
INSERT INTO Camera VALUES (15,'OUT');
INSERT INTO Camera VALUES (16,'OUT');
INSERT INTO Camera VALUES (17,'');
INSERT INTO Camera VALUES (18,'');
INSERT INTO Camera VALUES (19,'');

INSERT INTO Keeper VALUES (1,'Ambiguous, Arthur','Absorption Ave.');
INSERT INTO Keeper VALUES (2,'Inconspicuous, Iain','Interception Rd.');
INSERT INTO Keeper VALUES (3,'Contiguous, Carol','Circumscription Close');
INSERT INTO Keeper VALUES (4,'Strenuous, Sam','Surjection Street');
INSERT INTO Keeper VALUES (5,'Assiduous, Annie','Attribution Alley');
INSERT INTO Keeper VALUES (6,'Incongruous, Ingrid','Irresolution Pl.');

INSERT INTO Vehicle VALUES ('SO 02 ASP',1);
INSERT INTO Vehicle VALUES ('SO 02 BSP',3);
INSERT INTO Vehicle VALUES ('SO 02 CSP',1);
INSERT INTO Vehicle VALUES ('SO 02 DSP',4);
INSERT INTO Vehicle VALUES ('SO 02 ESP',1);
INSERT INTO Vehicle VALUES ('SO 02 FSP',3);
INSERT INTO Vehicle VALUES ('SO 02 GSP',6);
INSERT INTO Vehicle VALUES ('SO 02 HSP',5);
INSERT INTO Vehicle VALUES ('SO 02 ISP',6);
INSERT INTO Vehicle VALUES ('SO 02 JSP',2);
INSERT INTO Vehicle VALUES ('SO 02 KSP',5);
INSERT INTO Vehicle VALUES ('SO 02 LSP',2);
INSERT INTO Vehicle VALUES ('SO 02 MSP',2);
INSERT INTO Vehicle VALUES ('SO 02 NSP',4);
INSERT INTO Vehicle VALUES ('SO 02 OSP',6);
INSERT INTO Vehicle VALUES ('SO 02 PSP',4);
INSERT INTO Vehicle VALUES ('SO 02 QSP',6);
INSERT INTO Vehicle VALUES ('SO 02 RSP',1);
INSERT INTO Vehicle VALUES ('SO 02 SSP',2);
INSERT INTO Vehicle VALUES ('SO 02 TSP',6);
INSERT INTO Vehicle VALUES ('SO 02 ATP',1);
INSERT INTO Vehicle VALUES ('SO 02 BTP',2);
INSERT INTO Vehicle VALUES ('SO 02 CTP',1);
INSERT INTO Vehicle VALUES ('SO 02 DTP',3);
INSERT INTO Vehicle VALUES ('SO 02 ETP',5);
INSERT INTO Vehicle VALUES ('SO 02 FTP',4);
INSERT INTO Vehicle VALUES ('SO 02 GTP',5);
INSERT INTO Vehicle VALUES ('SO 02 HTP',2);
INSERT INTO Vehicle VALUES ('SO 02 ITP',2);
INSERT INTO Vehicle VALUES ('SO 02 JTP',4);
INSERT INTO Vehicle VALUES ('SO 02 KTP',3);
INSERT INTO Vehicle VALUES ('SO 02 MUP',NULL);
INSERT INTO Vehicle VALUES ('SO 02 NUP',NULL);
INSERT INTO Vehicle VALUES ('SO 02 OUP',NULL);
INSERT INTO Vehicle VALUES ('SO 02 PUP',NULL);
INSERT INTO Vehicle VALUES ('SO 02 QUP',NULL);

INSERT INTO Image VALUES (1,TO_DATE('25 Feb 2003 06:10:00','dd Mon YYYY HH24:MI:SS'),'SO 02 ASP');
INSERT INTO Image VALUES (17,TO_DATE('25 Feb 2003 06:20:00','dd Mon YYYY HH24:MI:SS'),'SO 02 ASP');
INSERT INTO Image VALUES (18,TO_DATE('25 Feb 2003 06:23:11','dd Mon YYYY HH24:MI:SS'),'SO 02 ASP');
INSERT INTO Image VALUES (9,TO_DATE('25 Feb 2003 06:26:22','dd Mon YYYY HH24:MI:SS'),'SO 02 ASP');
INSERT INTO Image VALUES (17,TO_DATE('25 Feb 2003 06:57:44','dd Mon YYYY HH24:MI:SS'),'SO 02 CSP');
INSERT INTO Image VALUES (17,TO_DATE('25 Feb 2003 07:00:55','dd Mon YYYY HH24:MI:SS'),'SO 02 CSP');
INSERT INTO Image VALUES (12,TO_DATE('25 Feb 2003 07:04:06','dd Mon YYYY HH24:MI:SS'),'SO 02 CSP');
INSERT INTO Image VALUES (5,TO_DATE('25 Feb 2003 07:10:28','dd Mon YYYY HH24:MI:SS'),'SO 02 GSP');
INSERT INTO Image VALUES (16,TO_DATE('25 Feb 2003 07:13:39','dd Mon YYYY HH24:MI:SS'),'SO 02 GSP');
INSERT INTO Image VALUES (,TO_DATE('00 Jan 1900 00:00:00','dd Mon YYYY HH24:MI:SS'),'');
INSERT INTO Image VALUES (2,TO_DATE('25 Feb 2003 07:20:01','dd Mon YYYY HH24:MI:SS'),'SO 02 TSP');
INSERT INTO Image VALUES (19,TO_DATE('25 Feb 2003 07:23:12','dd Mon YYYY HH24:MI:SS'),'SO 02 TSP');
INSERT INTO Image VALUES (19,TO_DATE('25 Feb 2003 07:26:23','dd Mon YYYY HH24:MI:SS'),'SO 02 TSP');
INSERT INTO Image VALUES (19,TO_DATE('25 Feb 2003 07:29:34','dd Mon YYYY HH24:MI:SS'),'SO 02 TSP');
INSERT INTO Image VALUES (8,TO_DATE('25 Feb 2003 07:35:56','dd Mon YYYY HH24:MI:SS'),'SO 02 CSP');
INSERT INTO Image VALUES (18,TO_DATE('25 Feb 2003 07:39:07','dd Mon YYYY HH24:MI:SS'),'SO 02 CSP');
INSERT INTO Image VALUES (18,TO_DATE('25 Feb 2003 07:42:18','dd Mon YYYY HH24:MI:SS'),'SO 02 CSP');
INSERT INTO Image VALUES (10,TO_DATE('25 Feb 2003 07:45:29','dd Mon YYYY HH24:MI:SS'),'SO 02 CSP');
INSERT INTO Image VALUES (8,TO_DATE('25 Feb 2003 07:48:40','dd Mon YYYY HH24:MI:SS'),'SO 02 CSP');
INSERT INTO Image VALUES (19,TO_DATE('25 Feb 2003 07:51:51','dd Mon YYYY HH24:MI:SS'),'SO 02 CSP');
INSERT INTO Image VALUES (18,TO_DATE('25 Feb 2003 07:55:02','dd Mon YYYY HH24:MI:SS'),'SO 02 CSP');
INSERT INTO Image VALUES (11,TO_DATE('25 Feb 2003 07:58:13','dd Mon YYYY HH24:MI:SS'),'SO 02 CSP');
INSERT INTO Image VALUES (18,TO_DATE('25 Feb 2003 16:28:35','dd Mon YYYY HH24:MI:SS'),'SO 02 SSP');
INSERT INTO Image VALUES (9,TO_DATE('25 Feb 2003 16:31:46','dd Mon YYYY HH24:MI:SS'),'SO 02 SSP');
INSERT INTO Image VALUES (,TO_DATE('00 Jan 1900 00:00:00','dd Mon YYYY HH24:MI:SS'),'');
INSERT INTO Image VALUES (18,TO_DATE('25 Feb 2003 16:38:08','dd Mon YYYY HH24:MI:SS'),'SO 02 RSP');
INSERT INTO Image VALUES (9,TO_DATE('25 Feb 2003 16:39:00','dd Mon YYYY HH24:MI:SS'),'SO 02 RSP');
INSERT INTO Image VALUES (9,TO_DATE('25 Feb 2003 16:45:22','dd Mon YYYY HH24:MI:SS'),'SO 02 HSP');
INSERT INTO Image VALUES (9,TO_DATE('25 Feb 2003 16:48:33','dd Mon YYYY HH24:MI:SS'),'SO 02 HSP');
INSERT INTO Image VALUES (9,TO_DATE('25 Feb 2003 16:51:44','dd Mon YYYY HH24:MI:SS'),'SO 02 HSP');
INSERT INTO Image VALUES (9,TO_DATE('25 Feb 2003 16:58:06','dd Mon YYYY HH24:MI:SS'),'SO 02 ISP');
INSERT INTO Image VALUES (12,TO_DATE('25 Feb 2003 17:01:17','dd Mon YYYY HH24:MI:SS'),'SO 02 ISP');
INSERT INTO Image VALUES (,TO_DATE('00 Jan 1900 00:00:00','dd Mon YYYY HH24:MI:SS'),'');
INSERT INTO Image VALUES (3,TO_DATE('25 Feb 2003 17:07:39','dd Mon YYYY HH24:MI:SS'),'SO 02 JSP');
INSERT INTO Image VALUES (18,TO_DATE('25 Feb 2003 17:10:50','dd Mon YYYY HH24:MI:SS'),'SO 02 JSP');
INSERT INTO Image VALUES (19,TO_DATE('25 Feb 2003 17:14:01','dd Mon YYYY HH24:MI:SS'),'SO 02 JSP');
INSERT INTO Image VALUES (3,TO_DATE('25 Feb 2003 17:17:12','dd Mon YYYY HH24:MI:SS'),'SO 02 JSP');
INSERT INTO Image VALUES (10,TO_DATE('25 Feb 2003 18:23:34','dd Mon YYYY HH24:MI:SS'),'SO 02 MUP');
INSERT INTO Image VALUES (11,TO_DATE('25 Feb 2003 18:26:45','dd Mon YYYY HH24:MI:SS'),'SO 02 NUP');
INSERT INTO Image VALUES (12,TO_DATE('25 Feb 2003 18:29:56','dd Mon YYYY HH24:MI:SS'),'SO 02 OUP');
INSERT INTO Image VALUES (3,TO_DATE('25 Feb 2003 18:33:07','dd Mon YYYY HH24:MI:SS'),'SO 02 PUP');
INSERT INTO Image VALUES (15,TO_DATE('25 Feb 2003 18:36:18','dd Mon YYYY HH24:MI:SS'),'SO 02 PUP');
INSERT INTO Image VALUES (3,TO_DATE('25 Feb 2003 18:39:29','dd Mon YYYY HH24:MI:SS'),'SO 02 PUP');

INSERT INTO Image VALUES (10,TO_DATE('26 Feb 2003 05:13:11','dd Mon YYYY HH24:MI:SS'),'SO 02 TSP');

INSERT INTO Image VALUES (18,TO_DATE('25 Feb 2003 16:28:32','dd Mon YYYY HH24:MI:SS'),'SO 02 DSP');
INSERT INTO Image VALUES (19,TO_DATE('25 Feb 2003 16:31:43','dd Mon YYYY HH24:MI:SS'),'SO 02 DSP');
INSERT INTO Image VALUES (19,TO_DATE('25 Feb 2003 17:42:56','dd Mon YYYY HH24:MI:SS'),'SO 02 DSP');
INSERT INTO Image VALUES (9,TO_DATE('25 Feb 2003 18:54:09','dd Mon YYYY HH24:MI:SS'),'SO 02 DSP');


INSERT INTO Image VALUES (3,TO_DATE('25 Feb 2003 17:16:44','dd Mon YYYY HH24:MI:SS'),'SO 02 ESP');
INSERT INTO Image VALUES (10,TO_DATE('25 Feb 2003 18:08:55','dd Mon YYYY HH24:MI:SS'),'SO 02 ESP');
INSERT INTO Image VALUES (11,TO_DATE('25 Feb 2003 18:08:56','dd Mon YYYY HH24:MI:SS'),'SO 02 FSP');
INSERT INTO Image VALUES (12,TO_DATE('25 Feb 2003 18:08:56','dd Mon YYYY HH24:MI:SS'),'SO 02 GSP');






INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 ASP',TO_DATE('21 Jan 2002 00:00','dd Mon YYYY HH24:MI'),'Weekly');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 BSP',TO_DATE('30 Jan 2002 00:00','dd Mon YYYY HH24:MI'),'Weekly');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 CSP',TO_DATE('21 Jan 2003 00:00','dd Mon YYYY HH24:MI'),'Weekly');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 DSP',TO_DATE('30 Jan 2003 00:00','dd Mon YYYY HH24:MI'),'Weekly');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 ESP',TO_DATE('21 Feb 2003 00:00','dd Mon YYYY HH24:MI'),'Weekly');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 FSP',TO_DATE('25 Feb 2003 00:00','dd Mon YYYY HH24:MI'),'Weekly');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 GSP',TO_DATE('28 Feb 2003 00:00','dd Mon YYYY HH24:MI'),'Weekly');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 HSP',TO_DATE('21 Jan 2002 00:00','dd Mon YYYY HH24:MI'),'Monthly');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 ISP',TO_DATE('30 Jan 2002 00:00','dd Mon YYYY HH24:MI'),'Monthly');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 JSP',TO_DATE('21 Jan 2003 00:00','dd Mon YYYY HH24:MI'),'Monthly');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 KSP',TO_DATE('30 Jan 2003 00:00','dd Mon YYYY HH24:MI'),'Monthly');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 LSP',TO_DATE('21 Feb 2003 00:00','dd Mon YYYY HH24:MI'),'Monthly');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 MSP',TO_DATE('25 Feb 2003 00:00','dd Mon YYYY HH24:MI'),'Monthly');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 NSP',TO_DATE('28 Feb 2003 00:00','dd Mon YYYY HH24:MI'),'Monthly');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 OSP',TO_DATE('21 Jan 2002 00:00','dd Mon YYYY HH24:MI'),'Monthly');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 PSP',TO_DATE('30 Jan 2002 00:00','dd Mon YYYY HH24:MI'),'Monthly');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 QSP',TO_DATE('21 Jan 2003 00:00','dd Mon YYYY HH24:MI'),'Annual');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 RSP',TO_DATE('30 Jan 2003 00:00','dd Mon YYYY HH24:MI'),'Annual');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 SSP',TO_DATE('21 Feb 2003 00:00','dd Mon YYYY HH24:MI'),'Annual');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 TSP',TO_DATE('25 Feb 2003 00:00','dd Mon YYYY HH24:MI'),'Annual');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 ATP',TO_DATE('21 Jan 2003 00:00','dd Mon YYYY HH24:MI'),'Daily');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 BTP',TO_DATE('30 Jan 2002 00:00','dd Mon YYYY HH24:MI'),'Daily');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 CTP',TO_DATE('21 Jan 2003 00:00','dd Mon YYYY HH24:MI'),'Daily');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 DTP',TO_DATE('30 Jan 2003 00:00','dd Mon YYYY HH24:MI'),'Daily');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 ETP',TO_DATE('21 Feb 2003 00:00','dd Mon YYYY HH24:MI'),'Daily');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 FTP',TO_DATE('25 Feb 2003 00:00','dd Mon YYYY HH24:MI'),'Daily');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 GTP',TO_DATE('28 Feb 2003 00:00','dd Mon YYYY HH24:MI'),'Daily');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 HTP',TO_DATE('21 Jan 2002 00:00','dd Mon YYYY HH24:MI'),'Daily');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 ITP',TO_DATE('30 Jan 2002 00:00','dd Mon YYYY HH24:MI'),'Daily');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 JTP',TO_DATE('21 Jan 2003 00:00','dd Mon YYYY HH24:MI'),'Daily');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 KTP',TO_DATE('30 Jan 2003 00:00','dd Mon YYYY HH24:MI'),'Daily');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 ATP',TO_DATE('22 Jan 2003 00:00','dd Mon YYYY HH24:MI'),'Daily');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 BTP',TO_DATE('31 Jan 2002 00:00','dd Mon YYYY HH24:MI'),'Daily');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 CTP',TO_DATE('22 Jan 2003 00:00','dd Mon YYYY HH24:MI'),'Daily');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 DTP',TO_DATE('31 Jan 2003 00:00','dd Mon YYYY HH24:MI'),'Daily');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 ETP',TO_DATE('22 Feb 2003 00:00','dd Mon YYYY HH24:MI'),'Daily');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 FTP',TO_DATE('26 Feb 2003 00:00','dd Mon YYYY HH24:MI'),'Daily');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 GTP',TO_DATE('01 Mar 2003 00:00','dd Mon YYYY HH24:MI'),'Daily');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 HTP',TO_DATE('22 Jan 2002 00:00','dd Mon YYYY HH24:MI'),'Daily');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 ITP',TO_DATE('31 Jan 2002 00:00','dd Mon YYYY HH24:MI'),'Daily');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 JTP',TO_DATE('22 Jan 2003 00:00','dd Mon YYYY HH24:MI'),'Daily');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 KTP',TO_DATE('31 Jan 2003 00:00','dd Mon YYYY HH24:MI'),'Daily');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 BTP',TO_DATE('03 Feb 2003 00:00','dd Mon YYYY HH24:MI'),'Daily');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 BTP',TO_DATE('04 Feb 2003 00:00','dd Mon YYYY HH24:MI'),'Daily');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 BTP',TO_DATE('05 Feb 2003 00:00','dd Mon YYYY HH24:MI'),'Daily');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 BTP',TO_DATE('06 Feb 2003 00:00','dd Mon YYYY HH24:MI'),'Daily');
INSERT INTO Permit(reg, sdate, chargeType) VALUES ('SO 02 BTP',TO_DATE('07 Feb 2003 00:00','dd Mon YYYY HH24:MI'),'Daily');
-- Typo question 4 refers to 20 Jan 2003 instead of 21 Jan 2003 as intended
UPDATE Permit
 SET sDate = TO_DATE('20 Jan 2003 00:00','dd Mon YYYY HH24:MI')
WHERE sDate =TO_DATE('21 Jan 2003 00:00','dd Mon YYYY HH24:MI');