a apiary.
← All tools

SQL / BROWSER UTILITY

SQL to XML Builder

Use an XML template to generate a query that populates elements from table columns.

Processed locally in your browser. Your data is not uploaded.

Want to recreate a local XML document with all its existing values? Use XML to SQL Script. This builder populates XML from database table columns.

1. Discover the XML structure

UTF-8 files up to 1 MB. Up to 250,000 characters, 20,000 elements, 40,000 total nodes and 200 distinct element and attribute paths.

Good to know

Use XML as a structural template for an Oracle, SQL Server or PostgreSQL query. One table supplies the chosen record level. Map leaf elements and attributes to column names, preserve the first sample value, leave empty or omit. XML functions escape values when the query runs. NULL columns produce empty elements and omit attributes; Oracle also treats empty text as NULL. Nested collections, joins and mixed text with child elements need a separately authored query. Whitespace, comments and processing instructions are not reproduced. The tool does not connect to or execute against your database.

Example: Load a records XML template, choose /records/record, enter your records table and map code and name to its columns. The generated SQL constructs XML from the table rows.