Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
jOOQ 3.14 introduced support for the
org.jooq.XML type, which are used to wrap string based XML documents in a type safe way. With this type, there are also a few standard XML functions that have been added to the API. This section describes scalar functions, but there are also conditions, aggregate functions, and table valued functions for XML usage.
Notice that XML is case sensitive in all dialects, but SQL identifiers may not be. jOOQ by default produces quoted identifiers (see the RenderQuotedNames Setting), which maintains the case you provide in Java.
- XMLATTRIBUTES (new)
- XMLCOMMENT (new)
- XMLCONCAT (new)
- XMLDOCUMENT (new)
- XMLELEMENT (new)
- XMLFOREST (new)
- XMLPARSE (new)
- XMLPI (new)
- XMLQUERY (new)
|The jOOQ User Manual : SQL building : Column expressions : XML functions||previous : next|