CODEWITHSUNDEEP
xmlplsql
avj
avj

Reputation: 1686

How to get xml attribute with plsql?

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?

Upvotes: 6

Views: 16482

Answers (1)

Samuel
Samuel

Reputation: 2490

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

Upvotes: 9

Related Questions