Question:
I would like to know if there is something equivalent in Oracle for this select
in SQL Server:
select NickName, ExternalId1 from Basics where externalId1 = @externalId1 for xml auto, elements;
And for this select
below:
select
x.n.value('OperationId[1]', 'int'),
x.n.value('Name[1]', 'varchar(50)'),
x.n.value('MaxTime[1]', 'float')
from @xml.nodes('/*[1]') x(n);
Answer:
For the first one, yes. It stays the same, actually.
select NickName, ExternalId1
from Basics
where externalId1 = @externalId1
for xml auto, elements;
As for the second one, SQL Server supports XPath
, but I believe that to work @xml
needs to be populated with a query first.