avj on 06/20/11
Last Edited at 06/20/11 05:27pm
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;
Report this snippet Tweet
Comment:
You need to login to post a comment.