插手 10.1w+
就教一下Sqlite数据库体积的标题题目
列位教员,请帮助看下这个语句:提醒爱游戏开放平台效数据。其实是找不出。
(SELECT
a.jlxh as ID,
--2.2.7. 门(急)诊发药记实(OUTPATIENT_DISPENSE_RECORD)(优先级2)
(SELECT GZSYYJGPT_ZDDZ.PTCODE FROM GZSYYJGPT_ZDDZ WHERE ZDLB = 'CT0800002' AND HISCODE = B.KSDM ) AS CLINIC_DEPT_CODE,--救治爱游戏开放平台室代码
(SELECT KSMC FROM GY_KSDM WHERE KSDM = B.KSDM ) AS CLINIC_DEPT_NAME,--救治爱游戏开放平台室称号
(SELECT CSZ FROM GY_XTCS WHERE CSMC = 'GZSYYJGPT_ORGAN_CODE_SYSTEM' AND JGID = 1 )|| TO_CHAR(d.mzhm) AS PATIENT_LOCAL_ID,--患者本地独一ID
a.jlxh as BUSINESS_LOCAL_ID,--发药明细序号
c.sbxh as PRESCRIBE_LOCAL_ID,--发药序号
c.ypxh as DRUG_ID,--药品编码
'' as DRUG_PROCUREMENT_CODE,--药品推销码
(select ypmc from yk_ypml where ypxh =c.ypxh)as DRUG_NAME,--药物称号
'' INSUR_CODE,--医保编码
nvl(a.ypgg,a.yfdw) as DRUG_SPECIFICATIONS,--药物规格
cast(a.ypsl as NUMERIC(10))as DISPENSING_QUANTITY,--药品发药数目
插手 6058
插手 1438
插手 6.0w+
插手 386
进入社区检查出色内容
插手 64
插手 12.8w+
插手 3.3w+
插手 6.2w+
插手 3.9w+
插手 6.5w+
插手 59