Select * from (select LJMC00,LJBM00,PYSM00,LJID00 from VW_ZY_LJ_MBXX where (PYSM00 Like :1) Order By PYSM00) where Rownum<=1000


Error occurred: [1036] (ORA-01036: 非法的变量名/编号
)

--------------------------------------------------------------------------------
Timestamp: 2020/5/14 17:07:07

Select * from (select LJMC00,LJBM00,PYSM00,LJID00 from VW_ZY_LJ_MBXX where (PYSM00 Like '%%') Order By PYSM00) where Rownum<=1000




:1=['%%']


Elapsed time: 0.033

Select * from (select LJMC00,LJBM00,PYSM00,LJID00 from VW_ZY_LJ_MBXX where (PYSM00 Like :1) Order By Instrb(PYSM00,'q'),PYSM00) where Rownum<=1000


Error occurred: [1036] (ORA-01036: 非法的变量名/编号
)

--------------------------------------------------------------------------------
Timestamp: 2020/5/14 17:07:08

Select * from (select LJMC00,LJBM00,PYSM00,LJID00 from VW_ZY_LJ_MBXX where (PYSM00 Like '%q%') Order By Instrb(PYSM00,'q'),PYSM00) where Rownum<=1000




:1=['%q%']


Elapsed time: 0.007

Select * from (select LJMC00,LJBM00,PYSM00,LJID00 from VW_ZY_LJ_MBXX where (PYSM00 Like :1) Order By Instrb(PYSM00,'qx'),PYSM00) where Rownum<=1000


Error occurred: [1036] (ORA-01036: 非法的变量名/编号
)

--------------------------------------------------------------------------------
Timestamp: 2020/5/14 17:07:10

Select * from (select LJMC00,LJBM00,PYSM00,LJID00 from VW_ZY_LJ_MBXX where (PYSM00 Like '%qx%') Order By Instrb(PYSM00,'qx'),PYSM00) where Rownum<=1000




:1=['%qx%']


Elapsed time: 0.003

Select * from (select LJMC00,LJBM00,PYSM00,LJID00 from VW_ZY_LJ_MBXX where (PYSM00 Like :1) Order By Instrb(PYSM00,'qxx'),PYSM00) where Rownum<=1000


Error occurred: [1036] (ORA-01036: 非法的变量名/编号
)

--------------------------------------------------------------------------------
Timestamp: 2020/5/14 17:07:10

Select * from (select LJMC00,LJBM00,PYSM00,LJID00 from VW_ZY_LJ_MBXX where (PYSM00 Like '%qxx%') Order By Instrb(PYSM00,'qxx'),PYSM00) where Rownum<=1000




:1=['%qxx%']


Elapsed time: 0.002

  SELECT a.*,(select count(*) from LJ_JDYZMX b  where  b.YZZT00='0' and  CLBZ00 in('0','1') and SYFW00=0 and LJID00=a.LJID00 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,YPNM00,187,0,ZLXMID)=1) YZZT00 FROM VW_ZY_LJ_MBXX a where  LJZT00<>'2'  and a.LJBM00=282  and (a.KSBH00=0 or exists(select 1 from LJ_LJDYKS b,BM_BMBM00 c where LJID00=a.LJID00 and b.KSBH00=c.BMBH00 and c.YYID00='226883')) order by to_number(LJBM00)


Error occurred: [1036] (ORA-01036: 非法的变量名/编号
)

--------------------------------------------------------------------------------
Timestamp: 2020/5/14 17:07:13

  SELECT a.*,(select count(*) from LJ_JDYZMX b  where  b.YZZT00='0' and  CLBZ00 in('0','1') and SYFW00=0 and LJID00=a.LJID00 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,YPNM00,187,0,ZLXMID)=1) YZZT00 FROM VW_ZY_LJ_MBXX a where  LJZT00<>'2'  and a.LJBM00=282  and (a.KSBH00=0 or exists(select 1 from LJ_LJDYKS b,BM_BMBM00 c where LJID00=a.LJID00 and b.KSBH00=c.BMBH00 and c.YYID00='226883')) order by to_number(LJBM00)




Elapsed time: 0.016

select count(*) COU from LJ_YZLBZD a where LJID00=119 and YXBZ00='1' 


Error occurred: [1036] (ORA-01036: 非法的变量名/编号
)

--------------------------------------------------------------------------------
Timestamp: 2020/5/14 17:07:13

select count(*) COU from LJ_YZLBZD a where LJID00=119 and YXBZ00='1' 




Elapsed time: 0.002

select count(*) from LJ_MBZLJD  where JDZT00='0' and LJID00=119


Error occurred: [1036] (ORA-01036: 非法的变量名/编号
)

--------------------------------------------------------------------------------
Timestamp: 2020/5/14 17:07:14

select count(*) from LJ_MBZLJD  where JDZT00='0' and LJID00=119




Elapsed time: 0.002

select distinct YEXM00 from LJ_JDYZMX where LJID00=119 and YZZT00='0' 


Error occurred: [1036] (ORA-01036: 非法的变量名/编号
)

--------------------------------------------------------------------------------
Timestamp: 2020/5/14 17:07:14

select distinct YEXM00 from LJ_JDYZMX where LJID00=119 and YZZT00='0' 




Elapsed time: 0.006

select A.*,B.LJMC00 from LJ_MBZLJD A,LJ_MB0000 B where  A.LJID00=119 and  JDZT00='0' and A.LJID00=B.LJID00 order by xh0000 


Error occurred: [1036] (ORA-01036: 非法的变量名/编号
)

--------------------------------------------------------------------------------
Timestamp: 2020/5/14 17:07:14

select A.*,B.LJMC00 from LJ_MBZLJD A,LJ_MB0000 B where  A.LJID00=119 and  JDZT00='0' and A.LJID00=B.LJID00 order by xh0000 




