このプロシージャを使用すると、指定したテーブルまたはビューをXML 表現に変換できます。
Parameters
Parameter | Description |
---|---|
| 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.