3,494
社区成员




SELECT EXTRACTVALUE(x, '/Card/NICKNAME', 'xmlns="vcard"') NICKNAME,
EXTRACTVALUE(x, '/Card/CITY', 'xmlns="vcard"') CITY,
EXTRACTVALUE(x, '/Card/LOCALITY', 'xmlns="vcard"') LOCALITY
FROM (SELECT XMLTYPE('<Card xmlns="vcard"><NICKNAME>小强</NICKNAME><CITY>China</CITY><LOCALITY>BJ</LOCALITY></Card>') X
FROM dual);
NICKNAME CITY LOCALITY
--------------- --------------- ---------------
小强 China BJ