How to get xml attribute with plsql?

Question

create table xtest01(col1 xmltype);
insert into xtest01 values ('<car><model>Audi TT</model></car>');
insert into xtest01 values ('<car model="BMW X5"/>');

-- I know how to get Audi TT:

select x.col1.extract('//car/model/text()').getStringVal() from xtest01 x;

-- But how to get BMW X5?

Samuel · Accepted Answer · 2011-06-09 09:47:53Z

9

select x.col1.extract('//car/@model').getStringVal() from xtest01 x;

answered Jun 9, 2011 at 9:47

Samuel

2,5102 gold badges19 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

avj Over a year ago

thanks! (this is the answer; I can accept it after some minutes, as pop-up says to me)

Collectives™ on Stack Overflow

How to get xml attribute with plsql?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related