Updating xml c

Each successive update works on the result of the previous one. For object-relational storage, if particular conditions are met, then the function call can be rewritten to update the object-relational columns directly with the values.

OBJECT_VALUE AS "p"); NAME LINEITEMS ---------------- ------------------------------------------------------------------ Stephen G.

King', '/Purchase Order/Line Items/Line Item/Part[@Id="715515009058"]/@Quantity', 25, '/Purchase Order/Line Items/Line Item[Description/text() = "The Unbearable Lightness Of Being"]', XMLType('')) WHERE XMLExists('$p/Purchase Order[Reference="SBELL-2002100912333601PDT"]' PASSING OBJECT_VALUE AS "p"); SELECT XMLCast(XMLQuery('$p/Purchase Order/Requestor' PASSING po.

OBJECT_VALUE AS "p"); NAME LINEITEMS ---------------- ------------------------------------------------------------- Stephen G.

OBJECT_VALUE AS "p"); PART ---- ) WHERE XMLExists('$p/Purchase Order[@Reference="SBELL-2003030912333601PDT"]' PASSING OBJECT_VALUE AS "p"); SELECT XMLCast(XMLQuery('$p/Purchase Order/Line Items/Line Item/Part[@Description="A Night to Remember"]' PASSING po.

OBJECT_VALUE AS "p" RETURNING CONTENT) AS VARCHAR2(128)) part FROM purchaseorder po WHERE XMLExists('$p/Purchase Order[@Reference="SBELL-2003030912333601PDT"]' PASSING po. The order of updates is determined by the order of the XPath expressions, in left-to-right order.

Leave a Reply