Serialize XML and save in Oracle with C # and ADO

Question

Navigation

#1 by (1 votes)

3

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);

c# oracle xml ado.net xpath

asked by anonymous 02.04.2014 / 05:03

1 answer

score 1 · Accepted Answer

For the first, yes. It does not matter, actually.

select NickName, ExternalId1 
from Basics 
where externalId1 = @externalId1 
for xml auto, elements;

As for the second, SQL Server accepts XPath , but I believe that in order to work, @xml needs to be populated with a query before.