select xt.* from xmltable('/persons/person' parsing xmltype (:x_xml) columns empno varchar2(10) path 'empno', empnm varchar2(50) path 'emp_nm') xt select * from xmltable('123,123')