このプロシージャを使用すると、指定したテーブルまたはビューをXML 表現に変換できます。

Parameters

Parameter

Description

tableName

Fully qualified table or view name which should be converted to XML; mandatory


Usage

CALL "UTILS.tableToXml"(
"tableName" => 'string_tableName'
);;

Example

この例では、サンプルビューを作成し、それをXML に変換します:

CREATE VIEW views.testView
AS
SELECT 1 AS "a", 2 AS "b", 9 AS "c"
UNION ALL
SELECT 5 AS "a", 7 AS "b", 10 AS "c"
UNION ALL
SELECT 9 AS "a", 8 AS "b", 20 AS "c";;
 
CALL "UTILS.tableToXml"(
"tableName" => 'views.testView'
);;

次のような結果が得られます:

<testView><row><a>1</a><b>2</b><c>9</c></row><row><a>5</a><b>7</b><c>10</c></row><row><a>9</a><b>8</b><c>20</c></row></testView>

Warning

This procedure needs a lot of memory. We recommend ensuring that your system has enough RAM available and not use it for huge tables.