select a.*,  decode(a.ZYZBMC, '病理',a.BGURL0 || 'z.asp?zyh=' || a.ZYHGHH, a.BGURL0 || a.YJDJH0) BGADDR,decode(a.ZYZBMC,'病理','',a.YXURL0 || a.YJDJH0) YXADDR   ,decode(mzzybz,'0','门诊','住院') MZZYMC  ,( select  exam_status from SPACS.V_RHIS_EXAMSTATUS where  yjdjh0=APPLY_NO and  name=BRXM00  and rownum=1) ZTMC00  from VW_PACS_BGCX00_DZBL a  where   brid00='1262658' order by A.KDRQ00 DESC




insert into pt_sqlrz0(id0000, ygbh00, ygxm00, jsjip0, jsjmac, xtdm00, sql000, sqlcs0, ycxx00, zxsj00, bz0000)values(SQ_PT_SQLRZ0_ID0000.nextval, 1372, '黄剑辉', '18.0.1.116', '00:23:24:A8:D5:98', 'V ', 'select a.*,  decode(a.ZYZBMC, '病理',a.BGURL0 || 'z.asp?zyh=' || a.ZYHGHH, a.BGURL0 || a.YJDJH0) BGADDR,decode(a.ZYZBMC,'病理','',a.YXURL0 || a.YJDJH0) YXADDR   ,decode(mzzybz,'0','门诊','住院') MZZYMC  ,( select  exam_status from SPACS.V_RHIS_EXAMSTATUS where  , '', '', 0, '')