Oracle SQL XMLSERIALIZE syntax not supported

[xiongtx]

Oracle's XMLSERIALIZE differs from the parser's expectations in that it has a CONTENT keyword. The following example doesn't parse:

SELECT XMLSERIALIZE(CONTENT XMLTYPE('<Owner>Grandco</Owner>')) AS xmlserialize_doc
   FROM DUAL;

2. Unhandled net.sf.jsqlparser.JSQLParserException

1. Caused by net.sf.jsqlparser.parser.ParseException
   Encountered unexpected token: "XMLSERIALIZE" "XMLSERIALIZE" at line 1,
   column 8.
   
   Was expecting one of:
   
       "!"  "(" "*" "NOT" "STRAIGHT_JOIN"

[manticore-projects]

Greetings,

thank you for reporting, I will see what I can do about.

[wumpz]

Only a special expression of XMLSERIALIZE is supported at the moment

SELECT xmlserialize(xmlagg(xmltext(COMMENT_LINE) ORDER BY COMMENT_SEQUENCE) AS varchar (1024)) FROM mytable GROUP BY COMMENT_NUMBER

[wumpz]

JSqlParserCC.jjt line 4675