Term: XMLSEQUENCE

Definition:
In Oracle PL/SQL, the built-in XMLSEQUENCE function takes XML type instances as input and returns its equivalent XMLSequenceType value. XMLSequenceType value is nothing but a collection of XMLType instances.

Example Syntax:

XMLSEQUENCE ([XMLType instance | SYS_REFCURSOR instance])

In the syntax, note that it can accept either an XML Type instance or a ref cursor instance.

Example Usage

Case 1: The SQL below uses fixed values (type casted as XML type instance) as input to the XMLSEQUENCE function.

SELECT value(T).getstringval() Attribute_Value

FROM table(

	   XMLSequence(

       EXTRACT(

        XMLType('<Node><ValueNode>Oracle</ValueNode>

		<ValueNode>SQL</ValueNode>

		<ValueNode>PLSQL</ValueNode></Node>'),

        '/Node/ValueNode'

                                      )

                           )

      ) T





ATTRIBUTE_VALUE

-------------------------------------------

<ValueNode>Oracle</ValueNode>

<ValueNode>SQL</ValueNode>

<ValueNode>PLSQL</ValueNode>

Case 2: The SQL below uses a cursor sub query as input to XMLSequence function.

SELECT VALUE(em).getCLOBVal() 

	AS "XMLTYPE"

	FROM table(XMLSequence(Cursor(SELECT * FROM CUST_SALES

             	         WHERE CUSTOMER_ID='Franklin'

                     	         AND MONTH='Jul'))) em

/



XMLTYPE

--------------------------------------

 <ROW>

  <CUSTOMER_ID>Franklin</CUSTOMER_ID>

  <MONTH>Jul</MONTH>

  <PRODUCT_ID>Prod Q5</PRODUCT_ID>

  <SALES>Prod Q5</SALES>

 <ROW>