Jump to content
Fórum Script Brasil
  • 0

erro oracle select


thiagoaf19

Question

select * from notificacao nt, tipo tp, autuacao_endereco ae

where nt.noti_orgao = ae.av_orgao
and ae.av_autonumero = nt.noti_documento
and ae.av_tipo = tp.tipo_id

and nt.noti_dtinfr between to_date('2019', 'yyyy') and to_date('2022', 'yyyy')
and tp.tipo_id IN ('3')
and nt.noti_tipomov IN ('NOT')
group by to_char(nt.noti_dtinfr, 'yyyy') as ano, nt.noti_infrcod as Código da Inf, nt.noti_infrresumo as Descricao

Alguém sabe me informar o erro , não roda no oracle

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



  • Forum Statistics

    • Total Topics
      152.1k
    • Total Posts
      652k
×
×
  • Create New...