API tools faq
paste
Advertisement
psi_mmobile

Untitled

psi_mmobile
Oct 22nd, 2019
404
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 28.39 KB | None | 0 0
raw download clone embed print report
  1. SELECT * FROM gui_users
  2. WHERE loginname = 'TRAXXEOTEAM';--104709
  3.  
  4. SELECT * FROM gu_vehicle_owner
  5. WHERE gui_user_id = 104709;
  6.  
  7. SELECT * FROM vo_person_category
  8. WHERE vehicle_owner_id = 101383;
  9.  
  10. --HOME_POI_CATEGORY_ID = 101999
  11. --OPERATION_CENTER_ID = 101956
  12. --GUI_USER_ID = 104709
  13. --VO_PERSON_CATEGORY_ID = 104155
  14. --VEHICLE_OWNER_ID = 101383
  15.  
  16.  
  17. COMMIT;
  18.  
  19. SELECT p.last_name || ' ' || p.first_name AS PersonName, op.name AS PoiName, op.WGS84_LATITUDE, op.WGS84_LONGITUDE FROM person p, oc_poi op
  20. WHERE p.home_poi_id = op.poi_id
  21. AND p.lm_comment = 'TRAXXEOTEAM TEST DATA'
  22. ORDER BY 1 DESC;
  23.  
  24.  
  25.  
  26. SELECT DISTINCT gui_user_id FROM gu_person
  27. WHERE person_id IN (SELECT p.person_id FROM person p, oc_poi op
  28. WHERE p.home_poi_id = op.poi_id
  29. AND p.lm_comment = 'TRAXXEOTEAM TEST DATA');
  30. COMMIT;
  31. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Boterberg Johan',101999,200,'LIMELETTE',1342,'rue Alfred Haulotte','33A',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  32. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Johan','Boterberg','0479/33 47 92','95100936374','102',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  33. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Bougelet  Maxime',101999,200,'BONNEVILLE',5300,'Rue de la Bruyère ','72 bte 2',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  34. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Maxime','Bougelet ','0476/45 93 63','83102620750','103',seq_oc_poi_id.CURRVAL,'BATIS MOI ');
  35. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Collet Simon',101999,200,'THUIN',6530,'ruelle Jacques ','11',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  36. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Simon','Collet','0472/78 54 79','97061851752','104',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  37. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'De Blecker Ludovic',101999,200,'COURCELLES',6180,'rue du Nord','30',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  38. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Ludovic','De Blecker','0471/87 80 23','87081721789','106',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  39. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'De Smedt Yannick',101999,200,'FELUY',7181,'rue de la Coulette','3',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  40. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Yannick','De Smedt','0479/03 83 18','84012608137','107',seq_oc_poi_id.CURRVAL,'BATIS MOI ');
  41. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Debienne Guillaume',101999,200,'NIVELLES',1400,'rue 2 soc nationales','18',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  42. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Guillaume','Debienne','0484/93 44 89','89102710356','108',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  43. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Deminne Frederic',101999,200,'BAISY-THY',1470,'rue Longchamps','56 bte 4',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  44. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Frederic','Deminne','0496/35 63 30','85100837378','109',seq_oc_poi_id.CURRVAL,'BATIS MOI ');
  45. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Dhondt Samuel',101999,200,'BRAINE L''ALLEUD',1420,'Grand Route','309',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  46. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Samuel','Dhondt','0470/52 49 34','96122637770','110',seq_oc_poi_id.CURRVAL,'BATIS MOI ');
  47. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Dubois Henri',101999,200,'VILLERS-LA-VILLE',1495,'rue de Mellery','36',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  48. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Henri','Dubois','0473/86 50 64','79020835907','112',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  49. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Duran Quentin',101999,200,'GENAPPE',1470,'rue de la Roche','3',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  50. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Quentin','Duran','0475/55 29 69','91061312778','114',seq_oc_poi_id.CURRVAL,'RECYMAT ');
  51. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Ems Adrien',101999,200,'GEMBLOUX',5030,'rue de Babilaire','44256',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  52. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Adrien','Ems','0494/85 06 38','97100128150','116',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  53. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Ivanov Sergei',101999,200,'ROUX',6044,'Avenue de Wallonie','22',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  54. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Sergei','Ivanov','0496/95 40 11','72092551123','121',seq_oc_poi_id.CURRVAL,'TC MAT');
  55. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Lebrun Killian',101999,200,'CHASTRE',6450,'rue Alphonse Minique','33',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  56. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Killian','Lebrun','0492/57 56 83','00051623360','123',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  57. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Mostenne Rémy',101999,200,'FOSSE-LA-VILLE',5070,'Route de St Gérard ','45',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  58. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Rémy','Mostenne','0472/75 62 05','90011417343','127',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  59. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Thibaut Pascal',101999,200,'WALHAIN',1457,'rue Gally','36',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  60. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Pascal','Thibaut','0499/75 14 40','74010235381','130',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  61. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Vanthielen Cédric',101999,200,'RANSART',6043,'Rue de la Bassée','75',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  62. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Cédric','Vanthielen','0479/91 01 59','74122129138','131',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  63. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Vandenberg Thomas',101999,200,'MARBAIS',1495,'rue de la Jouerie','49',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  64. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Thomas','Vandenberg','0479/88 29 10','86122129592','132',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  65. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Vanespen Laurent',101999,200,'MONT-ST-GUIBERT',1435,'rue de Corbais','7',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  66. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Laurent','Vanespen','0476/64 11 42','75050540387','133',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  67. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Ventre de la Touloubre Mathieu',101999,200,'VILLERS-LA-VILLE',1495,'rue Froide Bise','50',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  68. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Mathieu','Ventre de la Touloubre','0476/56 60 86','83041112555','134',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  69. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Vindevogel Frédéric',101999,200,'SART-DAMES-AVELINE',1495,'chaussée de Numur','18',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  70. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Frédéric','Vindevogel','0476/60 49 79','75050631746','136',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  71. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Vroman Antoine',101999,200,'VILLERS-LA-VILLE',1495,'rue Tienne','27',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  72. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Antoine','Vroman','0472/37 42 60','98081150320','137',seq_oc_poi_id.CURRVAL,'RECYMAT');
  73. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Vroman Maxime',101999,200,'VILLERS-LA-VILLE',1495,'rue Tienne','27',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  74. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Maxime','Vroman','0477/20 27 79','92051326353','138',seq_oc_poi_id.CURRVAL,'RECYMAT');
  75. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Wellin Martine',101999,200,'SUARLEE',5020,'Clair Val','34',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  76. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Martine','Wellin','0494/76 07 20','65122708866','139',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  77. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Thiry Romaric',101999,200,'VIEUX GENAPPE',1472,'Chaussée de Nivelles','65',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  78. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Romaric','Thiry','0493/43 10 67','91041816174','140',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  79. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Duval Damien',101999,200,'FRASNE-LEZ-GOSSELIES',6210,'Chaussée de Bruxelles','690',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  80. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Damien','Duval','0470/37 01 28','88031522728','143',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  81. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Pierrot Félix',101999,200,'BUZET',6230,'Chaussée de Nivelles','697',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  82. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Félix','Pierrot','0472/ 04 01 77','98080133701','145',seq_oc_poi_id.CURRVAL,'RECYMAT');
  83. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Rabelo Batista Igor',101999,200,'JEMEPPE SUR SAMBRE',5190,'Rue Neuve ','5',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  84. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Igor','Rabelo Batista','0475/82 50 97','93040163357','159',seq_oc_poi_id.CURRVAL,'TC MAT');
  85. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Rody Anthony',101999,200,'SPY',5190,'rue du Megonot','30',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  86. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Anthony','Rody','0493/17 20 85','74040910147','148',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  87. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'De Grom Jérémie',101999,200,'TONGRINNE',5140,'rue Pichelin','93 A1',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  88. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Jérémie','De Grom','0472/37 58 56','90021011336','149',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  89. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Martin Sébastien',101999,200,'MOGNELEE',5060,'Rue Trieu  malonne','3',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  90. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Sébastien','Martin','0492/70 52 23','87072525397','153',seq_oc_poi_id.CURRVAL,'TC MAT');
  91. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Fragapane Salvatore',101999,200,'GILLY',6060,'rue du Coquelet','98/001',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  92. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Salvatore','Fragapane','0476/48 51 51','86112649328','154',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  93. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Neimry Victor',101999,200,'LIGNY',5140,'rue Gaie','12',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  94. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Victor','Neimry','0475/56 54 04','95053025797','155',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  95. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Pelsmaekers Sonia',101999,200,'HUPPAYE',1367,'rue des Fripiers','18',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  96. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Sonia','Pelsmaekers','0494/38 16 57','64032527450','156',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  97. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Brichard Renaud',101999,200,'SART-EUSTACHE',5070,'rue du Sartia','28',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  98. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Renaud','Brichard','0486/07 58 41','76022634795','157',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  99. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Lambert Cédric',101999,200,'FERNELMONT',5380,'rue de la Tour','2',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  100. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Cédric','Lambert','0475/25 27 86','78080832364','158',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  101. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Lopez Filipe',101999,200,'BRAINE LE CHÂTEAU',1440,'rue de Nivelles','50',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  102. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Filipe','Lopez','0471/39 29 29 ','95091624374','125',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  103. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Meynaerts Vincent',101999,200,'SART-DAMES-AVELINES',1495,'rue St Jean','14',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  104. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Vincent','Meynaerts','0474/44 20 88','89052250956','126',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  105. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Oubouaziz Anas',101999,200,'JUMET',6040,'rue de l''Abbaye','40',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  106. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Anas','Oubouaziz','0472/29 42 82','88040336563','128',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  107. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Veraghaenne Didier',101999,200,'VILLERS-LA-VILLE',1495,'rue de l''Epine','4',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  108. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Didier','Veraghaenne','0496/52 95 60','71031322128','135',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  109. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Verset Quentin',101999,200,'VILLERS-PERWIN',6210,'chaussée de Bruxelles','337',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  110. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Quentin','Verset','0479/42 47 37','97072130782','142',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  111. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Damman Marc',101999,200,'DAUSSOIS',5630,'rue de Villers','2',SYSDATE,'PSI','TRAXXEOTEAM TEST DATA',0,0);
  112. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','TRAXXEOTEAM TEST DATA',SYSDATE, 0, seq_person_id.NEXTVAL,104155,'Marc','Damman','0498/93 64 77','84031908355','160',seq_oc_poi_id.CURRVAL,'BATIS MOI');
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!