Advertisement
psi_mmobile

Untitled

Oct 19th, 2020
1,161
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 8.36 KB | None | 0 0
  1. SET define off
  2. UPDATE MFC_SERVICE SET NAME = 'Gevels beton / Parois béton' WHERE MFC_SERVICE_ID = 13044;
  3. UPDATE MFC_SERVICE SET NAME = 'Gevels metaal / Parois métal' WHERE MFC_SERVICE_ID = 13045;
  4. UPDATE MFC_SERVICE SET NAME = 'Metselwerken / Maçonnerie' WHERE MFC_SERVICE_ID = 13046;
  5. UPDATE MFC_SERVICE SET NAME = 'Plat dak: metalen dakplaten / Toit - tôle galva' WHERE MFC_SERVICE_ID = 13047;
  6. UPDATE MFC_SERVICE SET NAME = 'Hellende daken / Toîture en pente' WHERE MFC_SERVICE_ID = 13048;
  7. UPDATE MFC_SERVICE SET NAME = 'Dakdichting / Etanchéité' WHERE MFC_SERVICE_ID = 13049;
  8. UPDATE MFC_SERVICE SET NAME = 'Lichtstraten en rookluiken / Lanterneaux et coupoles' WHERE MFC_SERVICE_ID = 13050;
  9. UPDATE MFC_SERVICE SET NAME = 'Regenwaterafvoer / Descentes d'eau' WHERE MFC_SERVICE_ID = 13051;
  10. UPDATE MFC_SERVICE SET NAME = 'Riolering / Egouttage' WHERE MFC_SERVICE_ID = 13052;
  11. UPDATE MFC_SERVICE SET NAME = 'Betonvloeren / Dalle de sol en béton' WHERE MFC_SERVICE_ID = 13053;
  12. UPDATE MFC_SERVICE SET NAME = 'Buitenschrijnwerk en gevelafwerking / Menuiserie extérieure et finition de façade' WHERE MFC_SERVICE_ID = 13054;
  13. UPDATE MFC_SERVICE SET NAME = 'Borstwering, stalen trappen en leuningen / Escaliers, terrasses & gardecorps - métal' WHERE MFC_SERVICE_ID = 13055;
  14. UPDATE MFC_SERVICE SET NAME = 'Vloerafwerking / Revêtement de sol' WHERE MFC_SERVICE_ID = 13056;
  15. UPDATE MFC_SERVICE SET NAME = 'Lichte binnenwanden en valse plafonds / Cloisons légères et faux plafonds en gyproc' WHERE MFC_SERVICE_ID = 13057;
  16. UPDATE MFC_SERVICE SET NAME = 'Binnenschrijnwerk / Menuiserie intérieures' WHERE MFC_SERVICE_ID = 13058;
  17. UPDATE MFC_SERVICE SET NAME = 'Schilderwerken / Peintures' WHERE MFC_SERVICE_ID = 13059;
  18. UPDATE MFC_SERVICE SET NAME = 'Elektriciteit en technieken brand / Installation électrique et  Lutte contre l'incendie' WHERE MFC_SERVICE_ID = 13060;
  19. UPDATE MFC_SERVICE SET NAME = 'Sanitair en HVAC / Sanitaire et Chauffage et climatisation' WHERE MFC_SERVICE_ID = 13061;
  20. UPDATE MFC_SERVICE SET NAME = 'Andere technieken / d'autres techniques' WHERE MFC_SERVICE_ID = 13062;
  21. UPDATE MFC_SERVICE SET NAME = 'Omgevingswerken / Amènagement abords' WHERE MFC_SERVICE_ID = 13063;
  22. UPDATE MFC_SERVICE SET NAME = 'Voorbereidende werken' WHERE MFC_SERVICE_ID = 13066;
  23. UPDATE MFC_SERVICE SET NAME = 'Afbraakwerken / Travaux de démolition' WHERE MFC_SERVICE_ID = 13067;
  24. UPDATE MFC_SERVICE SET NAME = 'Grondwerken / Terrassements' WHERE MFC_SERVICE_ID = 13068;
  25. UPDATE MFC_SERVICE SET NAME = 'Funderingswerken / Travaux de fondation' WHERE MFC_SERVICE_ID = 13069;
  26. UPDATE MFC_SERVICE SET NAME = 'Prefabstructuren / Structures prefab' WHERE MFC_SERVICE_ID = 13070;
  27. UPDATE MFC_SERVICE SET NAME = 'Beton ter plaatse gestort / Béton coulé surplace' WHERE MFC_SERVICE_ID = 13071;
  28. UPDATE MFC_SERVICE SET NAME = 'Arbeid ontkisten/laden/storten' WHERE MFC_SERVICE_ID = 13081;
  29. UPDATE MFC_SERVICE SET NAME = 'Voorbereidende werken / Travaux préparatoires' WHERE MFC_SERVICE_ID = 13095;
  30. UPDATE MFC_SERVICE SET NAME = 'Grondwerken / Terrassements' WHERE MFC_SERVICE_ID = 13096;
  31. UPDATE MFC_SERVICE SET NAME = 'Riolering / Egouttage' WHERE MFC_SERVICE_ID = 13097;
  32. UPDATE MFC_SERVICE SET NAME = 'Speciale funderingstechnieken / Techniques de fondation' WHERE MFC_SERVICE_ID = 13098;
  33. UPDATE MFC_SERVICE SET NAME = 'Vloerplaat en funderingen / Dalle de sol et fondations' WHERE MFC_SERVICE_ID = 13099;
  34. UPDATE MFC_SERVICE SET NAME = 'Binnenmetselwerk / Maçonnerie intérieure' WHERE MFC_SERVICE_ID = 13100;
  35. UPDATE MFC_SERVICE SET NAME = 'Afdek vloeren / Sol' WHERE MFC_SERVICE_ID = 13101;
  36. UPDATE MFC_SERVICE SET NAME = 'Betontrappen / Escaliers en béton' WHERE MFC_SERVICE_ID = 13102;
  37. UPDATE MFC_SERVICE SET NAME = 'Buitenspouwblad / Mur creux' WHERE MFC_SERVICE_ID = 13103;
  38. UPDATE MFC_SERVICE SET NAME = 'Daktimmer / Menuiserie de toit' WHERE MFC_SERVICE_ID = 13104;
  39. UPDATE MFC_SERVICE SET NAME = 'Dakbedekking / Couverture du toit' WHERE MFC_SERVICE_ID = 13105;
  40. UPDATE MFC_SERVICE SET NAME = 'Buitenschrijnwerk / Menuiserie extérieure' WHERE MFC_SERVICE_ID = 13106;
  41. UPDATE MFC_SERVICE SET NAME = 'Ventilatie / Ventilation' WHERE MFC_SERVICE_ID = 13107;
  42. UPDATE MFC_SERVICE SET NAME = 'Elektriciteit / Installation électrique' WHERE MFC_SERVICE_ID = 13108;
  43. UPDATE MFC_SERVICE SET NAME = 'Sanitair / Sanitaire' WHERE MFC_SERVICE_ID = 13109;
  44. UPDATE MFC_SERVICE SET NAME = 'Voegwerken buitenspouwblad / Jointoiement mur creux' WHERE MFC_SERVICE_ID = 13110;
  45. UPDATE MFC_SERVICE SET NAME = 'Pleisterwerken / Plâtrage' WHERE MFC_SERVICE_ID = 13111;
  46. UPDATE MFC_SERVICE SET NAME = 'Vloeropbouw / Structure de sol' WHERE MFC_SERVICE_ID = 13112;
  47. UPDATE MFC_SERVICE SET NAME = 'Centrale verwarming / Chauffage' WHERE MFC_SERVICE_ID = 13113;
  48. UPDATE MFC_SERVICE SET NAME = 'Vloerafwerking / Revêtement de sol' WHERE MFC_SERVICE_ID = 13114;
  49. UPDATE MFC_SERVICE SET NAME = 'Binnenschrijnwerk / Menuiserie intérieures' WHERE MFC_SERVICE_ID = 13115;
  50. UPDATE MFC_SERVICE SET NAME = 'Keuken / Cuisine' WHERE MFC_SERVICE_ID = 13116;
  51. UPDATE MFC_SERVICE SET NAME = 'Schilderwerken / Peintures' WHERE MFC_SERVICE_ID = 13117;
  52. UPDATE MFC_SERVICE SET NAME = 'Omgevingswerken / Amènagement abords' WHERE MFC_SERVICE_ID = 13118;
  53. UPDATE MFC_SERVICE SET NAME = 'Naservice / Service après vente' WHERE MFC_SERVICE_ID = 13197;
  54. UPDATE MFC_SERVICE SET NAME = 'Werfopvolging / Suivi de chantier' WHERE MFC_SERVICE_ID = 13198;
  55. UPDATE MFC_SERVICE SET NAME = 'Transport / Transport' WHERE MFC_SERVICE_ID = 13199;
  56. UPDATE MFC_SERVICE SET NAME = 'Arbeid orde/netheid/veiligheid' WHERE MFC_SERVICE_ID = 13716;
  57. UPDATE MFC_SERVICE SET NAME = 'Werfopvolging / Suivi de chantier' WHERE MFC_SERVICE_ID = 13017;
  58. UPDATE MFC_SERVICE SET NAME = 'Voorbereidende werken / Travaux préparatoires' WHERE MFC_SERVICE_ID = 13018;
  59. UPDATE MFC_SERVICE SET NAME = 'Afbraak- en schoringswerken / Travaux de démolition et suspension' WHERE MFC_SERVICE_ID = 13019;
  60. UPDATE MFC_SERVICE SET NAME = 'Funderingstechnieken / Techniques de fondation' WHERE MFC_SERVICE_ID = 13020;
  61. UPDATE MFC_SERVICE SET NAME = 'Grondwerken / Terrassements' WHERE MFC_SERVICE_ID = 13021;
  62. UPDATE MFC_SERVICE SET NAME = 'Riolering / Egouttage' WHERE MFC_SERVICE_ID = 13022;
  63. UPDATE MFC_SERVICE SET NAME = 'Funderingswerken / Travaux de fondation' WHERE MFC_SERVICE_ID = 13023;
  64. UPDATE MFC_SERVICE SET NAME = 'Kelder / Cave' WHERE MFC_SERVICE_ID = 13024;
  65. UPDATE MFC_SERVICE SET NAME = 'Draagstructuur bovenbouw / Ossature de la superstructure' WHERE MFC_SERVICE_ID = 13025;
  66. UPDATE MFC_SERVICE SET NAME = 'Muurisolatie / ISOLATION des murs' WHERE MFC_SERVICE_ID = 13026;
  67. UPDATE MFC_SERVICE SET NAME = 'Buitenspouwblad / Mur creux' WHERE MFC_SERVICE_ID = 13027;
  68. UPDATE MFC_SERVICE SET NAME = 'Niet-dragende binnenmuren / Murs intérieurs non porteurs' WHERE MFC_SERVICE_ID = 13028;
  69. UPDATE MFC_SERVICE SET NAME = 'Prefab trappen en terrassen / Escaliers et terrasses préfabriqués' WHERE MFC_SERVICE_ID = 13029;
  70. UPDATE MFC_SERVICE SET NAME = 'Dakwerken / Toiture' WHERE MFC_SERVICE_ID = 13030;
  71. UPDATE MFC_SERVICE SET NAME = 'Buitenschrijnwerk / Menuiserie extérieure' WHERE MFC_SERVICE_ID = 13031;
  72. UPDATE MFC_SERVICE SET NAME = 'Borstwering, buitentrappen en leuningen / Escaliers, terrasses & gardecorps ' WHERE MFC_SERVICE_ID = 13032;
  73. UPDATE MFC_SERVICE SET NAME = 'Elektriciteit en brandmelding / Installation électrique et  Lutte contre l'incendie' WHERE MFC_SERVICE_ID = 13033;
  74. UPDATE MFC_SERVICE SET NAME = 'Sanitair / Sanitaire' WHERE MFC_SERVICE_ID = 13034;
  75. UPDATE MFC_SERVICE SET NAME = 'Centrale verwarming en ventilatie / Chauffage et ventilation' WHERE MFC_SERVICE_ID = 13035;
  76. UPDATE MFC_SERVICE SET NAME = 'Lift / Ascenseur' WHERE MFC_SERVICE_ID = 13036;
  77. UPDATE MFC_SERVICE SET NAME = 'Vloerafwerking / Revêtement de sol' WHERE MFC_SERVICE_ID = 13037;
  78. UPDATE MFC_SERVICE SET NAME = 'Binnenschrijnwerk / Menuiserie intérieures' WHERE MFC_SERVICE_ID = 13038;
  79. UPDATE MFC_SERVICE SET NAME = 'Binnenafwerking / Finition intérieure' WHERE MFC_SERVICE_ID = 13039;
  80. UPDATE MFC_SERVICE SET NAME = 'Keukens en badkamers / Cuisines et salles de bain' WHERE MFC_SERVICE_ID = 13040;
  81. UPDATE MFC_SERVICE SET NAME = 'Schilderwerken / Peintures' WHERE MFC_SERVICE_ID = 13041;
  82. UPDATE MFC_SERVICE SET NAME = 'Omgevingswerken / Amènagement abords' WHERE MFC_SERVICE_ID = 13042;
  83. UPDATE MFC_SERVICE SET NAME = 'Naservice / Service après vente' WHERE MFC_SERVICE_ID = 13043;
  84. UPDATE MFC_SERVICE SET NAME = 'Naservice / Service après vente' WHERE MFC_SERVICE_ID = 13561;
  85. SET define ON
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement