Functions and Procedures of DBMS_XMLGEN

set pages 0
set linesize 150
set long 9999999
set head off
--Without Loop-----
select dbms_xmlgen.getxml('select vendor_id,segment1,vendor_name from po_vendors where rownum<3') xml from dual

--With Loop-----
select dbms_xmlgen.getxml('select inventory_item_id,segment1,cursor(select ood.organization_id,ood.organization_code,ood.organization_name from org_organization_definitions ood where msi.organization_id=ood.organization_id) org_row from mtl_system_items_b msi where inventory_item_id=1 and rownum<11 rownum<3') xml from dual

CLOSECONTEXT Procedure	Closes the context and releases all resources
CONVERT Functions	Converts the XML into the escaped or unescaped XML equivalent
GETNUMROWSPROCESSED Function	Gets the number of SQL rows that were processed in the last call to GETXML Functions
GETXML Functions	Gets the XML document
GETXMLTYPE Functions	Gets the XML document and returns it as XMLType
NEWCONTEXT Functions	Creates a new context handle
RESTARTQUERY Procedure	Restarts the query to start fetching from the beginning
SETCONVERTSPECIALCHARS Procedure	Sets whether special characters such as $, which are non-XML characters, should be converted or not to their escaped representation
SETMAXROWS Procedure	Sets the maximum number of rows to be fetched each time
SETNULLHANDLING Procedure	Sets NULL handling options
SETROWSETTAG Procedure	Sets the name of the element enclosing the entire result
SETROWTAG Procedure	Sets the name of the element enclosing each row of the result
SETSKIPROWS Procedure	Sets the number of rows to skip every time before generating the XML.
USEITEMTAGSFORCOLL Procedure	Forces the use of the collection column name appended with the tag _ITEM for collection elements
USENULLATTRIBUTEINDICATOR Procedure	Specified weather to use an XML attribute to indicate NULLness, or to do it by omitting the inclusion of the particular entity in the XML document.