Advertisement
psi_mmobile

Untitled

Jan 31st, 2020
730
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 22.57 KB | None | 0 0
  1. -- INSERT STATEMENTS
  2. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'LIXON',102017,'Ghlin','7011','Cité du Festinoy','BE',NULL,SYSDATE,'YKI',NULL,'1909021',NULL,0);
  3. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'ACH Construct',102017,'Sirault','7332','rue Emile Lété','BE',NULL,SYSDATE,'YKI',NULL,'1906119',NULL,0);
  4. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'HERPAIN',102017,'Saint Gilles','1060','Chaussée de Charleroi','BE','52',SYSDATE,'YKI',NULL,'1903080',NULL,0);
  5. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'HERPAIN',102017,'Bruxelles','1000','rue de la Vierge Noire','BE','2',SYSDATE,'YKI',NULL,'1811040',NULL,0);
  6. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'INTERBUILD',102017,'Bruxelles','1000',' Koning Albert II laan','BE','34',SYSDATE,'YKI',NULL,'1804000',NULL,0);
  7. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'THV CIVIEL LINKEROEVER',102017,'Antwerpen','2050','Linkeroever','BE',NULL,SYSDATE,'YKI',NULL,'1911098',NULL,0);
  8. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'VALENS',102017,'Laeken','1020','Bd Emile Bockstael','BE','304',SYSDATE,'YKI',NULL,'1812015',NULL,0);
  9. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'DEVOS TEGELBEDRIJF',102017,'Lauwe','8930','Koningin Astridlaan','BE','45',SYSDATE,'YKI',NULL,'1910097',NULL,0);
  10. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'BESIX',102017,'Gent','9000','Doornzelestraat','BE','23',SYSDATE,'YKI',NULL,'1907010',NULL,0);
  11. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'FRANKI',102017,'Neder-over-Hembeek','1120','Rue de Ransbeek','BE',NULL,SYSDATE,'YKI',NULL,'1905090',NULL,0);
  12. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'CFE INFRA',102017,'Forest','1190','rue Bolinckx','BE','319',SYSDATE,'YKI',NULL,'1806000',NULL,0);
  13. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'SM DHERTE GILLION',102017,'Brugelette','7940','Domaine de Cambron','BE',NULL,SYSDATE,'YKI',NULL,'1905000',NULL,0);
  14. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'SM IN ADVANCE DE WAELE',102017,'Bruxelles','1000','Place De Brouckère','BE',NULL,SYSDATE,'YKI',NULL,'1905055',NULL,0);
  15. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'ACH Construct',102017,'Bruxelles','1080','av Edmont Candries','BE',NULL,SYSDATE,'YKI',NULL,'1910012',NULL,0);
  16. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'GILLION',102017,'Bruxelles','1050','avenue du Bois de la Cambre','BE','173',SYSDATE,'YKI',NULL,'1908063',NULL,0);
  17. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'THV RENOTEC CIT BLATON',102017,'Anderlecht','1070','Van Winghenstraat','BE','1',SYSDATE,'YKI',NULL,'1805011',NULL,0);
  18. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'JANSSEN',102017,'Mechelen','2800','Tichelrij','BE','12',SYSDATE,'YKI',NULL,'1903017',NULL,0);
  19. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'TRADECO BELGIUM',102017,'La Louvière','7100','Avenue Max Buset','BE','34',SYSDATE,'YKI',NULL,'1909100',NULL,0);
  20. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'CUBICS',102017,'Nivelles','1400',' Allée du Jacquemart','BE','21',SYSDATE,'YKI',NULL,'1904096',NULL,0);
  21. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'THV HOUBEN ARTES ROEGIERS',102017,'Jette','1090','Laarbeeklaan','BE','101',SYSDATE,'YKI',NULL,'1911033',NULL,0);
  22. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'ACH Construct',102017,'Bruxelles','1080',' Av. Armand Saulnier','BE',NULL,SYSDATE,'YKI',NULL,'1908046',NULL,0);
  23. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'LIXON',102017,'Bruxelles','1000','rue des Potiers','BE','1',SYSDATE,'YKI',NULL,'1903178',NULL,0);
  24. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'JANSSEN',102017,'Mechelen','2800','Populierendreef','BE',NULL,SYSDATE,'YKI',NULL,'1904003',NULL,0);
  25. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'ELOY',102017,'Oupeye','4680','rue du Roi Albert','BE','158',SYSDATE,'YKI',NULL,'1909137',NULL,0);
  26. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'KOECKELBERG',102017,'Schaerbeek','1030','rue de la Luzerne','BE','11',SYSDATE,'YKI',NULL,'1905045',NULL,0);
  27. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'ARTES TWT',102017,'MILMORT','4041',NULL,'BE',NULL,SYSDATE,'YKI',NULL,'1810057',NULL,0);
  28. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'JANSSEN',102017,'HASSELT','3500','Groenplein','BE',NULL,SYSDATE,'YKI',NULL,'1904024',NULL,0);
  29. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'LIXON',102017,'Chièvres','7590','Clos Guillaume de Croy','BE',NULL,SYSDATE,'YKI',NULL,'1909076',NULL,0);
  30. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'GILLION',102017,'Ixelles','1050','Rue Gray 167','BE',NULL,SYSDATE,'YKI',NULL,'1903129',NULL,0);
  31. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'HOUBEN',102017,'Peer','3990','Rode Kruisstraat','BE','25',SYSDATE,'YKI',NULL,'1908106',NULL,0);
  32. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'A PROJECT',102017,'Tisselt','2830','Bormstraat','BE','24',SYSDATE,'YKI',NULL,'1907005',NULL,0);
  33. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'BIGMAT GREZ DOICEAU',102019,'Grez-Doiceau ','1390','Chaussée de Wavre','BE','362',SYSDATE,'YKI','lun-ven 06h30-18h00 / sam 07h00-13h00','BIGMATG','010 84 15 28',0);
  34. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'BIGMAT HAREN',102019,'Haren','1130','rue Arthur Maes','BE','100',SYSDATE,'YKI','lun-jeu 06h30-17h00 / ven 06h30-15h00 / sam 08h00-15h00','BIGMATH','02 899 09 08',0);
  35. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'EMB',102019,'Haren','1130','Witloofstationstraat','BE',NULL,SYSDATE,'YKI','lun-ven 06h30-16h00','EMB','02 215 19 49',0);
  36. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'DC RESOURCES BXL',102019,'Bruxelles','1000','Quai Leon Monnoyer','BE','11',SYSDATE,'YKI','lun-ven 04h00-18h00 / sam 05h00-12h00','DCRESOU','02 248 22 41',0);
  37. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'DELAHAYE LAUWERS',102019,'Gent','9000','Zuiddokweg (sable 08)','BE','50',SYSDATE,'YKI','lun-jeu 9h00-15h00 / ven 09h00-12h00','DELAHAY','09 251 15 22',0);
  38. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'DECLERCQ',102018,'Harelbeke','8530','Keizersstraat','BE','48',SYSDATE,'YKI','lun-jeu 9h00-15h00 / ven 09h00-12h00','DECLHAR','056 600 915',0);
  39. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'DECLERCQ',102018,'Tielt','8700','Galgenveldstraat','BE','7',SYSDATE,'YKI','lun-jeu 9h00-15h00 / ven 09h00-12h00','DECLTIE','056 600 915',0);
  40. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'DECLERCQ',102018,'Deinze','9800','Vaart Rechtoever',NULL,'59',SYSDATE,'YKI','lun-jeu 9h00-15h00 / ven 09h00-12h00','DECLDEI','056 600 915',0);
  41. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'DRANACO',102019,'Antwerpen','2020','D''Herbouvillekaai BGA','BE',NULL,SYSDATE,'YKI','lun-ven 06h00-16h30','DRANANT','03 231 08 54',0);
  42. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'DRANACO (Site Eurodal)',102019,'Grobbendonk','2280','Industrieweg','BE','14',SYSDATE,'YKI','lun-ven 06h00-15h00','DRANAGR','03 231 08 54',0);
  43. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'GEDIMAT COLLOT',102019,'Namur','5100','n4-Chaussée de Marcht','BE','730',SYSDATE,'YKI','lun-ven 7h30-12h00/12h45-17h00 / sam 07h30-12h00','GEDCOLL','081 40 80 70',0);
  44. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'GOBERT Anderlecht',102019,'Anderlecht','1070','Quai de Biestebroeck','BE','90',SYSDATE,'YKI','lun-ven 6h00-12h00/12h45-16h00','GOBANDE','02 522 79 37',0);
  45. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'GOBERT Ghlin',102019,'Ghlin','7011','Route de Wallonie','BE','33',SYSDATE,'YKI','lun-ven 7h00-12h00/12h45-17h00 / sam 08h00-12h00','GOBGHLI','065 39 55 10',0);
  46. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'GOBERT Nivelles',102019,'Nivelles','1400','Chaussée de Braine le comte','BE','8',SYSDATE,'YKI','lun-ven 7h00-12h00/12h45-17h00 / sam 08h00-12h00','GOBNIVE','067 89 48 70',0);
  47. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'GOBERT Soignies',102019,'Soignies','7060','Chemin de la Guelenne','BE','29',SYSDATE,'YKI','lun-ven 7h00-12h00/12h45-17h00 / sam 08h00-12h00','GOBSOIG','067 34 71 10',0);
  48. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'GOBERT Strépy',102019,'Strepy Bracquegnies','7110','Route du Grand Peuplier','BE','4',SYSDATE,'YKI','lun-ven 7h00-12h00/12h45-17h00 / sam 08h00-12h00','GOBSTRE','064 23 67 10',0);
  49. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'GOBERT Tubize',102019,'Tubize','1480','Av. de la Déportation','BE','218',SYSDATE,'YKI','lun-ven 7h00-12h00/12h45-17h00 / sam 08h00-12h00','GOBTUBI','02 367 10 50',0);
  50. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'GROUP TIELEN',102019,'Dessel','2480','Goormansdijk','BE','68',SYSDATE,'YKI',NULL,'TIELENG','014 38 95 70',0);
  51. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'HOLVOET Avelgem',102019,'Avelgem','8580','Huttegemstraat','BE',NULL,SYSDATE,'YKI','lun-ven 6h00-18h00 / sam 7h30-12h00/13h30-16h30','HOLAVEL','056 64 40 51',0);
  52. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'JOASSIN',102019,'Flawinne','5020','rue Ferdinand Marchand','BE','1',SYSDATE,'YKI','lun-jeu 7h45-17h00 /ven 7h45-16h00','JOASSIN','081 73 71 42',0);
  53. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'LIPPENS BVBA',102019,'Lovendegem','9920','Bilksken','BE','2',SYSDATE,'YKI','lun-ven 7h00-1200 13h00-19h00/ sam 08h00-12h00','LIPPENS','09 372 91 67',0);
  54. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'LOMMAT BXL',102019,'Bruxelles','1000','Quai des Armateurs','BE',NULL,SYSDATE,'YKI',NULL,'LOMMATB','02 582 66 66',0);
  55. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'MATEGRO',102019,'Herstal','4040','rue du Rivage','BE','35',SYSDATE,'YKI','lun-ven 06h00-17h00','MATEGRO','04 248 39 51',0);
  56. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'MINERA EX VEMAT BXL',102019,'Bruxelles','1000','Quai Leon Monnoyer','BE','11',SYSDATE,'YKI','lun-ven 05h00-17h00','MINERAB','02 245 77 52',0);
  57. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'MULTI MIX Gent',102019,'Gent-Wondelgem','9032','Industrieweg','BE','104',SYSDATE,'YKI',' lun-ven 06h00-17h00 / sam 06h00-09h00','MULTIGE','09 226 76 26',0);
  58. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'NHM Brugge',102019,'Brugge','8000','Pathoekeweg','BE','340',SYSDATE,'YKI','lun-ven 05h00 - 18h00','NHMBRUG','058 22 29 40',0);
  59. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'NHM Oostende',102018,'Oostende','8400','Vismijnlaan','BE','2',SYSDATE,'YKI','lun-ven 05h00 - 18h00','NHMOOST','058 22 29 40',0);
  60. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'NHM Izegem',102018,'Izegem','8870','Noordkaai','BE','10',SYSDATE,'YKI','lun-ven 05h00 - 17h00','NHMIZEG','058 22 29 40',0);
  61. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'NHM Nieuwpoort',102018,'Nieuwpoort','8420','Noorderhavenoever','BE','12',SYSDATE,'YKI','lun-ven 05h00 - 18h00','NHMNIEW','058 22 29 40',0);
  62. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'NHM Wielsbeke',102019,'Wielsbeke','8710','Hooimeersstraat','BE','3',SYSDATE,'YKI','lun-ven  06h00 - 17h00','NHMWIEL','058 22 29 40',0);
  63. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'SONIMAT Arquennes',102019,'Arquennes','7181','Chée de Nivelles','BE','91',SYSDATE,'YKI','lun-ven 07h00-17h00 / sam 08h00-13h00','SONIARQ','067 87 85 21',0);
  64. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'TONI MATERIAUX',102019,'Chatelet','6200','Rue de Fleurus','BE',NULL,SYSDATE,'YKI','lun-ven 07h30-12h00 12h30-17h00 / sam 08h00-12h00','TONIMAT','071 38 41 78',0);
  65. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'VERHELST',102019,'Oudenburg','8460','Stationstraat','BE','30',SYSDATE,'YKI','lun-ven 07h00-12h00 12h30-18h00 / sam 08h00-12h00','VERHEOU','059 25 50 50',0);
  66. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'ZANDHANDEL LUMMEN',102019,'Lummen','3560','Industriestraat','BE','16',SYSDATE,'YKI',NULL,'ZANDLUM','011 45 36 89',0);
  67. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'ZANDHANDEL ROESELARE',102019,'Roeselare','8800','Graankaai','BE','4',SYSDATE,'YKI','lun-jeu 05h30-18h00 / ven 05h30-17h00','ZANDROE','051 22 79 55',0);
  68. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'GOBERT ROUCOURT',102019,'Roucourt','7601','Rue de la Guérison','BE','43',SYSDATE,'YKI','lun-ven 07h00-12h00 12h45-17h30 / sam 08h00-12h00','GOBROUC','069 22 27 74',0);
  69. INSERT INTO OC_POI (POI_ID,NAME,OC_POI_CATEGORY_ID, LOCATION, POST_CODE, STREET, COUNTRY, STREET_NR, LM_DATE, LM_NAME, LM_COMMENT, SHORT_NAME, CONTACT_PHONE, OC_POI_STATUS_ID) VALUES (SEQ_OC_POI_ID.NEXTVAL,'VERHELST',102019,'Drongen','9031','Industriepark Drongen I','BE','19',SYSDATE,'YKI','lun-ven 06h30-12h00 12h30-18h00 / sam 08h00-12h00','VERHEDR','09 282 36 56',0);
  70.  
  71. --COMMIT;
  72.  
  73. --GEOCODING FRAGMENTS
  74. --BEGIN
  75.   --P_POI.updateNoGeocodePoiCat(102017);
  76.   --P_POI.updateNoGeocodePoiCat(102018);
  77.   --P_POI.updateNoGeocodePoiCat(102019);
  78. --END;
  79.  
  80. --COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement