SELECT
LSH,
S.PERSONALNUMBER GRBH,
J.XM,
J.SFZH,
L.INSTITUTION_NO JGBH,
L.JGMC,
TO_CHAR(S.SKSJ,'yyyymmddhh24miss') JSSJ,
S.SUBSTITUTES SFDB,
DECODE(S.zplx, 1, 1, 2, 1, 3, 1, 0) BDJG
FROM YW_SKJL S
LEFT JOIN YW_JZZP J ON S.ZPID = J.ZPID,
JC_LDJG L
WHERE S.YDH = L.JGDM
ORDER BY S.SKSJ DESC;
create or replace view v_hzfi_settlementDetails
as
SELECT D.DOCTORNAME XM,
D.DOCTORIDCARDNUMBER SFZH,
L.INSTITUTION_NO JGBH,
L.JGMC,
DECODE(D.TYPE,2,2,1) LX,
TO_CHAR(D.ATTENDANCETIME,'yyyymmddhh24miss') KQSJ,
DECODE(D.RESULT, 1, 1, 0) BDJG
FROM YW_ATTENDANCERECORD D,
JC_LDJG L
WHERE D.HOSPITALID = L.ID ORDER BY KQSJ DESC ;
create user hzfi identified by "hzsi#2020";
grant connect to hzfi;
grant select on v_hzfi_settlementDetails to hzfi;
grant select on v_hzfi_attendanceDetails to hzfi;
grant create synonym to hzfi;
create or replace synonym hzfi.v_hzfi_settlementDetails for v_hzfi_settlementDetails;
create or replace synonym hzfi.v_hzfi_attendanceDetails for v_hzfi_attendanceDetails;
Processed:
0.009, SQL:
9
