asked on
ASKER
ASKER
drop table tab1 purge;
create table tab1(xml_data xmltype);
insert into tab1 values('
<TfmsData xmlns="http://tfm.faa.gov/tfms/TfmsData" xmlns:nxce="http://tfm.faa.gov/tfms/NasXCoreElements">
<GeospatialData>
<Navaid>
<NavaidID>ZVR</NavaidID>
</Navaid>
</GeospatialData>
</TfmsData>
');
commit;
select NavaidID
from tab1,
xmltable(
xmlnamespaces(default 'http://tfm.faa.gov/tfms/TfmsData',
'http://tfm.faa.gov/tfms/NasXCoreElements' as "nxce"
),
'/TfmsData/GeospatialData'
passing xml_data
columns
NavaidID varchar2(50) path '/GeospatialData/Navaid/NavaidID'
) xmltab
/
select XMLQuery(
'declare default element namespace "http://tfm.faa.gov/tfms/TfmsData"; (: :)
//Navaid/NavaidID/text()'
PASSING XML_DATA RETURNING CONTENT)
from tab1;
ASKER
ASKER
drop table tab1 purge;
create table tab1(xml_data xmltype);
insert into tab1 values('
<TfmsData xmlns="http://tfm.faa.gov/tfms/TfmsData" xmlns:nxce="http://tfm.faa.gov/tfms/NasXCoreElements">
<GeospatialData>
<Navaid>
<NavaidID>ZVR</NavaidID>
<ArtccID>CZV</ArtccID>
</Navaid>
</GeospatialData>
</TfmsData>
');
commit;
select NavaidID,ArtccID
from tab1,
xmltable(
xmlnamespaces(default 'http://tfm.faa.gov/tfms/TfmsData',
'http://tfm.faa.gov/tfms/NasXCoreElements' as "nxce"
),
'/TfmsData/GeospatialData'
passing xml_data
columns
NavaidID varchar2(50) path '/GeospatialData/Navaid/NavaidID',
ArtccID varchar2(50) path '/GeospatialData/Navaid/ArtccID'
) xmltab
/
ASKER
ASKER
ASKER
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.
TRUSTED BY
What does this return:
select dbms_lob.getlength(x.XML_D