API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 20th, 2017
64
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.98 KB | None | 0 0
raw download clone embed print report
  1. 11:39:05,498 INFO [stdout] (default task-68) select
  2. 11:39:05,498 INFO [stdout] (default task-68) 'Ambos' as col_0_0_,
  3. 11:39:05,498 INFO [stdout] (default task-68) medicoespl0_.ANO_PLUV as col_1_0_,
  4. 11:39:05,498 INFO [stdout] (default task-68) getTotalMensal(medicoespl0_.MES_PLUV,
  5. 11:39:05,498 INFO [stdout] (default task-68) create_array(medicoespl0_.VL_DIA1,
  6. 11:39:05,498 INFO [stdout] (default task-68) medicoespl0_.VL_DIA2,
  7. 11:39:05,498 INFO [stdout] (default task-68) medicoespl0_.VL_DIA3,
  8. 11:39:05,498 INFO [stdout] (default task-68) medicoespl0_.VL_DIA4,
  9. 11:39:05,498 INFO [stdout] (default task-68) medicoespl0_.VL_DIA5,
  10. 11:39:05,498 INFO [stdout] (default task-68) medicoespl0_.VL_DIA6,
  11. 11:39:05,498 INFO [stdout] (default task-68) medicoespl0_.VL_DIA7,
  12. 11:39:05,498 INFO [stdout] (default task-68) medicoespl0_.VL_DIA8,
  13. 11:39:05,498 INFO [stdout] (default task-68) medicoespl0_.VL_DIA9,
  14. 11:39:05,498 INFO [stdout] (default task-68) medicoespl0_.VL_DIA10,
  15. 11:39:05,498 INFO [stdout] (default task-68) medicoespl0_.VL_DIA11,
  16. 11:39:05,498 INFO [stdout] (default task-68) medicoespl0_.VL_DIA12,
  17. 11:39:05,498 INFO [stdout] (default task-68) medicoespl0_.VL_DIA13,
  18. 11:39:05,498 INFO [stdout] (default task-68) medicoespl0_.VL_DIA14,
  19. 11:39:05,498 INFO [stdout] (default task-68) medicoespl0_.VL_DIA15,
  20. 11:39:05,498 INFO [stdout] (default task-68) medicoespl0_.VL_DIA16,
  21. 11:39:05,499 INFO [stdout] (default task-68) medicoespl0_.VL_DIA17,
  22. 11:39:05,499 INFO [stdout] (default task-68) medicoespl0_.VL_DIA18,
  23. 11:39:05,499 INFO [stdout] (default task-68) medicoespl0_.VL_DIA19,
  24. 11:39:05,499 INFO [stdout] (default task-68) medicoespl0_.VL_DIA20,
  25. 11:39:05,499 INFO [stdout] (default task-68) medicoespl0_.VL_DIA21,
  26. 11:39:05,499 INFO [stdout] (default task-68) medicoespl0_.VL_DIA22,
  27. 11:39:05,499 INFO [stdout] (default task-68) medicoespl0_.VL_DIA23,
  28. 11:39:05,499 INFO [stdout] (default task-68) medicoespl0_.VL_DIA24,
  29. 11:39:05,499 INFO [stdout] (default task-68) medicoespl0_.VL_DIA25,
  30. 11:39:05,499 INFO [stdout] (default task-68) medicoespl0_.VL_DIA26,
  31. 11:39:05,499 INFO [stdout] (default task-68) medicoespl0_.VL_DIA27,
  32. 11:39:05,499 INFO [stdout] (default task-68) medicoespl0_.VL_DIA28,
  33. 11:39:05,499 INFO [stdout] (default task-68) medicoespl0_.VL_DIA29,
  34. 11:39:05,499 INFO [stdout] (default task-68) medicoespl0_.VL_DIA30,
  35. 11:39:05,499 INFO [stdout] (default task-68) medicoespl0_.VL_DIA31)) as col_2_0_,
  36. 11:39:05,499 INFO [stdout] (default task-68) municipio2_.ID_MUNC as col_3_0_,
  37. 11:39:05,499 INFO [stdout] (default task-68) municipio2_.NM_MUNC as col_4_0_
  38. 11:39:05,499 INFO [stdout] (default task-68) from
  39. 11:39:05,499 INFO [stdout] (default task-68) monitoramento.VW_MED_PLUV_PRIOR medicoespl0_
  40. 11:39:05,499 INFO [stdout] (default task-68) inner join
  41. 11:39:05,499 INFO [stdout] (default task-68) monitoramento.TB_PPLUV postopluvi1_
  42. 11:39:05,499 INFO [stdout] (default task-68) on medicoespl0_.ID_PPLUV=postopluvi1_.ID_PPLUV
  43. 11:39:05,499 INFO [stdout] (default task-68) left outer join
  44. 11:39:05,499 INFO [stdout] (default task-68) geral.TB_MUNC municipio2_
  45. 11:39:05,499 INFO [stdout] (default task-68) on postopluvi1_.ID_MUNC=municipio2_.ID_MUNC
  46. 11:39:05,499 INFO [stdout] (default task-68) where
  47. 11:39:05,500 INFO [stdout] (default task-68) 1=1
  48. 11:39:05,500 INFO [stdout] (default task-68) and (
  49. 11:39:05,500 INFO [stdout] (default task-68) medicoespl0_.MES_PLUV in (
  50. 11:39:05,500 INFO [stdout] (default task-68) ? , ? , ? , ? , ? , ? , ?
  51. 11:39:05,500 INFO [stdout] (default task-68) )
  52. 11:39:05,500 INFO [stdout] (default task-68) )
  53. 11:39:05,500 INFO [stdout] (default task-68) and (
  54. 11:39:05,500 INFO [stdout] (default task-68) municipio2_.ID_MUNC in (
  55. 11:39:05,500 INFO [stdout] (default task-68) ?
  56. 11:39:05,500 INFO [stdout] (default task-68) )
  57. 11:39:05,500 INFO [stdout] (default task-68) )
  58. 11:39:05,500 INFO [stdout] (default task-68) and (
  59. 11:39:05,500 INFO [stdout] (default task-68) to_date((medicoespl0_.MES_PLUV||'/'||medicoespl0_.ANO_PLUV), 'mm/yyyy') between ? and ?
  60. 11:39:05,500 INFO [stdout] (default task-68) )
  61. 11:39:05,500 INFO [stdout] (default task-68) group by
  62. 11:39:05,500 INFO [stdout] (default task-68) municipio2_.ID_MUNC ,
  63. 11:39:05,500 INFO [stdout] (default task-68) municipio2_.NM_MUNC ,
  64. 11:39:05,500 INFO [stdout] (default task-68) medicoespl0_.ANO_PLUV
  65. 11:39:05,500 INFO [stdout] (default task-68) order by
  66. 11:39:05,500 INFO [stdout] (default task-68) municipio2_.NM_MUNC ASC limit ?
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!