CREATE OR REPLACE VIEW SD_HOSPITAL.VW_ZS_BA_BRSSXX
 (
 LSH000, SSBH00, SSRQSJ, SSMC00, SSYSXM, SSZSXM, MZMC00, MZYSXM, YKYHDJ

 )
 AS 
select LSH000,
       decode(SSM000,'999999','',SSM000) as SSBH00,
       SSRQ00 as SSRQSJ,SSMC00,SSYSMC,IYSMC0 as SSZSXM,MZFS00,MZYSMC,QKYHDJ from ba_brssxx 
union all    --加一行空行为了前台打印，如果没有数据前台不能打印
select null,null,null,null,null,null,null,null,null from dual
/