Re: Extra nesting using DBMS_XMLGEN.getxml and Cursor expression <xmltag_ROW>

From: Michael Moore <michaeljmoore@xxxxxxxxx>
To: cshapi@xxxxxxxxx
Date: Mon, 12 Dec 2011 17:33:31 -0800

Try this, it should answer your question.
SELECT DBMS_XMLGEN.getxml (
          'select cursor(select ''1'' "one", ''2''
"two", ''3'' "three" from dual union all select ''1'' "one", ''2''
"two", ''3'' "three" from dual ) "numbers" from dual')
  FROM DUAL;


>
>


--
//www.freelists.org/webpage/oracle-l

References:
- Extra nesting using DBMS_XMLGEN.getxml and Cursor expression <xmltag_ROW>
  - From: Joel Slowik
- Re: Extra nesting using DBMS_XMLGEN.getxml and Cursor expression <xmltag_ROW>
  - From: Gwen Shapira

Other related posts:

» Extra nesting using DBMS_XMLGEN.getxml and Cursor expression <xmltag_ROW>- Joel Slowik
» Re: Extra nesting using DBMS_XMLGEN.getxml and Cursor expression <xmltag_ROW>- Gwen Shapira
» Re: Extra nesting using DBMS_XMLGEN.getxml and Cursor expression <xmltag_ROW> - Michael Moore