API tools faq
paste
Advertisement
psi_mmobile

Untitled

psi_mmobile
Jan 31st, 2020
648
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 22.57 KB | None | 0 0
raw download clone embed print report
  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
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!