SQL> with 
  2    data as (
  3      select xmltype('<row10>
  4  <Col0>10001474</Col0 >
  5  <Col1>ALL STICK LABEL LIMITED</Col1 >
  6  <Col2>532250</Col2 >
  7  <Col3>0</Col3 >
  8  <Col4>0</Col4 >
  9  <Col5>0</Col5 >
 10  <Col6>0</Col6 >
 11  </row10>') val 
 12      from dual
 13    )
 14  select count(*) 
 15  from data, table(xmlsequence(extract(val, '/row10/*')))
 16  /
  COUNT(*)
----------
         7

SQL> declare
  2    val clob := '<row10>
  3  <Col0>10001474</Col0 >
  4  <Col1>ALL STICK LABEL LIMITED</Col1 >
  5  <Col2>532250</Col2 >
  6  <Col3>0</Col3 >
  7  <Col4>0</Col4 >
  8  <Col5>0</Col5 >
  9  <Col6>0</Col6 >
 10  </row10>';
 11    i pls_integer;
 12  begin
 13    i := 1;
 14    while xmltype(val).existsnode('/row10/*['||i||']') = 1 loop
 15      i := i + 1;
 16    end loop;
 17    dbms_output.put_line('Nb nodes = '||(i-1));
 18  end;
 19  /
Nb nodes = 7