Re: Extra nesting using DBMS_XMLGEN.getxml and Cursor expression <xmltag_ROW>
From: Michael Moore <michaeljmoore_at_gmail.com>
Date: Mon, 12 Dec 2011 17:33:31 -0800
Message-ID: <CACpWLjPE3j9hqe5UqCXpa36e3UEchOQYDkmzV_DLQyBY5u86Sg_at_mail.gmail.com>
Try this, it should answer your question. SELECT DBMS_XMLGEN.getxml (
>
>
Date: Mon, 12 Dec 2011 17:33:31 -0800
Message-ID: <CACpWLjPE3j9hqe5UqCXpa36e3UEchOQYDkmzV_DLQyBY5u86Sg_at_mail.gmail.com>
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;
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Dec 12 2011 - 19:33:31 CST