Advertisement
Guest User

Untitled

a guest
Apr 26th, 2018
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. (
  2. select xmlelement("agencias",
  3. xmlattributes('array' as "type"),
  4. xmlagg(
  5. xmlelement("arrayItem",
  6. xmlattributes('number' as "type"), numbertojson(ua.agencia_id))
  7. )
  8. )
  9. from (
  10. select *
  11. from sinergia.v$agencia_usuario ar
  12. where ar.excluido = 0
  13. ) ua
  14. where ua.usuario_id = u.usuario_id
  15. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement