Hello everyone,
I have a question, I googled it and also searched the forum and look the documentation but couldn't find a clear answer:
SELECT *
FROM XMLTABLE('/a/b'
PASSING xmltype('<a><b>1</b><b>3</b><b>5</b></a>')
COLUMNS
b varchar2(6) path '/b'
);
when you run the sql above, you will see the rows 1, 3 and 5 but is this order is guaranteed?
I have provider that allow me get data via web services. One of the web service takes an data array (some ID data) from me and returns a result that looks like above, there are more than same nodes and order of this nodes are important because web service returns the result in same order with array data that I sent . When I parse that xml result via XMLTABLE, is it guaranteed to fetch rows with same order in xml? I mean, by using sql above, could it be in order as: 5 - 1 - 3 or it will be always 1 - 3 - 5.
thanks.