数据库中按大字段的值来查询

1.大字段中的时间格式：

TO_DATE(substr(to_char(regexp_substr(t.INPUT_TEXT2,'expireTime\":\"[^\\"}]+')),14,20), 'YYYY-MM-DD HH24:MI:SS') as expireTime,

2.大字段中的整数类型格式：

NVL(TO_NUMBER(DECODE(substr(to_char(regexp_substr(t.INPUT_TEXT2,'processState\":\"[^\\"}]+')),16,5),
'', NULL,
'NOT A NUMBER', NULL,
0)), 0) AS processState,

3.大字段中的字符串类型格式：

substr(to_char(regexp_substr(t.INPUT_TEXT2,'beneficiaryName\":\"[^\\"}]+')),19,20) as beneficiaryName,

大字段数据：

{"applyId":"申请人OAID","applyName":"申请人OA姓名","applyOrgId":"申请人组织ID","applyOrgName":"申请人组织名称","guaranteeSubjectCode":"保函申请主体,固定值ICT","beneficiaryName":"保函收益人名称","guaranteeType":"保函类型","explain":"保函类型其他说明,保函类型选其它时，需要输入此字段","expireTime":"2024-09-03 14:00:00","extensionTime":"2024-09-04 14:00:00","guaranteeIssuanceTime":"2024-09-02 14:00:00","issuingAmount":"123.45","beneficiaryGuaranteeAmount":"23.45","otherRemarks":"其他备注","extensionRemarks":"延期说明，保函延期时有值,开具时为否","guaranteeOrgId":"开具担保金融机构","guaranteeOrgRemark":"开具担保金融机构备注，开具担保金融机构选择其他时不能为空","guaranteeCode":"保函编号，不能为空","issuingResult":"开具结果，初始化为空","extensionState":"1","bankGuaranteeCode":"银行保函编号","issuingInstitution":"开立机构，不能为空","subAccount":"子账户不能为空","currentInterestRate":"0.45","depositTime":"2024-09-02","cancelAccountTime":"2024-09-02","piid":"流程实例ID，在OA回调方法中获取","processState":"1","lastUpdateDate":"2024-09-03 14:00:00","issueId":"保函开具IDString","recoveryResult":"1","recoveryTime":"2024-09-04 14:00:00","receiverId":"接收人ID，回收结果为已归还不能为空","remark":"备注String"}