Q：oracle中blog中截取部分字符串

blog报文中获取对应标签字符串

将xxx替换成需要查询的标签

to_char(substr(C_INPUT,instr(C_INPUT,'<xxx>')+length('<xxx>'),instr(C_INPUT,'</xxx>')-instr(C_INPUT,'<xxx>')-length('<xxx>'))) as xxx

示例

select
to_char(substr(C_INPUT,instr(C_INPUT,'<patient_name>')+length('<patient_name>'),instr(C_INPUT,'</patient_name>')-instr(C_INPUT,'<patient_name>')-length('<patient_name>'))) as name
from interface_log where c_action='doctor_baseinfo_call' and c_code='emr_server' and C_STUTS='-2'
and C_INF_TIME>sysdate-10 and C_INF_TIME<sysdate-3 order by C_INF_TIME desc