Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE PLAYER OF XMLTYPE;
INSERT INTO PLAYER VALUES (XMLTYPE('<?xml version="1.0" encoding="UTF-8"?>
<!-- https://github.com/albergcg/wpt_webscraping -->
<Players>
<Player id="1" ranking="1">
<Name>Francinsco Navarro Compán</Name>
<Score>12010</Score>
<!-- ... -->
</Player>
</Players>'));
1 rows affected

select * from player


SYS_NC_ROWINFO$


<?xml version="1.0" encoding="UTF-8"?>
<!-- https://github.com/albergcg/wpt_webscraping -->
<Players>
  <Player id="1" ranking="1">
    <Name>Francinsco Navarro Compán</Name>
    <Score>12010</Score>
    <!-- ... -->
  </Player>
</Players>



select id, name from player
ORA-00904: "NAME": invalid identifier

select XMLQuery('/Players/Player/@id' passing p.object_value returning content) as id,
  XMLQuery('/Players/Player/Name/text()' passing p.object_value returning content) as name
from player p


ID
NAME


1
Francinsco Navarro Compán


select x.id, x.name
from player p
cross apply XMLTable(
  '/Players/Player'
  passing p.object_value
  columns id number path '@id',
    name varchar2(30) path 'Name'
) x


ID
NAME


1
Francinsco Navarro Compán