|
|
От: |
Funny Rabbit
|
|
| Дата: | 14.09.25 07:15 | ||
| Оценка: | |||
SELECT xt.*
FROM (
SELECT
XMLELEMENT("Employee", XMLATTRIBUTES(pl AS "ID", f1 AS "Name"),
XMLELEMENT("Salary", f2),
XMLELEMENT("Department", f2) ) AS xml_data
FROM
(
SELECT LEVEL AS pl, chr(LEVEL + 100) AS f1, LEVEL + 100 AS f2 FROM dual CONNECT BY LEVEL <= 10
)
) z, XMLTABLE('/Employee'
PASSING z.xml_data
COLUMNS
Salary VARCHAR2(10) PATH 'Salary',
Department VARCHAR2(100) PATH 'Department'
) xt;В чем проблема и как исправить. Благодарен за любые наводки.SQL Error [19114] [72000]: ORA-19114: error during parsing the XQuery expression:
ORA-06550: line 1, column 13:
PLS-00201: identifier 'SYS.DBMS_XQUERYINT' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored