create or replace view vw_jy_ks0000_ydzbtj as
Select "BMMC00","BMBH00","PYSM00","WBSM00" from (select BMMC00,BMBH00,pysm00,wbsm00 from VW_JY_KS0000 where (pysm00 Like '%' or BMBH00 Like '%') and
( bmxz00 in ('0','1','5','9') )  order by BMBH00,pysm00) where Rownum<=99;