ELEMENTS指令

SELECT id, title
FROM book
ORDER BY id
FOR XML RAW, ELEMENTS
 

create.select(BOOK.ID, BOOK.TITLE)
      .from(BOOK)
      .orderBy(BOOK.ID)
      .forXML().raw().elements()
      .fetch();

<row><ID>1</ID><TITLE>1984</TITLE></row>
<row><ID>2</ID><TITLE>Animal Farm</TITLE></row>
<row><ID>3</ID><TITLE>O Alquimista</TITLE></row>
<row><ID>4</ID><TITLE>Brida</TITLE></row>

select(BOOK.ID).from(BOOK).orderBy(BOOK.ID).forXML().raw().elements()

SELECT xmlagg(xmlelement(
  NAME row,
  xmlelement(NAME ID, ID)
))
FROM (
  SELECT BOOK.ID
  FROM BOOK
  ORDER BY BOOK.ID
) t

SELECT (
  SELECT BOOK.ID
  FROM BOOK
  ORDER BY BOOK.ID
  FOR XML RAW, ELEMENTS
)

SELECT (
  SELECT BOOK.ID
  FROM BOOK
  ORDER BY BOOK.ID
  FOR XML RAW, ELEMENTS
)
FROM SYS.DUMMY

SELECT xmlagg(xmlelement(
  NAME row,
  xmlelement(NAME ID, ID)
))
FROM (
  SELECT *
  FROM (
    SELECT TOP 999999999999999999 BOOK.ID
    FROM BOOK
    ORDER BY BOOK.ID
  ) x
) t

/* UNSUPPORTED */

使用 jOOQ 3.21 生成。早期 jOOQ 版本的支持可能有所不同。 在我们的网站上翻译您自己的 SQL