我现在有一个表 t( tc blob )
存的格式为 :
<queryconfig>
<conditions>
<condition display="2" field="city" datatype="6" logic="0" value="" constraint="0" wildcard="0" visible="1" extentinfo="CITY">
<cities citytype="2" devicefield="cell" devicetype="23" filter="localflag=1" drill="1" showcell="0">
</cities>
</condition>
<condition display="3" field="city" datatype="7" logic="0" value="" constraint="0" wildcard="0" visible="1" extentinfo="CITY2">
<cities citytype="2" devicefield="cell" devicetype="23" filter="localflag=1" drill="1" showcell="0">
</cities>
</condition>
</conditions>
</queryconfig>
请问我将怎么取出 extentinfo="CITY"
存的格式为 :
<queryconfig>
<conditions>
<condition display="2" field="city" datatype="6" logic="0" value="" constraint="0" wildcard="0" visible="1" extentinfo="CITY">
<cities citytype="2" devicefield="cell" devicetype="23" filter="localflag=1" drill="1" showcell="0">
</cities>
</condition>
<condition display="3" field="city" datatype="7" logic="0" value="" constraint="0" wildcard="0" visible="1" extentinfo="CITY2">
<cities citytype="2" devicefield="cell" devicetype="23" filter="localflag=1" drill="1" showcell="0">
</cities>
</condition>
</conditions>
</queryconfig>
请问我将怎么取出 extentinfo="CITY"
但是我现在的 存储过程需要读取,不明白怎么读取了。
length := DBMS_LOB.GETLENGTH(v_blob);
buf := DBMS_LOB.SUBSTR(v_blob, length, 1);
DBMS_LOB.FREETEMPORARY(v_blob);
这段代码将blob类型的v_blob转换成varchar2类型了,是在PL/SQL中的语句,你看看还能借鉴下