View parse error (listagg, chr(13)) — oracle-tech

    Forum Stats

  • 3,715,827 Users
  • 2,242,889 Discussions
  • 7,845,623 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

View parse error (listagg, chr(13))

I use listagg with delimeters: cr lf

example: listagg(abi.descr, chr(13) || chr(10))within group(order by abi.item_id)

And I get error: There is not possible parse follow up at the token "group". If I change chr(13) || chr(10) to some string like ';' then all is ok.

Answers

Sign In or Register to comment.