Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-01 |
|
Functions, 173 of 177
XMLForest::=
XMLForest
converts each of its argument parameters to XML, and then returns an XML fragment that is the concatenation of these converted arguments.
value_expr
is a scalar expression, then you can omit the AS
clause, and Oracle uses the column name as the element name.value_expr
is an object type or collection, then the AS
clause is mandatory, and Oracle uses the specified c_alias
as the enclosing tag.value_expr
is null, then no element is created for that value_expr
.The following example creates an Emp
element for a subset of employees, with nested employee_id
, last_name
, and salary
elements as the contents of Emp
:
SELECT XMLELEMENT("Emp", XMLFOREST(e.employee_id, e.last_name, e.salary)) "Emp Element" FROM employees e WHERE employee_id = 204; Emp Element ---------------------------------------------------------------- <Emp> <EMPLOYEE_ID>204</EMPLOYEE_ID> <LAST_NAME>Baer</LAST_NAME> <SALARY>10000</SALARY> </Emp>
See Also:
the example for XMLCOLATTVAL to compare the output of these two functions |
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|