1       09:51:50  Log started for: 药库管理系统
2       09:51:50  SQL Prepare: ORACLE -  Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.0.100','3',trim(PROGRAM)||'+'||'药库管理系统',SID,serial# ,'20091020','09:51:51','scott@9999:920DDF175205ABA3953E75BA4B816D64' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

3       09:51:50  SQL Execute: ORACLE -  Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.0.100','3',trim(PROGRAM)||'+'||'药库管理系统',SID,serial# ,'20091020','09:51:51','scott@9999:920DDF175205ABA3953E75BA4B816D64' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

4       09:51:50  SQL Data In: ORACLE - Rows affected = 1
5       09:51:50  SQL Prepare: ORACLE - Commit

6       09:51:50  SQL Execute: ORACLE - Commit

7       09:51:50  SQL Data In: ORACLE - Rows affected = 0
8       09:51:50  SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

9       09:51:50  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

10      09:51:50  SQL Prepare: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 

11      09:51:50  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 

12      09:51:50  SQL Prepare: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.0.100','3',trim(PROGRAM)||'+'||'药库管理系统',SID,serial# ,'20091020','09:51:51','sd_hospital@9999:15B76592AFE9786B1FDA5730FEF0304F' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

13      09:51:50  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.0.100','3',trim(PROGRAM)||'+'||'药库管理系统',SID,serial# ,'20091020','09:51:51','sd_hospital@9999:15B76592AFE9786B1FDA5730FEF0304F' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

14      09:51:50  SQL Data In: ORACLE - Rows affected = 1
15      09:51:50  SQL Prepare: ORACLE - Commit

16      09:51:50  SQL Execute: ORACLE - Commit

17      09:51:50  SQL Data In: ORACLE - Rows affected = 0
18      09:51:50  SQL Prepare: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='3'

19      09:51:50  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='3'

20      09:51:50  SQL Prepare: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 

21      09:51:50  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 

22      09:51:50  SQL Prepare: ORACLE - Select SYSDATE from Dual

23      09:51:50  SQL Execute: ORACLE - Select SYSDATE from Dual

24      09:51:50  SQL Prepare: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

25      09:51:50  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

26      09:51:50  SQL Prepare: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='3'

27      09:51:50  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='3'

28      09:51:50  SQL Prepare: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

29      09:51:50  SQL Execute: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

30      09:51:50  SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
Order by SYBZ00

31      09:51:50  SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
Order by SYBZ00

32      09:51:50  SQL Prepare: ORACLE -  Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and 
 BMXZ00 in ('6')
 and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='3'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999'))
 order by BH0000

33      09:51:50  SQL Execute: ORACLE -  Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and 
 BMXZ00 in ('6')
 and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='3'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999'))
 order by BH0000

34      09:51:51  SQL Prepare: ORACLE -  Select '0' as XTDM00 from dual where 
'9999'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'3' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999'))

35      09:51:51  SQL Execute: ORACLE -  Select '0' as XTDM00 from dual where 
'9999'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'3' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999'))

36      09:51:51  SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=636

37      09:51:51  SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=636

38      09:51:51  SQL Prepare: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

39      09:51:51  SQL Execute: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

40      09:51:51  SQL Prepare: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

41      09:51:51  SQL Execute: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

42      09:51:51  SQL Prepare: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

43      09:51:51  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

44      09:51:51  SQL Prepare: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

45      09:51:51  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

46      09:51:51  SQL Prepare: ORACLE -  select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 
 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where  AUDSID= userenv('SESSIONID'))

47      09:51:51  SQL Execute: ORACLE -  select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 
 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where  AUDSID= userenv('SESSIONID'))

48      09:51:51  SQL Prepare: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(484409,636,'3E03347A1BE045A','3',nvl('353178',' '),'192.168.0.100#13:49953@appYP_YK.exe+药库管理系统',478)

49      09:51:51  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(484409,636,'3E03347A1BE045A','3',nvl('353178',' '),'192.168.0.100#13:49953@appYP_YK.exe+药库管理系统',478)

50      09:51:51  SQL Data In: ORACLE - Rows affected = 1
51      09:51:51  SQL Prepare: ORACLE - Commit

52      09:51:51  SQL Execute: ORACLE - Commit

53      09:51:52  SQL Data In: ORACLE - Rows affected = 0
54      09:51:52  SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 478

55      09:51:52  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 478

56      09:51:52  SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222142'

57      09:51:52  SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222142'

58      09:51:52  SQL Prepare: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.0.100'

59      09:51:52  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.0.100'

60      09:51:52  SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG')

61      09:51:52  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG')

62      09:51:52  SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
478 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

63      09:51:52  SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
478 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

64      09:51:52  SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='3') and YXQ000>='20091020'

65      09:51:52  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='3') and YXQ000>='20091020'

66      09:51:52  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

67      09:51:52  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

68      09:51:52  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

69      09:51:52  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

70      09:51:52  SQL Prepare: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=478

71      09:51:52  SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=478

72      09:51:52  SQL Prepare: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS<>'VALID'

73      09:51:52  SQL Execute: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS<>'VALID'

74      09:51:52  SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS='VALID'

75      09:51:52  SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS='VALID'

76      09:51:52  SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME= 'TR_BM_YD0000_BFUPDDET' AND STATUS='VALID'

77      09:51:52  SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME= 'TR_BM_YD0000_BFUPDDET' AND STATUS='VALID'

