17,140
社区成员




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'
);
select * from
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'
);