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.
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.