My database in 11g G. i am trying to add one child not but it is not adding. Could you please suggest what i am doing wrong.
create table XMLTEST
(
col_xmltype XMLTYPE;
);
insert into xmltest (col_xmltype)
values (xmltype('<?xml version="1.0"?><?mso-application progid="Excel.Sheet"?><Workbook xsi:schemaLocation="urn:schemas-microsoft-com:office:spreadsheet excelsss.xsd" xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xdb="http://xmlns.oracle.com/xdb"><Styles><Style ss:ID="Default" ss:Name="Normal"><Alignment ss:Vertical="Bottom"/><Borders/><Font/><Interior/><NumberFormat/><Protection/></Style></Styles><Worksheet><Table/></Worksheet><Worksheet><Table/></Worksheet></Workbook>'))
Query
select APPENDCHILDXML (col_xmltype,
'/Workbook',
'Worksheet',
XMLTYPE(' <Worksheet>
<Table/>
</Worksheet>'))
from xmltest;