PL/SQL:遍历XML列并从重复元素中提取值

DECLARE
   xml_data XMLType := XMLType('<employees>
                                <employee>
                                   <id>1</id>
                                   <name>John</name>
                                </employee>
                                <employee>
                                   <id>2</id>
                                   <name>Jane</name>
                                </employee>
                                <employee>
                                   <id>3</id>
                                   <name>Mike</name>
                                </employee>
                             </employees>');
BEGIN
   FOR emp IN (SELECT xt.*
               FROM   XMLTable('/employees/employee' PASSING xml_data
                               COLUMNS id   NUMBER PATH 'id',
                                       name VARCHAR2(100) PATH 'name') xt)
   LOOP
      DBMS_OUTPUT.PUT_LINE('Employee ID: ' || emp.id);
      DBMS_OUTPUT.PUT_LINE('Employee Name: ' || emp.name);
   END LOOP;
END;
/