我想从表TRAPTABCLOB中使用sql提取Decision的值,该列具有存储为clob的XML的列testclob.
示例XML如下.
<?xml version="1.0" encoding="UTF-8"?> <DCResponse> <Status>Success</Status> <Authentication> <Status>Success</Status> </Authentication> <ResponseInfo> <ApplicationId>5701200</ApplicationId> <SolutionSetInstanceId> 63a5c214-b5b5-4c45-9f1e-b839a0409c24 </SolutionSetInstanceId> <CurrentQueue /> </ResponseInfo> <ContextData> <!--Decision Details Start--> <Field key="SoftDecision">A</Field> <Field key="**Decision**">1</Field> <Field key="NodeNo">402</Field> <Field key="NodeDescription" /> <!--Decision Details End--> <!--Error Details Start--> <Field key="ErrorResponse"> <Response> <Status>[STATUS]</Status> <ErrorCode>[ERRORCODE]</ErrorCode> <ErrorDescription>[ERRORDESCRIPTION]</ErrorDescription> <Segment>[SEGMENT]</Segment> </Response> </Field> <Field key="ErrorCode">0</Field> <Field key="ErrorDescription" /> </ContextData> </DCResponse>