SQL> conn jyang/jyang@athena
Connected.
SQL> 
SQL> select * from XMLTAB1;

SYS_NC_ROWINFO$                                                                 
--------------------------------------------------------------------------------
<PurchaseOrder xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNames
paceSchemaLocation="http://www.oracle.com/xdb/po.xsd">                          
  <Reference>ADAMS-20011127121040988PST</Reference>                             
  <Actions>                                                                     
    <Action>                                                                    
      <User>SCOTT</User>                                                        
      <Date>2002-03-31</Date>                                                   
    </Action>                                                                   
  </Actions>                                                                    
  <Reject/>                                                                     
  <Requestor>Julie P. Adams</Requestor>                                         
  <User>ADAMS</User>                                                            
  <CostCenter>R20</CostCenter>                                                  
  <ShippingInstructions>                                                        
    <name>Julie P. Adams</name>                                                 
    <address>Redwood Shores, CA 94065</address>                                 
    <telephone>650 506 7300</telephone>                                         
  </ShippingInstructions>                                                       
  <SpecialInstructions>Ground</SpecialInstructions>                             
  <LineItems>                                                                   
    <LineItem ItemNumber="1">                                                   
      <Description>The Ruling Class</Description>                               
      <Part Id="715515012423" UnitPrice="39.95" Quantity="2"/>                  
    </LineItem>                                                                 
    <LineItem ItemNumber="2">                                                   
      <Description>Diabolique</Description>                                     
      <Part Id="037429135020" UnitPrice="29.95" Quantity="3"/>                  
    </LineItem>                                                                 
    <LineItem ItemNumber="3">                                                   
      <Description>8 1/2</Description>                                          
      <Part Id="037429135624" UnitPrice="39.95" Quantity="4"/>                  
    </LineItem>                                                                 
  </LineItems>                                                                  
</PurchaseOrder>                                                                
                                                                                

SQL> 
SQL> UPDATE XMLTAB1 t
  2      SET value(t) = updateXML(value(t),
  3                             '/PurchaseOrder/Reference/text()',
  4                             'MILLER-200203311200000000PST')
  5      WHERE existsNode(value(t),
  6         '/PurchaseOrder[Reference="ADAMS-20011127121040988PST"]') = 1;

1 row updated.

SQL> 
SQL> SELECT value(t)
  2     FROM XMLTAB1 t;

VALUE(T)                                                                        
--------------------------------------------------------------------------------
<PurchaseOrder xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNames
paceSchemaLocation="http://www.oracle.com/xdb/po.xsd">                          
  <Reference>MILLER-200203311200000000PST</Reference>                           
  <Actions>                                                                     
    <Action>                                                                    
      <User>SCOTT</User>                                                        
      <Date>2002-03-31</Date>                                                   
    </Action>                                                                   
  </Actions>                                                                    
  <Reject/>                                                                     
  <Requestor>Julie P. Adams</Requestor>                                         
  <User>ADAMS</User>                                                            
  <CostCenter>R20</CostCenter>                                                  
  <ShippingInstructions>                                                        
    <name>Julie P. Adams</name>                                                 
    <address>Redwood Shores, CA 94065</address>                                 
    <telephone>650 506 7300</telephone>                                         
  </ShippingInstructions>                                                       
  <SpecialInstructions>Ground</SpecialInstructions>                             
  <LineItems>                                                                   
    <LineItem ItemNumber="1">                                                   
      <Description>The Ruling Class</Description>                               
      <Part Id="715515012423" UnitPrice="39.95" Quantity="2"/>                  
    </LineItem>                                                                 
    <LineItem ItemNumber="2">                                                   
      <Description>Diabolique</Description>                                     
      <Part Id="037429135020" UnitPrice="29.95" Quantity="3"/>                  
    </LineItem>                                                                 
    <LineItem ItemNumber="3">                                                   
      <Description>8 1/2</Description>                                          
      <Part Id="037429135624" UnitPrice="39.95" Quantity="4"/>                  
    </LineItem>                                                                 
  </LineItems>                                                                  
</PurchaseOrder>                                                                
                                                                                

SQL> 
SQL> UPDATE XMLTAB1 t
  2    SET value(t) =
  3    updateXML(value(t),
  4              '/PurchaseOrder/LineItems/LineItem[2]',
  5              xmltype('<LineItem ItemNumber="4">
  6                         <Description>Andrei Rublev</Description>
  7                         <Part Id="715515009928" UnitPrice="39.95"
  8                               Quantity="2"/>
  9                       </LineItem>'
 10               )
 11    )
 12    WHERE existsNode(value(t),
 13          '/PurchaseOrder[Reference="MILLER-200203311200000000PST"]'
 14    ) = 1;

1 row updated.

SQL> 
SQL> SELECT value(t)
  2     FROM XMLTAB1 t;

VALUE(T)                                                                        
--------------------------------------------------------------------------------
<PurchaseOrder xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNames
paceSchemaLocation="http://www.oracle.com/xdb/po.xsd">                          
  <Reference>MILLER-200203311200000000PST</Reference>                           
  <Actions>                                                                     
    <Action>                                                                    
      <User>SCOTT</User>                                                        
      <Date>2002-03-31</Date>                                                   
    </Action>                                                                   
  </Actions>                                                                    
  <Reject/>                                                                     
  <Requestor>Julie P. Adams</Requestor>                                         
  <User>ADAMS</User>                                                            
  <CostCenter>R20</CostCenter>                                                  
  <ShippingInstructions>                                                        
    <name>Julie P. Adams</name>                                                 
    <address>Redwood Shores, CA 94065</address>                                 
    <telephone>650 506 7300</telephone>                                         
  </ShippingInstructions>                                                       
  <SpecialInstructions>Ground</SpecialInstructions>                             
  <LineItems>                                                                   
    <LineItem ItemNumber="1">                                                   
      <Description>The Ruling Class</Description>                               
      <Part Id="715515012423" UnitPrice="39.95" Quantity="2"/>                  
    </LineItem>                                                                 
    <LineItem ItemNumber="4">                                                   
      <Description>Andrei Rublev</Description>                                  
      <Part Id="715515009928" UnitPrice="39.95" Quantity="2"/>                  
    </LineItem>                                                                 
    <LineItem ItemNumber="3">                                                   
      <Description>8 1/2</Description>                                          
      <Part Id="037429135624" UnitPrice="39.95" Quantity="4"/>                  
    </LineItem>                                                                 
  </LineItems>                                                                  
</PurchaseOrder>                                                                
                                                                                

SQL> 
SQL> spool off