因数据存储在Blob字段中,想要对其检索查询
SELECT REQUEST_XML, RESPONSE_XML, A.*
FROM OWNER.TABLE a
WHERE ADD_DATE > TO_DATE ('20210930 180001','YYYYMMDD HHZ4MISS')
AND ADD_DATE < TO_DATE ('20210930 180001', 'YYYYMMDD HHZ4MISS')
AND API_NAME LIKE 'Ra/repair update'
AND DBMS_LOB.INSTR (request_xml,
UTL_RAW.cast_to_raw ('TEST'),1,1) <> 0
学习: