SELECT a.ID0000,a.LSH000,a.SSXH00, decode(a.SSM000,'0','',a.ssm000) ssm000,a.SSZL00 SSDJMC,(select SSDJBH from BM_SSDJ00 where SSDJMC = sszl00) ssdj00,
                            a.SSMC00,to_date(a.SSRQ00,'YYYYMMDD') SSRQ00,a.SSSJ00,
                            a.SSYS00,a.SSYSMC,a.IYS000,a.IYSMC0,a.IIYS00,a.IIYSMC,a.MZFS00,a.MZYS00,
                            a.MZYSMC,a.QKYHDJ,a.BWMC00,a.FWMC00,a.BCSM00 ,'Update' Flag,a.SSLB00,a.SSCXSJ,a.MZFJ00,'' SSJSRQ,'' SSJSSJ,LX0000
                            FROM BA_BRSSXX a WHERE a.LSH000=6041339 ORDER BY  nvl(LX0000,0),SSXH00 

SELECT  a.zyghid LSH000,a.SSXH00, nvl(a.ssbh00,(select cm3000 from xt_cm3000 where ssmc00=d.ssxmjc and rownum=1)) SSM000,a.SSDJMC,
                            a.SSMC00,to_date(a.yyssrq,'YYYYMMDD') SSRQ00,a.yysssj SSSJ00,a.QKDJMC,
                            a.SSYS00,a.ssysxm SSYSMC,a.sszs00 IYS000,a.sszsxm IYSMC0,a.sszs00 IIYS00,a.sszsxm IIYSMC,a.MZMC00 MZFS00,a.MZYS00,
                            a.MZYSXM MZYSMC,(a.QKDJMC || '/' || a.YHDJMC) as QKYHDJ,to_date(substr(a.CZRQ00, 1, 8), 'YYYYMMDD') CZRQ00,substr(a.CZRQ00, 9, 10) CZSJ00,d.sfzss0 SSLB00,b.czy000,'Update' Flag ,'' SSCXSJ,a.MZFJ00,to_date(a.SSJSRQ,'YYYYMMDD') SSJSRQ,a.SSJSSJ,'' LX0000 
                            FROM vw_ss_yw0000_dzbl a, ss_yw0000 b,ss_ywmx00 d WHERE a.ssmc00  is not null  and   a.SSDH00 = b.ssdh00 and d.ssdh00=a.SSDH00 and a.mzzybz='1' and (a.BASYXS is null or a.BASYXS ='1')  and b.SSZT00 in('0','2','4') and a.zyghid=6041339 ORDER BY  SSXH00

select SSSFTB  from BA_BRZYXX where lsh000 = 6041339

update BA_BRSSXX set ID0000=SQ_BA_BRSSXX_ID0000.nextval where ID0000 is null and lsh000 = 6041339

select  distinct A.*,
                    (select SSDJBH from BM_SSDJ00 where SSDJMC = a.SSDJ00) SSDJBH,(select SSMC00 from xt_cm3000 where CM3000=A.SSM000 and rownum=1) SSMC00,
                    TO_DATE(B.QYRQ00, 'YYYYMMDD') LRRQ00,substr(B.QYSJ00,0,5)||':00'  QYSJ00,b.QYRQ00
                      from ZS_ZLZDSS A, BQ_YJYZ00 b, YJ_YW0000 C
                     where A.ZLXMID = B.ZLXMID      
                       and B.YZMXID = C.YZCFID
                       and B.ZLXMID = C.ZLXMID
                       and C.ZYGHID = B.ZYID00
                       and ZT0000 = '1'
                       and C.XMZT00 in ('1', '2', '3', '4')
                       and C.CXDJH0 is null
                       and MZZYBZ = '1'
                       and YZZT00 <> '4'
                       and B.ZYID00 = 6041339 order by a.SSM000,b.qyrq00||QYSJ00 asc

select a.brxm00 cname,a.zlxmjc testitemname,a.zy0000 REPORTVALUEALL,a.ywid00 SAMPLENO,a.yjdjh0,a.Zdclr0   from VW_ZS_WJZTX0_ZYDZBL a,zy_brxxb0 z  where a.Zyghid=z.zyid00 and a.sftxbq='1' and SFZZJS='0' and ((KDKSBH = 2232 and Zdclr0 = 4960) or (KDKSBH = 2232 and zdclr0 is null))

SELECT a.ID0000,a.LSH000,a.SSXH00, decode(a.SSM000,'0','',a.ssm000) ssm000,a.SSZL00 SSDJMC,(select SSDJBH from BM_SSDJ00 where SSDJMC = sszl00) ssdj00,
                            a.SSMC00,to_date(a.SSRQ00,'YYYYMMDD') SSRQ00,a.SSSJ00,
                            a.SSYS00,a.SSYSMC,a.IYS000,a.IYSMC0,a.IIYS00,a.IIYSMC,a.MZFS00,a.MZYS00,
                            a.MZYSMC,a.QKYHDJ,a.BWMC00,a.FWMC00,a.BCSM00 ,'Update' Flag,a.SSLB00,a.SSCXSJ,a.MZFJ00,'' SSJSRQ,'' SSJSSJ,LX0000
                            FROM BA_BRSSXX a WHERE a.LSH000=6041339 ORDER BY  SSXH00,ID0000