1.插入或更新数据库时
BLOB:rawtohex(#{字段名}) 否则,会报错:ORA-01465: 无效的十六进制数字
DATE:to_date(#{字段名},'yyyy-mm-dd hh24:mi:ss')
2.查询
BLOB:UTL_RAW.CAST_TO_VARCHAR2(字段)
Date:to_char(字段名,'yyyy-mm-dd hh24:mi:ss')
BLOB:rawtohex(#{字段名}) 否则,会报错:ORA-01465: 无效的十六进制数字
DATE:to_date(#{字段名},'yyyy-mm-dd hh24:mi:ss')
BLOB:UTL_RAW.CAST_TO_VARCHAR2(字段)
Date:to_char(字段名,'yyyy-mm-dd hh24:mi:ss')