--报错,在要求输入数字处找到非数字字符
select YH_YH.YHID yhid,
to_char(to_date(substr(ZD_ZDCS.Csdqz, 0, 4), 'mm-dd'), 'mm-dd') ks,
to_char(to_date(substr(ZD_ZDCS.Csdqz, 5, 4), 'mm-dd'), 'mm-dd') js
from ZD_ZDCS, ZC_ZDZC, YH_YH
where csx in ('8059', '8079', '8089', '8099')
and ZD_ZDCS.zdjh = ZC_ZDZC.ZDJH
and YH_YH.YHID = ZC_ZDZC.Yhid
and to_char(trunc(sysdate), 'mm-dd') between
to_char(to_date(substr(ZD_ZDCS.Csdqz, 0, 4), 'mm-dd'), 'mm-dd') and
to_char(to_date(substr(ZD_ZDCS.Csdqz, 5, 4), 'mm-dd'), 'mm-dd')


-- 下面这个可以正确的运行
select to_char(to_date(substr(ZD_ZDCS.Csdqz, 0, 4), 'mm-dd'),'mm-dd') ks,
to_char(to_date(substr(ZD_ZDCS.Csdqz, 5, 4), 'mm-dd'),'mm-dd') js
from ZD_ZDCS
where csx in ('8059', '8079', '8089', '8099')
and ZD_ZDCS.zdjh = '9200000925867'
and to_char(trunc(sysdate), 'mm-dd') between
to_char(to_date(substr(ZD_ZDCS.Csdqz, 0, 4), 'mm-dd'), 'mm-dd') and
to_char(to_date(substr(ZD_ZDCS.Csdqz, 5, 4), 'mm-dd'), 'mm-dd')


--也可以运行
select YH_YH.YHID yhid
from ZD_ZDCS, ZC_ZDZC, YH_YH
where csx in ('8059', '8079', '8089', '8099')
and ZD_ZDCS.zdjh = ZC_ZDZC.ZDJH
and YH_YH.YHID = ZC_ZDZC.Yhid


select ZD_ZDCS.Csdqz
from ZD_ZDCS
where zdjh = '9200000925867'
and csx='8059'

查询结果为:

091311200400000001

它的意思是09月13号至11月20号XXXXX,

我现在要从ZD_ZDCS里面找到ZDJH,再由ZDJH在ZC_ZDZC里找到YHID,再由YHID从YH_YH找到

相关信息.