Revision: 47965
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at June 20, 2011 17:27 by avj
Initial Code
create table xtest01(col1 xmltype);
insert into xtest01 values ('<car><model>Audi TT</model></car>');
insert into xtest01 values ('<car model="BMW X5"/>');
select x.col1.extract('//car/model/text()').getstringval() from xtest01 x;
select x.col1.extract('//car/@model').getstringval() from xtest01 x;
select * from xtest01 x where x.col1.existsnode('//car') = 1;
Initial URL
Initial Description
Initial Title
working with XML (find out if element or attribute exists)
Initial Tags
xml
Initial Language
PL/SQL