Elapsed time: 0.002

select  count(*) COU from VW_ZY_LJ_MBYZXX a where  LJID00=119 and  RCID00=341  and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,187,0,a.ZLXMID)=1 


Error occurred: [1036] (ORA-01036: 非法的变量名/编号
)

--------------------------------------------------------------------------------
Timestamp: 2020/5/14 17:07:14

select  count(*) COU from VW_ZY_LJ_MBYZXX a where  LJID00=119 and  RCID00=341  and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,187,0,a.ZLXMID)=1 




Elapsed time: 0.031

select  count(*) COU from VW_ZY_LJ_MBYZXX a where  LJID00=119 and  RCID00=342  and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,187,0,a.ZLXMID)=1 


Error occurred: [1036] (ORA-01036: 非法的变量名/编号
)

--------------------------------------------------------------------------------
Timestamp: 2020/5/14 17:07:14

select  count(*) COU from VW_ZY_LJ_MBYZXX a where  LJID00=119 and  RCID00=342  and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,187,0,a.ZLXMID)=1 




Elapsed time: 0.014

select  count(*) COU from VW_ZY_LJ_MBYZXX a where  LJID00=119 and  RCID00=342  and KSTS00=2 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,187,0,a.ZLXMID)=1 


Error occurred: [1036] (ORA-01036: 非法的变量名/编号
)

--------------------------------------------------------------------------------
Timestamp: 2020/5/14 17:07:14

select  count(*) COU from VW_ZY_LJ_MBYZXX a where  LJID00=119 and  RCID00=342  and KSTS00=2 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,187,0,a.ZLXMID)=1 




Elapsed time: 0.014

select  count(*) COU from VW_ZY_LJ_MBYZXX a where  LJID00=119 and  RCID00=342  and KSTS00=3 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,187,0,a.ZLXMID)=1 


Error occurred: [1036] (ORA-01036: 非法的变量名/编号
)

--------------------------------------------------------------------------------
Timestamp: 2020/5/14 17:07:14

select  count(*) COU from VW_ZY_LJ_MBYZXX a where  LJID00=119 and  RCID00=342  and KSTS00=3 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,187,0,a.ZLXMID)=1 




Elapsed time: 0.014

select  count(*) COU from VW_ZY_LJ_MBYZXX a where  LJID00=119 and  RCID00=342  and KSTS00=4 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,187,0,a.ZLXMID)=1 


Error occurred: [1036] (ORA-01036: 非法的变量名/编号
)

--------------------------------------------------------------------------------
Timestamp: 2020/5/14 17:07:14

select  count(*) COU from VW_ZY_LJ_MBYZXX a where  LJID00=119 and  RCID00=342  and KSTS00=4 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,187,0,a.ZLXMID)=1 




Elapsed time: 0.017

select  count(*) COU from VW_ZY_LJ_MBYZXX a where  LJID00=119 and  RCID00=343  and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,187,0,a.ZLXMID)=1 


Error occurred: [1036] (ORA-01036: 非法的变量名/编号
)

--------------------------------------------------------------------------------
Timestamp: 2020/5/14 17:07:14

select  count(*) COU from VW_ZY_LJ_MBYZXX a where  LJID00=119 and  RCID00=343  and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,187,0,a.ZLXMID)=1 




Elapsed time: 0.015

select * from VW_ZY_LJ_MBKJXX  where LJID00=:1 and RCID00=:2   

 and KSTS00=1

 and LB0000=0

 order by LB0000,KSTS00,CLBZ00,YZXZLX,XH0000 


Error occurred: [1036] (ORA-01036: 非法的变量名/编号
)

--------------------------------------------------------------------------------
Timestamp: 2020/5/14 17:07:14

select * from VW_ZY_LJ_MBKJXX  where LJID00=0.119000000e+003 and RCID00=0.341000000e+003   

 and KSTS00=1

 and LB0000=0

 order by LB0000,KSTS00,CLBZ00,YZXZLX,XH0000 




:1=[0.119000000e+003]
:2=[0.341000000e+003]


Elapsed time: 0.023

select count(*) cou from BM_YGBM00 where YGBH00=1489 and instr(YGXZ00,'5')>0  


Error occurred: [1036] (ORA-01036: 非法的变量名/编号
)

--------------------------------------------------------------------------------
Timestamp: 2020/5/14 17:07:14

select count(*) cou from BM_YGBM00 where YGBH00=1489 and instr(YGXZ00,'5')>0  




Elapsed time: 0.002

select * from VW_ZY_LJ_MBKJXX  where LJID00=:1 and RCID00=:2   

 and KSTS00=1

 and LB0000=0

 order by LB0000,KSTS00,CLBZ00,YZXZLX,XH0000 


Error occurred: [1036] (ORA-01036: 非法的变量名/编号
)

--------------------------------------------------------------------------------
Timestamp: 2020/5/14 17:07:14

select * from VW_ZY_LJ_MBKJXX  where LJID00=0.119000000e+003 and RCID00=0.341000000e+003   

 and KSTS00=1

 and LB0000=0

 order by LB0000,KSTS00,CLBZ00,YZXZLX,XH0000 




:1=[0.119000000e+003]
:2=[0.341000000e+003]


Elapsed time: 0.023

select count(*) cou from BM_YGBM00 where YGBH00=1489 and instr(YGXZ00,'5')>0  


Error occurred: [1036] (ORA-01036: 非法的变量名/编号
)

--------------------------------------------------------------------------------
Timestamp: 2020/5/14 17:07:14

select count(*) cou from BM_YGBM00 where YGBH00=1489 and instr(YGXZ00,'5')>0  




Elapsed time: 0.002