New versions: Dev (3.16) | Latest (3.15)

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, EXASOL, FIREBIRD, H2, HANA, HSQLDB, IGNITE, 
-- INFORMIX, MARIADB, MEMSQL, MYSQL, REDSHIFT, SNOWFLAKE, SQLDATAWAREHOUSE, SQLITE, SQLSERVER, SYBASE, VERTICA
/* UNSUPPORTED */

(These are currently generated with jOOQ 3.16, 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