78      09:51:52  SQL Prepare: ORACLE - select TRIGGER_NAME from user_triggers
 where  TRIGGER_NAME LIKE 'TR_YK_%' AND STATUS<>'ENABLED'

79      09:51:52  SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers
 where  TRIGGER_NAME LIKE 'TR_YK_%' AND STATUS<>'ENABLED'

80      09:51:52  SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_triggers
 where TRIGGER_NAME='TR_BM_YD0000_BFUPDDET' AND STATUS='ENABLED'

81      09:51:52  SQL Execute: ORACLE - select Count(*) as TR_NUM from user_triggers
 where TRIGGER_NAME='TR_BM_YD0000_BFUPDDET' AND STATUS='ENABLED'

82      09:51:52  SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 like 'YK_%' or NAME00 like 'YF_%' or NAME00 like 'ZS_%'

83      09:51:52  SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 like 'YK_%' or NAME00 like 'YF_%' or NAME00 like 'ZS_%'

84      09:51:52  SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00=636

85      09:51:52  SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=636

86      09:51:52  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='3' and (( 
636= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='3' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=636))))

87      09:51:52  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='3' and (( 
636= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='3' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=636))))

88      09:51:53  SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '3$%' and A.XTDM00='3' and trim(A.MKDM00)='3$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00

89      09:51:53  SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '3$%' and A.XTDM00='3' and trim(A.MKDM00)='3$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00

90      09:51:53  SQL Prepare: ORACLE - select count(*)  from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where  A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((636= 0) or (BZ0000<>'0'  and  MKDM00 in (select MKDM00 from XT_ZBQX00  where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=636))))  

91      09:51:53  SQL Execute: ORACLE - select count(*)  from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where  A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((636= 0) or (BZ0000<>'0'  and  MKDM00 in (select MKDM00 from XT_ZBQX00  where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=636))))  

92      09:51:53  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

93      09:51:53  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

94      09:51:53  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 
636= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=636))))

95      09:51:53  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 
636= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=636))))

96      09:51:53  SQL Prepare: ORACLE - SELECT LBMC00 FROM BM_YPLB00 where LBBH00='3' 

97      09:51:53  SQL Execute: ORACLE - SELECT LBMC00 FROM BM_YPLB00 where LBBH00='3' 

98      09:51:53  SQL Prepare: ORACLE - SELECT 'X' FROM VW_YK_YPKCXX 
 WHERE YKBMBH=478
 AND KCSL00<KCXX00 

99      09:51:53  SQL Execute: ORACLE - SELECT 'X' FROM VW_YK_YPKCXX 
 WHERE YKBMBH=478
 AND KCSL00<KCXX00 

100     09:52:06  SQL Prepare: ORACLE - SELECT * FROM BM_YKRKLX WHERE RKDLX0='Y'

101     09:52:06  SQL Execute: ORACLE - SELECT * FROM BM_YKRKLX WHERE RKDLX0='Y'

102     09:52:06  SQL Prepare: ORACLE - SELECT * FROM BM_FKFS00 

103     09:52:06  SQL Execute: ORACLE - SELECT * FROM BM_FKFS00 

104     09:52:06  SQL Prepare: ORACLE - SELECT YGBH00,ZWXM00 FROM BM_YGBM00 WHERE YGXZ00 like'%6%'

105     09:52:06  SQL Execute: ORACLE - SELECT YGBH00,ZWXM00 FROM BM_YGBM00 WHERE YGXZ00 like'%6%'

106     09:52:06  SQL Prepare: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('6') 
 and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='3' 
 and YGBH00=(select YGBH00 from BM_YGBM00 where Upper(XKH000)=Upper('9999')))

107     09:52:06  SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('6') 
 and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='3' 
 and YGBH00=(select YGBH00 from BM_YGBM00 where Upper(XKH000)=Upper('9999')))

108     09:52:06  SQL Prepare: ORACLE - Select ZBQNM0,ZBQMC0 from BM_ZBQZD0

109     09:52:06  SQL Execute: ORACLE - Select ZBQNM0,ZBQMC0 from BM_ZBQZD0

110     09:52:08  SQL Prepare: ORACLE - SELECT X.*,D.LBBH00,D.YPBM00 FROM YK_YPRKMX X,BM_YD0000 D 
WHERE X.YPNM00=D.YPNM00 AND X.RKDH00='' ORDER BY X.YPRKPC

111     09:52:08  SQL Execute: ORACLE - SELECT X.*,D.LBBH00,D.YPBM00 FROM YK_YPRKMX X,BM_YD0000 D 
WHERE X.YPNM00=D.YPNM00 AND X.RKDH00='' ORDER BY X.YPRKPC

112     09:52:11  SQL Prepare: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT'

113     09:52:11  SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT'

114     09:52:11  SQL Prepare: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KC0000,SFZBYP,PFJ000,SCCJZW,SCCJBH,YPJCL0,SPM000,ZBXH00,LBBH00,ZBQNM0,PZWH00 from VW_YK_YPSRTS where (PYSM00 Like :1 or YPBM00 Like :2) and( YKBMBH=478 )  Order By YPBM00,PYSM00) where Rownum<=10

115     09:52:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %%
116     09:52:12  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %%
117     09:52:12  SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KC0000,SFZBYP,PFJ000,SCCJZW,SCCJBH,YPJCL0,SPM000,ZBXH00,LBBH00,ZBQNM0,PZWH00 from VW_YK_YPSRTS where (PYSM00 Like ? or YPBM00 Like ?) and( YKBMBH=478 )  Order By YPBM00,PYSM00) where Rownum<=10