Advertisement
Guest User

Untitled

a guest
Dec 16th, 2019
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE OR REPLACE FORCE VIEW "CUBA"."WORK_DAYS_2019" ("TYPE", "DATE_", "YEAR_") AS
  2.   SELECT '0' TYPE, TO_DATE('01.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  3. SELECT '0' TYPE, TO_DATE('02.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  4. SELECT '0' TYPE, TO_DATE('03.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  5. SELECT '0' TYPE, TO_DATE('04.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  6. SELECT '0' TYPE, TO_DATE('05.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  7. SELECT '0' TYPE, TO_DATE('06.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  8. SELECT '0' TYPE, TO_DATE('07.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  9. SELECT '0' TYPE, TO_DATE('08.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  10. SELECT '1' TYPE, TO_DATE('09.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  11. SELECT '1' TYPE, TO_DATE('10.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  12. SELECT '1' TYPE, TO_DATE('11.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  13. SELECT '0' TYPE, TO_DATE('12.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  14. SELECT '0' TYPE, TO_DATE('13.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  15. SELECT '1' TYPE, TO_DATE('14.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  16. SELECT '1' TYPE, TO_DATE('15.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  17. SELECT '1' TYPE, TO_DATE('16.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  18. SELECT '1' TYPE, TO_DATE('17.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  19. SELECT '1' TYPE, TO_DATE('18.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  20. SELECT '0' TYPE, TO_DATE('19.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  21. SELECT '0' TYPE, TO_DATE('20.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  22. SELECT '1' TYPE, TO_DATE('21.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  23. SELECT '1' TYPE, TO_DATE('22.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  24. SELECT '1' TYPE, TO_DATE('23.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  25. SELECT '1' TYPE, TO_DATE('24.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  26. SELECT '1' TYPE, TO_DATE('25.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  27. SELECT '0' TYPE, TO_DATE('26.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  28. SELECT '0' TYPE, TO_DATE('27.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  29. SELECT '1' TYPE, TO_DATE('28.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  30. SELECT '1' TYPE, TO_DATE('29.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  31. SELECT '1' TYPE, TO_DATE('30.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  32. SELECT '1' TYPE, TO_DATE('31.01.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  33.  
  34. SELECT '1' TYPE, TO_DATE('01.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  35. SELECT '0' TYPE, TO_DATE('02.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  36. SELECT '0' TYPE, TO_DATE('03.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  37. SELECT '1' TYPE, TO_DATE('04.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  38. SELECT '1' TYPE, TO_DATE('05.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  39. SELECT '1' TYPE, TO_DATE('06.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  40. SELECT '1' TYPE, TO_DATE('07.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  41. SELECT '1' TYPE, TO_DATE('08.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  42. SELECT '0' TYPE, TO_DATE('09.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  43. SELECT '0' TYPE, TO_DATE('10.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  44. SELECT '1' TYPE, TO_DATE('11.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  45. SELECT '1' TYPE, TO_DATE('12.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  46. SELECT '1' TYPE, TO_DATE('13.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  47. SELECT '1' TYPE, TO_DATE('14.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  48. SELECT '1' TYPE, TO_DATE('15.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  49. SELECT '0' TYPE, TO_DATE('16.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  50. SELECT '0' TYPE, TO_DATE('17.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  51. SELECT '1' TYPE, TO_DATE('18.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  52. SELECT '1' TYPE, TO_DATE('19.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  53. SELECT '1' TYPE, TO_DATE('20.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  54. SELECT '1' TYPE, TO_DATE('21.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  55. SELECT '1' TYPE, TO_DATE('22.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  56. SELECT '0' TYPE, TO_DATE('23.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  57. SELECT '0' TYPE, TO_DATE('24.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  58. SELECT '1' TYPE, TO_DATE('25.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  59. SELECT '1' TYPE, TO_DATE('26.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  60. SELECT '1' TYPE, TO_DATE('27.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  61. SELECT '1' TYPE, TO_DATE('28.02.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  62.  
  63. SELECT '1' TYPE, TO_DATE('01.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  64. SELECT '0' TYPE, TO_DATE('02.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  65. SELECT '0' TYPE, TO_DATE('03.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  66. SELECT '1' TYPE, TO_DATE('04.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  67. SELECT '1' TYPE, TO_DATE('05.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  68. SELECT '1' TYPE, TO_DATE('06.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  69. SELECT '1' TYPE, TO_DATE('07.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  70. SELECT '0' TYPE, TO_DATE('08.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  71. SELECT '0' TYPE, TO_DATE('09.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  72. SELECT '0' TYPE, TO_DATE('10.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  73. SELECT '1' TYPE, TO_DATE('11.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  74. SELECT '1' TYPE, TO_DATE('12.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  75. SELECT '1' TYPE, TO_DATE('13.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  76. SELECT '1' TYPE, TO_DATE('14.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  77. SELECT '1' TYPE, TO_DATE('15.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  78. SELECT '0' TYPE, TO_DATE('16.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  79. SELECT '0' TYPE, TO_DATE('17.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  80. SELECT '1' TYPE, TO_DATE('18.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  81. SELECT '1' TYPE, TO_DATE('19.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  82. SELECT '1' TYPE, TO_DATE('20.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  83. SELECT '1' TYPE, TO_DATE('21.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  84. SELECT '1' TYPE, TO_DATE('22.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  85. SELECT '0' TYPE, TO_DATE('23.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  86. SELECT '0' TYPE, TO_DATE('24.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  87. SELECT '1' TYPE, TO_DATE('25.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  88. SELECT '1' TYPE, TO_DATE('26.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  89. SELECT '1' TYPE, TO_DATE('27.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  90. SELECT '1' TYPE, TO_DATE('28.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  91. SELECT '1' TYPE, TO_DATE('29.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  92. SELECT '0' TYPE, TO_DATE('30.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  93. SELECT '0' TYPE, TO_DATE('31.03.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  94.  
  95. SELECT '1' TYPE, TO_DATE('01.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  96. SELECT '1' TYPE, TO_DATE('02.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  97. SELECT '1' TYPE, TO_DATE('03.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  98. SELECT '1' TYPE, TO_DATE('04.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  99. SELECT '1' TYPE, TO_DATE('05.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  100. SELECT '0' TYPE, TO_DATE('06.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  101. SELECT '0' TYPE, TO_DATE('07.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  102. SELECT '1' TYPE, TO_DATE('08.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  103. SELECT '1' TYPE, TO_DATE('09.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  104. SELECT '1' TYPE, TO_DATE('10.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  105. SELECT '1' TYPE, TO_DATE('11.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  106. SELECT '1' TYPE, TO_DATE('12.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  107. SELECT '0' TYPE, TO_DATE('13.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  108. SELECT '0' TYPE, TO_DATE('14.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  109. SELECT '1' TYPE, TO_DATE('15.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  110. SELECT '1' TYPE, TO_DATE('16.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  111. SELECT '1' TYPE, TO_DATE('17.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  112. SELECT '1' TYPE, TO_DATE('18.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  113. SELECT '1' TYPE, TO_DATE('19.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  114. SELECT '0' TYPE, TO_DATE('20.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  115. SELECT '0' TYPE, TO_DATE('21.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  116. SELECT '1' TYPE, TO_DATE('22.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  117. SELECT '1' TYPE, TO_DATE('23.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  118. SELECT '1' TYPE, TO_DATE('24.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  119. SELECT '1' TYPE, TO_DATE('25.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  120. SELECT '1' TYPE, TO_DATE('26.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  121. SELECT '0' TYPE, TO_DATE('27.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  122. SELECT '0' TYPE, TO_DATE('28.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  123. SELECT '1' TYPE, TO_DATE('29.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  124. SELECT '1' TYPE, TO_DATE('30.04.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  125.  
  126. SELECT '0' TYPE, TO_DATE('01.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  127. SELECT '0' TYPE, TO_DATE('02.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  128. SELECT '0' TYPE, TO_DATE('03.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  129. SELECT '0' TYPE, TO_DATE('04.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  130. SELECT '0' TYPE, TO_DATE('05.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  131. SELECT '1' TYPE, TO_DATE('06.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  132. SELECT '1' TYPE, TO_DATE('07.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  133. SELECT '1' TYPE, TO_DATE('08.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  134. SELECT '0' TYPE, TO_DATE('09.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  135. SELECT '0' TYPE, TO_DATE('10.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  136. SELECT '0' TYPE, TO_DATE('11.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  137. SELECT '0' TYPE, TO_DATE('12.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  138. SELECT '1' TYPE, TO_DATE('13.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  139. SELECT '1' TYPE, TO_DATE('14.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  140. SELECT '1' TYPE, TO_DATE('15.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  141. SELECT '1' TYPE, TO_DATE('16.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  142. SELECT '1' TYPE, TO_DATE('17.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  143. SELECT '0' TYPE, TO_DATE('18.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  144. SELECT '0' TYPE, TO_DATE('19.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  145. SELECT '1' TYPE, TO_DATE('20.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  146. SELECT '1' TYPE, TO_DATE('21.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  147. SELECT '1' TYPE, TO_DATE('22.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  148. SELECT '1' TYPE, TO_DATE('23.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  149. SELECT '1' TYPE, TO_DATE('24.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  150. SELECT '0' TYPE, TO_DATE('25.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  151. SELECT '0' TYPE, TO_DATE('26.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  152. SELECT '1' TYPE, TO_DATE('27.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  153. SELECT '1' TYPE, TO_DATE('28.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  154. SELECT '1' TYPE, TO_DATE('29.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  155. SELECT '1' TYPE, TO_DATE('30.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  156. SELECT '1' TYPE, TO_DATE('31.05.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  157.  
  158. SELECT '0' TYPE, TO_DATE('01.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  159. SELECT '0' TYPE, TO_DATE('02.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  160. SELECT '1' TYPE, TO_DATE('03.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  161. SELECT '1' TYPE, TO_DATE('04.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  162. SELECT '1' TYPE, TO_DATE('05.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  163. SELECT '1' TYPE, TO_DATE('06.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  164. SELECT '1' TYPE, TO_DATE('07.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  165. SELECT '0' TYPE, TO_DATE('08.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  166. SELECT '0' TYPE, TO_DATE('09.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  167. SELECT '1' TYPE, TO_DATE('10.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  168. SELECT '1' TYPE, TO_DATE('11.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  169. SELECT '0' TYPE, TO_DATE('12.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  170. SELECT '1' TYPE, TO_DATE('13.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  171. SELECT '1' TYPE, TO_DATE('14.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  172. SELECT '0' TYPE, TO_DATE('15.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  173. SELECT '0' TYPE, TO_DATE('16.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  174. SELECT '1' TYPE, TO_DATE('17.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  175. SELECT '1' TYPE, TO_DATE('18.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  176. SELECT '1' TYPE, TO_DATE('19.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  177. SELECT '1' TYPE, TO_DATE('20.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  178. SELECT '1' TYPE, TO_DATE('21.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  179. SELECT '0' TYPE, TO_DATE('22.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  180. SELECT '0' TYPE, TO_DATE('23.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  181. SELECT '1' TYPE, TO_DATE('24.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  182. SELECT '1' TYPE, TO_DATE('25.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  183. SELECT '1' TYPE, TO_DATE('26.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  184. SELECT '1' TYPE, TO_DATE('27.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  185. SELECT '1' TYPE, TO_DATE('28.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  186. SELECT '0' TYPE, TO_DATE('29.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  187. SELECT '0' TYPE, TO_DATE('30.06.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  188.  
  189. SELECT '1' TYPE, TO_DATE('01.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  190. SELECT '1' TYPE, TO_DATE('02.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  191. SELECT '1' TYPE, TO_DATE('03.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  192. SELECT '1' TYPE, TO_DATE('04.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  193. SELECT '1' TYPE, TO_DATE('05.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  194. SELECT '0' TYPE, TO_DATE('06.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  195. SELECT '0' TYPE, TO_DATE('07.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  196. SELECT '1' TYPE, TO_DATE('08.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  197. SELECT '1' TYPE, TO_DATE('09.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  198. SELECT '1' TYPE, TO_DATE('10.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  199. SELECT '1' TYPE, TO_DATE('11.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  200. SELECT '1' TYPE, TO_DATE('12.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  201. SELECT '0' TYPE, TO_DATE('13.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  202. SELECT '0' TYPE, TO_DATE('14.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  203. SELECT '1' TYPE, TO_DATE('15.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  204. SELECT '1' TYPE, TO_DATE('16.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  205. SELECT '1' TYPE, TO_DATE('17.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  206. SELECT '1' TYPE, TO_DATE('18.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  207. SELECT '1' TYPE, TO_DATE('19.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  208. SELECT '0' TYPE, TO_DATE('20.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  209. SELECT '0' TYPE, TO_DATE('21.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  210. SELECT '1' TYPE, TO_DATE('22.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  211. SELECT '1' TYPE, TO_DATE('23.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  212. SELECT '1' TYPE, TO_DATE('24.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  213. SELECT '1' TYPE, TO_DATE('25.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  214. SELECT '1' TYPE, TO_DATE('26.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  215. SELECT '0' TYPE, TO_DATE('27.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  216. SELECT '0' TYPE, TO_DATE('28.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  217. SELECT '1' TYPE, TO_DATE('29.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  218. SELECT '1' TYPE, TO_DATE('30.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  219. SELECT '1' TYPE, TO_DATE('31.07.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  220.  
  221. SELECT '1' TYPE, TO_DATE('01.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  222. SELECT '1' TYPE, TO_DATE('02.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  223. SELECT '0' TYPE, TO_DATE('03.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  224. SELECT '0' TYPE, TO_DATE('04.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  225. SELECT '1' TYPE, TO_DATE('05.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  226. SELECT '1' TYPE, TO_DATE('06.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  227. SELECT '1' TYPE, TO_DATE('07.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  228. SELECT '1' TYPE, TO_DATE('08.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  229. SELECT '1' TYPE, TO_DATE('09.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  230. SELECT '0' TYPE, TO_DATE('10.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  231. SELECT '0' TYPE, TO_DATE('11.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  232. SELECT '1' TYPE, TO_DATE('12.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  233. SELECT '1' TYPE, TO_DATE('13.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  234. SELECT '1' TYPE, TO_DATE('14.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  235. SELECT '1' TYPE, TO_DATE('15.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  236. SELECT '1' TYPE, TO_DATE('16.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  237. SELECT '0' TYPE, TO_DATE('17.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  238. SELECT '0' TYPE, TO_DATE('18.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  239. SELECT '1' TYPE, TO_DATE('19.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  240. SELECT '1' TYPE, TO_DATE('20.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  241. SELECT '1' TYPE, TO_DATE('21.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  242. SELECT '1' TYPE, TO_DATE('22.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  243. SELECT '1' TYPE, TO_DATE('23.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  244. SELECT '0' TYPE, TO_DATE('24.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  245. SELECT '0' TYPE, TO_DATE('25.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  246. SELECT '1' TYPE, TO_DATE('26.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  247. SELECT '1' TYPE, TO_DATE('27.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  248. SELECT '1' TYPE, TO_DATE('28.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  249. SELECT '1' TYPE, TO_DATE('29.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  250. SELECT '1' TYPE, TO_DATE('30.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  251. SELECT '0' TYPE, TO_DATE('31.08.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  252.  
  253. SELECT '0' TYPE, TO_DATE('01.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  254. SELECT '1' TYPE, TO_DATE('02.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  255. SELECT '1' TYPE, TO_DATE('03.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  256. SELECT '1' TYPE, TO_DATE('04.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  257. SELECT '1' TYPE, TO_DATE('05.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  258. SELECT '1' TYPE, TO_DATE('06.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  259. SELECT '0' TYPE, TO_DATE('07.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  260. SELECT '0' TYPE, TO_DATE('08.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  261. SELECT '1' TYPE, TO_DATE('09.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  262. SELECT '1' TYPE, TO_DATE('10.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  263. SELECT '1' TYPE, TO_DATE('11.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  264. SELECT '1' TYPE, TO_DATE('12.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  265. SELECT '1' TYPE, TO_DATE('13.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  266. SELECT '0' TYPE, TO_DATE('14.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  267. SELECT '0' TYPE, TO_DATE('15.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  268. SELECT '1' TYPE, TO_DATE('16.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  269. SELECT '1' TYPE, TO_DATE('17.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  270. SELECT '1' TYPE, TO_DATE('18.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  271. SELECT '1' TYPE, TO_DATE('19.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  272. SELECT '1' TYPE, TO_DATE('20.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  273. SELECT '0' TYPE, TO_DATE('21.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  274. SELECT '0' TYPE, TO_DATE('22.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  275. SELECT '1' TYPE, TO_DATE('23.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  276. SELECT '1' TYPE, TO_DATE('24.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  277. SELECT '1' TYPE, TO_DATE('25.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  278. SELECT '1' TYPE, TO_DATE('26.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  279. SELECT '1' TYPE, TO_DATE('27.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  280. SELECT '0' TYPE, TO_DATE('28.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  281. SELECT '0' TYPE, TO_DATE('29.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  282. SELECT '1' TYPE, TO_DATE('30.09.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  283.  
  284. SELECT '1' TYPE, TO_DATE('01.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  285. SELECT '1' TYPE, TO_DATE('02.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  286. SELECT '1' TYPE, TO_DATE('03.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  287. SELECT '1' TYPE, TO_DATE('04.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  288. SELECT '0' TYPE, TO_DATE('05.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  289. SELECT '0' TYPE, TO_DATE('06.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  290. SELECT '1' TYPE, TO_DATE('07.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  291. SELECT '1' TYPE, TO_DATE('08.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  292. SELECT '1' TYPE, TO_DATE('09.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  293. SELECT '1' TYPE, TO_DATE('10.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  294. SELECT '1' TYPE, TO_DATE('11.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  295. SELECT '0' TYPE, TO_DATE('12.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  296. SELECT '0' TYPE, TO_DATE('13.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  297. SELECT '1' TYPE, TO_DATE('14.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  298. SELECT '1' TYPE, TO_DATE('15.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  299. SELECT '1' TYPE, TO_DATE('16.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  300. SELECT '1' TYPE, TO_DATE('17.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  301. SELECT '1' TYPE, TO_DATE('18.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  302. SELECT '0' TYPE, TO_DATE('19.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  303. SELECT '0' TYPE, TO_DATE('20.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  304. SELECT '1' TYPE, TO_DATE('21.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  305. SELECT '1' TYPE, TO_DATE('22.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  306. SELECT '1' TYPE, TO_DATE('23.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  307. SELECT '1' TYPE, TO_DATE('24.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  308. SELECT '1' TYPE, TO_DATE('25.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  309. SELECT '0' TYPE, TO_DATE('26.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  310. SELECT '0' TYPE, TO_DATE('27.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  311. SELECT '1' TYPE, TO_DATE('28.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  312. SELECT '1' TYPE, TO_DATE('29.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  313. SELECT '1' TYPE, TO_DATE('30.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  314. SELECT '1' TYPE, TO_DATE('31.10.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  315.  
  316. SELECT '1' TYPE, TO_DATE('01.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  317. SELECT '0' TYPE, TO_DATE('02.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  318. SELECT '0' TYPE, TO_DATE('03.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  319. SELECT '0' TYPE, TO_DATE('04.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  320. SELECT '1' TYPE, TO_DATE('05.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  321. SELECT '1' TYPE, TO_DATE('06.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  322. SELECT '1' TYPE, TO_DATE('07.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  323. SELECT '1' TYPE, TO_DATE('08.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  324. SELECT '0' TYPE, TO_DATE('09.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  325. SELECT '0' TYPE, TO_DATE('10.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  326. SELECT '1' TYPE, TO_DATE('11.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  327. SELECT '1' TYPE, TO_DATE('12.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  328. SELECT '1' TYPE, TO_DATE('13.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  329. SELECT '1' TYPE, TO_DATE('14.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  330. SELECT '1' TYPE, TO_DATE('15.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  331. SELECT '0' TYPE, TO_DATE('16.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  332. SELECT '0' TYPE, TO_DATE('17.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  333. SELECT '1' TYPE, TO_DATE('18.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  334. SELECT '1' TYPE, TO_DATE('19.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  335. SELECT '1' TYPE, TO_DATE('20.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  336. SELECT '1' TYPE, TO_DATE('21.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  337. SELECT '1' TYPE, TO_DATE('22.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  338. SELECT '0' TYPE, TO_DATE('23.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  339. SELECT '0' TYPE, TO_DATE('24.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  340. SELECT '1' TYPE, TO_DATE('25.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  341. SELECT '1' TYPE, TO_DATE('26.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  342. SELECT '1' TYPE, TO_DATE('27.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  343. SELECT '1' TYPE, TO_DATE('28.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  344. SELECT '1' TYPE, TO_DATE('29.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  345. SELECT '0' TYPE, TO_DATE('30.11.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  346.  
  347. SELECT '0' TYPE, TO_DATE('01.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  348. SELECT '1' TYPE, TO_DATE('02.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  349. SELECT '1' TYPE, TO_DATE('03.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  350. SELECT '1' TYPE, TO_DATE('04.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  351. SELECT '1' TYPE, TO_DATE('05.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  352. SELECT '1' TYPE, TO_DATE('06.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  353. SELECT '0' TYPE, TO_DATE('07.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  354. SELECT '0' TYPE, TO_DATE('08.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  355. SELECT '1' TYPE, TO_DATE('09.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  356. SELECT '1' TYPE, TO_DATE('10.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  357. SELECT '1' TYPE, TO_DATE('11.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  358. SELECT '1' TYPE, TO_DATE('12.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  359. SELECT '1' TYPE, TO_DATE('13.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  360. SELECT '0' TYPE, TO_DATE('14.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  361. SELECT '0' TYPE, TO_DATE('15.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  362. SELECT '1' TYPE, TO_DATE('16.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  363. SELECT '1' TYPE, TO_DATE('17.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  364. SELECT '1' TYPE, TO_DATE('18.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  365. SELECT '1' TYPE, TO_DATE('19.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  366. SELECT '1' TYPE, TO_DATE('20.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  367. SELECT '0' TYPE, TO_DATE('21.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  368. SELECT '0' TYPE, TO_DATE('22.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  369. SELECT '1' TYPE, TO_DATE('23.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  370. SELECT '1' TYPE, TO_DATE('24.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  371. SELECT '1' TYPE, TO_DATE('25.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  372. SELECT '1' TYPE, TO_DATE('26.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  373. SELECT '1' TYPE, TO_DATE('27.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  374. SELECT '0' TYPE, TO_DATE('28.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  375. SELECT '0' TYPE, TO_DATE('29.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  376. SELECT '1' TYPE, TO_DATE('30.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual UNION ALL
  377. SELECT '1' TYPE, TO_DATE('31.12.2019','DD.MM.YYYY') date_, '2019' year_  FROM dual;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement