记录如下,仅供参考:
select p.prescriptionno 处方号,
o.patientname 姓名,
o.patientidno 身份证号,
(CASE
WHEN (LENGTH(o.patientidno)) = 15 THEN
DECODE(MOD(SUBSTR(o.patientidno, 15, 1), 2), '0', '女', '男')
WHEN (LENGTH(o.patientidno)) = 18 THEN
DECODE(MOD(SUBSTR(o.patientidno, 17, 1), 2), '0', '女', '男')
end) 性别,
p.prescribetime 结算时间,
p.prescriptionfee 处方总金额,
p.hoschargeproname 药品名称
from PRESCRIPTIONINFO p, outpatientregistereq o
where p.reqid = o.id
and p.prescribedoc = '手机号'
and p.hoschargeproname like '%乳癖%';