Available in versions: Dev (3.19) | Latest (3.18) | 3.17 | 3.16 | 3.15

This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.

XMLSERIALIZE

Applies to ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

The XMLSERIALIZE() function allows for serializing XML content into a string type

SELECT xmlserialize(CONTENT xmlelement(NAME 'a') AS VARCHAR)
FROM dual
create.select(xmlserializeContent(xmlelement("a"), VARCHAR))
      .fetch();

The result would look like this:

+--------------+
| xmlserialize |
+--------------+
| <a/>         |
+--------------+

Dialect support

This example using jOOQ:

xmlserializeContent(xmlelement("a"), VARCHAR(1000))

Translates to the following dialect specific expressions:

-- DB2, POSTGRES, TERADATA
xmlserialize(CONTENT xmlelement(NAME a) AS varchar(1000))

-- ORACLE
xmlserialize(CONTENT xmlelement(NAME a) AS varchar2(1000))

-- ACCESS, ASE, AURORA_MYSQL, AURORA_POSTGRES, BIGQUERY, COCKROACHDB, DERBY, DUCKDB, EXASOL, FIREBIRD, H2, HANA, HSQLDB, 
-- INFORMIX, MARIADB, MEMSQL, MYSQL, REDSHIFT, SNOWFLAKE, SQLDATAWAREHOUSE, SQLITE, SQLSERVER, SYBASE, TRINO, VERTICA, 
-- YUGABYTEDB
/* UNSUPPORTED */

(These are currently generated with jOOQ 3.19, see #10141), or translate your own on our website

Feedback

Do you have any feedback about this page? We'd love to hear it!

The jOOQ Logo