想解析一段xml格式的字符串,将其中的字段解析出来,但是一直报错,求助!
语句如下:
select * from
xmltable('$B/COMMAND/IN/VALUE'
PASSING XMLTYPE('<?XML VERSION="1.0" ENCODING="GB2312"><COMMAND><VALUE>
<OUT_MAT_NO>193599305</OUT_MAT_NO>
</VALUE></COMMAND>') as B
COLUMNS
OUT_MAT_NO varchar2(12) PATH '/VALUE/OUT_MAT_NO'
);
报错信息为:
ORA-00933: SQL command not properly ended
报错时指定xmltable,求助!!求助!!Oraclexmltable
语句如下:
select * from
xmltable('$B/COMMAND/IN/VALUE'
PASSING XMLTYPE('<?XML VERSION="1.0" ENCODING="GB2312"><COMMAND><VALUE>
<OUT_MAT_NO>193599305</OUT_MAT_NO>
</VALUE></COMMAND>') as B
COLUMNS
OUT_MAT_NO varchar2(12) PATH '/VALUE/OUT_MAT_NO'
);
报错信息为:
ORA-00933: SQL command not properly ended
报错时指定xmltable,求助!!求助!!Oraclexmltable
xmltable('$B/COMMAND/VALUE' PASSING
XMLTYPE('<?xml version="1.0" encoding="gb2312" ?>
<COMMAND><VALUE>
<OUT_MAT_NO>193599305</OUT_MAT_NO>
</VALUE></COMMAND>') as B
COLUMNS
OUT_MAT_NO varchar2(12) PATH '/VALUE/OUT_MAT_NO'
);