Oracle 10g：从 XML（CLOB 类型）中提取数据（选择）

使用 Oracle 10g 从 XML（CLOB 类型）中提取数据

sql
CREATE TABLE students (
    student_id NUMBER,
    student_info CLOB
);

sql
INSERT INTO students (student_id, student_info)
VALUES (1, XMLType('John Doe20'));
INSERT INTO students (student_id, student_info)
VALUES (2, XMLType('Jane Smith22'));

sql
SELECT student_id, xmldata.name, xmldata.age
FROM students,
     XMLTable('/student'
              PASSING XMLType(student_info)
              COLUMNS name VARCHAR2(50) PATH 'name',
                      age NUMBER PATH 'age') xmldata;