WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
IKANGRAC	295796415	ikangrac2	2	17-Sep-13 11:09	11.2.0.3.0	YES

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
rac2	Linux x86 64-bit	48	24	4	62.94

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	13749	25-Sep-13 10:00:08	319	1.2
End Snap:	13751	25-Sep-13 12:00:25	260	1.3
Elapsed:		120.28 (mins)
DB Time:		669.99 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	16,256M	16,256M	Std Block Size:	8K
Shared Pool Size:	18,432M	18,432M	Log Buffer:	96,108K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	5.6	0.9	0.01	0.00
DB CPU(s):	5.0	0.8	0.01	0.00
Redo size:	42,445.0	6,698.5
Logical reads:	431,253.0	68,058.8
Block changes:	3,240.0	511.3
Physical reads:	5,104.1	805.5
Physical writes:	50.0	7.9
User calls:	1,368.0	215.9
Parses:	437.6	69.1
Hard parses:	42.7	6.7
W/A MB processed:	19.5	3.1
Logons:	49.7	7.9
Executes:	566.4	89.4
Rollbacks:	0.4	0.1
Transactions:	6.3

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	99.99
Buffer Hit %:	99.98	In-memory Sort %:	100.00
Library Hit %:	90.54	Soft Parse %:	90.25
Execute to Parse %:	22.74	Latch Hit %:	99.72
Parse CPU to Parse Elapsd %:	87.12	% Non-Parse CPU:	91.69

Shared Pool Statistics

	Begin	End
Memory Usage %:	56.76	59.32
% SQL with executions>1:	82.66	80.15
% Memory for SQL w/exec>1:	80.38	76.18

Top 5 Timed Foreground Events

Host CPU (CPUs: 48 Cores: 24 Sockets: 4)

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
3.87	5.35	7.8	4.0	1.1	88.0

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
10.4	87.2	0.0

Memory Statistics

	Begin	End
Host Mem (MB):	64,446.8	64,446.8
SGA use (MB):	35,840.0	35,840.0
PGA use (MB):	982.3	978.1
% Host Mem used for SGA+PGA:	57.14	57.13

RAC Statistics

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

	Per Second	Per Transaction
Global Cache blocks received:	193.20	30.49
Global Cache blocks served:	185.38	29.26
GCS/GES messages received:	385.27	60.80
GCS/GES messages sent:	454.78	71.77
DBWR Fusion writes:	2.89	0.46
Estd Interconnect traffic (KB)	3,192.77

Global Cache Efficiency Percentages (Target local+remote 100%)

Buffer access - local cache %:	99.94
Buffer access - remote cache %:	0.05
Buffer access - disk %:	0.02

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms):	0.0
Avg global cache cr block receive time (ms):	0.5
Avg global cache current block receive time (ms):	0.9
Avg global cache cr block build time (ms):	0.0
Avg global cache cr block send time (ms):	0.0
Global cache log flushes for cr blocks served %:	0.6
Avg global cache cr block flush time (ms):	24.3
Avg global cache current block pin time (ms):	0.0
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.0
Avg global cache current block flush time (ms):	38.4

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms):	0.1
Avg message sent queue time on ksxp (ms):	0.9
Avg message received queue time (ms):	0.1
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	37.80
% of indirect sent messages:	61.95
% of flow controlled messages:	0.25

Cluster Interconnect

• if IP/Public/Source at End snap is different a '*' is displayed

Main Report

• Report Summary
• Wait Events Statistics
• SQL Statistics
• Instance Activity Statistics
• IO Stats
• Buffer Pool Statistics
• Advisory Statistics
• Wait Statistics
• Undo Statistics
• Latch Statistics
• Segment Statistics
• Dictionary Cache Statistics
• Library Cache Statistics
• Memory Statistics
• Streams Statistics
• Resource Limit Statistics
• Shared Server Statistics
• init.ora Parameters

More RAC Statistics

• RAC Report Summary
• Global Messaging Statistics
• Global CR Served Stats
• Global CURRENT Served Stats
• Global Cache Transfer Stats
• Interconnect Stats
• Dynamic Remastering Statistics

Wait Events Statistics

• Time Model Statistics
• Operating System Statistics
• Operating System Statistics - Detail
• Foreground Wait Class
• Foreground Wait Events
• Background Wait Events
• Wait Event Histogram
• Wait Event Histogram Detail (64 msec to 2 sec)
• Wait Event Histogram Detail (4 sec to 2 min)
• Wait Event Histogram Detail (4 min to 1 hr)
• Service Statistics
• Service Wait Class Stats

Time Model Statistics

• Total time in database user-calls (DB Time): 40199.6s
• Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
• Ordered by % or DB time desc, Statistic name

Back to Wait Events Statistics
Back to Top

Operating System Statistics

• *TIME statistic values are diffed. All others display actual values. End Value is displayed if different
• ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

• s - second, ms - millisecond - 1000th of a second
• ordered by wait time desc, waits desc
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
• Captured Time accounts for 108.8% of Total DB time 40,199.60 (s)
• Total FG Wait Time: 7,990.05 (s) DB CPU time: 35,733.36 (s)

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

• s - second, ms - millisecond - 1000th of a second
• Only events with Total Wait Time (s) >= .001 are shown
• ordered by wait time desc, waits desc (idle events last)
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Background Wait Events

• ordered by wait time desc, waits desc (idle events last)
• Only events with Total Wait Time (s) >= .001 are shown
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• % of Waits: value of .0 indicates value was <.05%; value of null is truly 0
• % of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
• Ordered by Event (idle events last)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
• % of Total Waits: total waits for all wait classes, including Idle
• % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
• Ordered by Event (only non-idle events are displayed)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)
• % of Total Waits: total waits for all wait classes, including Idle
• % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
• Ordered by Event (only non-idle events are displayed)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

• ordered by DB Time

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

• Wait Class info for services in the Service Statistics section.
• Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
• Time Waited (Wt Time) in seconds

Back to Wait Events Statistics
Back to Top

SQL Statistics

• SQL ordered by Elapsed Time
• SQL ordered by CPU Time
• SQL ordered by User I/O Wait Time
• SQL ordered by Gets
• SQL ordered by Reads
• SQL ordered by Physical Reads (UnOptimized)
• SQL ordered by Executions
• SQL ordered by Parse Calls
• SQL ordered by Sharable Memory
• SQL ordered by Version Count
• SQL ordered by Cluster Wait Time
• Complete List of SQL Text

SQL ordered by Elapsed Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
• %Total - Elapsed Time as a percentage of Total DB time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 41.0% of Total DB Time (s): 40,200
• Captured PL/SQL account for 1.7% of Total DB Time (s): 40,200

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - CPU Time as a percentage of Total DB CPU
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 43.1% of Total CPU Time (s): 35,733
• Captured PL/SQL account for 1.4% of Total CPU Time (s): 35,733

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - User I/O Time as a percentage of Total User I/O Wait time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 23.0% of Total User I/O Wait Time (s): 3,861
• Captured PL/SQL account for 4.1% of Total User I/O Wait Time (s): 3,861

Back to SQL Statistics
Back to Top

SQL ordered by Gets

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - Buffer Gets as a percentage of Total Buffer Gets
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Buffer Gets: 3,112,258,579
• Captured SQL account for 87.4% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• %Total - Physical Reads as a percentage of Total Disk Reads
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Disk Reads: 36,835,375
• Captured SQL account for 16.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

• UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
• %Opt - Optimized Reads as percentage of SQL Read Requests
• %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
• Total Physical Read Requests: 767,463
• Captured SQL account for 35.0% of Total
• Total UnOptimized Read Requests: 767,463
• Captured SQL account for 35.0% of Total
• Total Optimized Read Requests: 1
• Captured SQL account for 0.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Executions: 4,087,519
• Captured SQL account for 60.2% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 3,157,817
• Captured SQL account for 61.5% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

• Only Statements with Sharable Memory greater than 1048576 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

• Only Statements with Version Count greater than 20 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

• %Total - Cluster Time as a percentage of Total Cluster Wait Time
• %Clu - Cluster Time as a percentage of Elapsed Time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Only SQL with Cluster Wait Time > .005 seconds is reported
• Total Cluster Wait Time (s): 485
• Captured SQL account for 42.0% of Total

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
02z11bc0a4bav	SELECT SEQ_MIS_XML_INFO.NEXTVAL FROM DUAL
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0r41n4qbxkn70	select mismemberi0_.MEMBERID as MEMBERID151_0_, mismemberi0_.NAME as NAME151_0_, mismemberi0_.SEX as SEX151_0_, mismemberi0_.BIRTHDAY as BIRTHDAY151_0_, mismemberi0_.IDTYPE as IDTYPE151_0_, mismemberi0_.IDNUMBER as IDNUMBER151_0_, mismemberi0_.EDUDEGREE as EDUDEGREE151_0_, mismemberi0_.MARRIAGE as MARRIAGE151_0_, mismemberi0_.REGCITYCODE as REGCITYC9_151_0_, mismemberi0_.MEMCITYCODE as MEMCITY10_151_0_, mismemberi0_.ORGANID as ORGANID151_0_, mismemberi0_.IKANGORGID as IKANGORGID151_0_, mismemberi0_.MEMBERTYPE as MEMBERTYPE151_0_, mismemberi0_.MEMSTATUS as MEMSTATUS151_0_, mismemberi0_.MOBILE as MOBILE151_0_, mismemberi0_.POPFLAG as POPFLAG151_0_, mismemberi0_.EMAIL as EMAIL151_0_, mismemberi0_.FAMILYCALL as FAMILYCALL151_0_, mismemberi0_.WORKCALL as WORKCALL151_0_, mismemberi0_.FAX as FAX151_0_, mismemberi0_.ADDRESS as ADDRESS151_0_, mismemberi0_.POSTID as POSTID151_0_, mismemberi0_.LOGINNAME as LOGINNAME151_0_, mismemberi0_.LOGINPASSWD as LOGINPA24_151_0_, mismemberi0_.POSITION as POS
0vqu36hmy2n3u	select max(s.standardprice) standardprice, p.code from mis_project_quotation q, mis_project_package p, mis_project_package_org s, mis_organ_project o, jkcity.hospinfo h, jkcity.city t where o.p_id = to_char(q.presaleid) and p.quotationid = q.id and p.id = s.packageid and h.hospid = s.organid and p.disallowstatus = 1 and h.state=1 --and hospname not like '%???%' and h.hospid not in ('088', '104', '115', '203', '208', '335', '336', '337', '355', '411', '685', '998') and p.code not in ('NONEM268262', 'NONEM268239', 'NONEM268254', 'NONEF268253', 'NONEF268255', 'NONEF268256', 'NONEM325433', 'NONEF325437', 'NONEM334112', 'NONEF221811', 'NONEF221831', 'NONEF329659', 'NONEM329658', 'NONEM369769', 'NONEF369791') and ( p.code in('NONEM240026', 'NONEF240052', 'NONEM239926', 'NONEF239946', 'NONEM241734', 'NONEF241787', 'NONEM241559', 'NONEF241715', 'NONEF242421', 'NONEM242446', 'NONEF242610', 'NONEM2
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
1b0ku96jf6sv7	SELECT NAME2 AS DEPNAME, NAME, CLINICMEANING, CHECKDETAIL FROM (SELECT PC.NAME NAME2, P.NAME, P.CLINICMEANING , PC.SHOWINDEX, D.SHOWINDEX SHOWINDEX2, TO_CHAR(WMSYS.WM_CONCAT(T.NAME)) AS CHECKDETAIL FROM MIS_PROJECT_PACKAGEDETAIL O, PHYS_CHECKITEM_ORG C, PHYS_CHECKITEM P, PHYS_DEPTTYPE D, PHYS_CHECKTYPE PC, MIS_PROJECT_PACKAGE MP, MISNEW.PHYS_ITEMINDEX T, PHYS_ITEMINDEXRELATION T2 WHERE T.ID=T2.ITEMINDEXID AND T2.CHECKITEMID =P.ID AND O.PACKAGEID=MP.ID AND PC.ID = D.CHECKTYPEID AND D.ID = P.DEPTTYPEID AND O.CHECKITEMID = C.CHECKITEMID AND P.ID = O.CHECKITEMID AND O.CHECKITEMID = C.CHECKITEMID AND P.ID = O.CHECKITEMID AND P.STATUS != 2 AND C.ORGANID = :B2 AND MP.CODE=:B1 AND C.STATUS != 2 AND O.CHECKITEMID||'|'||ORGANID||'|'||PACKAGEID NOT IN (SELECT I.CHECKITEMID||'|'||ORGANID||'|'||PACKAGEID FROM MIS_PROJECT_ORG_ITEM I WHERE I.ORGANID = :B2 AND I.OPERATORTYPE = 0 ) GROUP BY PC.NAME, P.NAME, P.CLINICMEANING , PC.SHOWINDEX, D.SHOWINDEX UNION SELECT PC.NAME NAME2, P.NAME, P.CLINICMEANING , PC.SHOW
2143ykdr9qz2m	select distinct p.code, p.sexid, p.name from mis_project_quotation q, mis_project_package p, mis_organ_project o, jkcity.hospinfo h where o.p_id = to_char(q.presaleid) and p.quotationid = q.id and p.disallowstatus = 1 and h.state=1 --and hospname not like '%???%' and h.hospid not in ('088', '104', '115', '203', '208', '335', '336', '337', '355', '411', '685', '998') and p.name not like '%??%' and p.name like'????-???(%' and p.name not like'%vip' and p.name not like'%VIP' and p.sexid=0 and p.code not in ('NONEF252215', 'NONEF217807', 'NONEM217498', 'NONEM217833', 'NONEM217777', 'NONEM217749') and ( p.code in('NONEM240026', 'NONEF240052', 'NONEM239926', 'NONEF239946', 'NONEM241734', 'NONEF241787', 'NONEM241559', 'NONEF241715', 'NONEF242421', 'NONEM242446', 'NONEF242610', 'NONEM242550', 'NONEF239775', 'NONEM239786', 'NONEF239866', 'NONEM239771', 'NONEM238232', 'NONEF238290', 'NONEF238245', 'NONEF
2709hwfyhdh4v	select misproject0_.ID as ID207_, misproject0_.QUOTATIONID as QUOTATIO2_207_, misproject0_.TYPE as TYPE207_, misproject0_.PY as PY207_, misproject0_.NAME as NAME207_, misproject0_.GROUPNAME as GROUPNAME207_, misproject0_.CODE as CODE207_, misproject0_.SEXID as SEXID207_, misproject0_.AGE as AGE207_, misproject0_.AGEEND as AGEEND207_, misproject0_.AMOUNT as AMOUNT207_, misproject0_.STANDARDPRICE as STANDAR12_207_, misproject0_.CONTRACTPRICE as CONTRAC13_207_, misproject0_.REBATE as REBATE207_, misproject0_.TOTALPRICE as TOTALPRICE207_, misproject0_.DESCRIPTION as DESCRIP16_207_, misproject0_.STATUS as STATUS207_, misproject0_.OPERATORID as OPERATORID207_, misproject0_.MODIFIEDON as MODIFIEDON207_, misproject0_.IPADDRESS as IPADDRESS207_, misproject0_.NOTE as NOTE207_, misproject0_.MARRY as MARRY207_, misproject0_.SHOWINDEX as SHOWINDEX207_, misproject0_.DISALLOWSTATUS as DISALLO24_207_, misproject0_.PROMPTINFO as PROMPTINFO207_, misproject0_.PARTICULAR as PARTICULAR207_, misproject0_.SU
2q4w3br52bkka	select * from ( select mcb.ikangorgid, mmi.memberid, mmi.memcitycode, mmi.name, mmi.loginname, mmi.idtype, mmi.idnumber, mmi.mobile, mmi.sex, mmi.organid, mmc.cardnumber, mmc.assocard, mmi.membertype, mmi.operatorid, mmi.operatedate, mmi.socialinsurancenumber, mmi.registereddate, mci.stopflag, mmi.passport_id from Mis_Member_Info mmi left join Mis_Member_Card mmc on mmi.memberid=mmc.memberid , MIS_CARD_INFO mci , Mis_Card_Block mcb where (mmi.mobile = '13958056193' or mmi.familycall = '13958056193' or mmi.workcall = '13958056193') and mci.cardnumber=mmc.cardnumber and mci.blockid = mcb.blockid order by mmc.binddate desc ) where rownum <= :1
2rt7dy94565hv	select count(*) from Mis_Member_Info mmi left join Mis_Member_Card mmc on mmi.memberid=mmc.memberid , MIS_CARD_INFO mci , Mis_Card_Block mcb where mmi.name = '??' and mci.cardnumber=mmc.cardnumber and mci.blockid = mcb.blockid
2u2ygn7akuum2	select distinct p.code, p.sexid, p.name from mis_project_quotation q, mis_project_package p, mis_organ_project o, jkcity.hospinfo h where o.p_id = to_char(q.presaleid) and p.quotationid = q.id and p.disallowstatus = 1 and h.state=1 --and hospname not like '%???%' and h.hospid not in ('088', '104', '115', '203', '208', '335', '336', '337', '355', '411', '685', '998') and p.name not like '%??%' and p.name like'??????????%' and p.name not like'%vip' and p.name not like'%VIP' and p.sexid=1 and p.code not in ('NONEF252215', 'NONEF217807', 'NONEM217498', 'NONEM217833', 'NONEM217777', 'NONEM217749') and ( p.code in('NONEM240026', 'NONEF240052', 'NONEM239926', 'NONEF239946', 'NONEM241734', 'NONEF241787', 'NONEM241559', 'NONEF241715', 'NONEF242421', 'NONEM242446', 'NONEF242610', 'NONEM242550', 'NONEF239775', 'NONEM239786', 'NONEF239866', 'NONEM239771', 'NONEM238232', 'NONEF238290', 'NONEF238245', 'NONE
2u70dgw2q58xx	SELECT COUNT(*) FROM MIS_ORGAN_PROJECT WHERE UPPER(PROJECTID) =UPPER(TRIM(:B1 ))
2y3tdjhjz0bff	select distinct s.CONTRACTPRICE, p.code, p.sexid, p.name from mis_project_quotation q, mis_project_package p, mis_project_package_org s, mis_organ_project o, jkcity.hospinfo h, jkcity.city t where o.p_id = to_char(q.presaleid) and p.quotationid = q.id and p.id = s.packageid and h.hospid = s.organid and p.disallowstatus = 1 and h.state=1 --and hospname not like '%???%' and h.hospid not in ('088', '104', '115', '203', '208', '335', '336', '337', '355', '411', '685', '998') and p.code not in ('NONEM268262', 'NONEM268239', 'NONEM268254', 'NONEF268253', 'NONEF268255', 'NONEF268256', 'NONEM325433', 'NONEF325437', 'NONEM334112', 'NONEF221811', 'NONEF221831', 'NONEF329659', 'NONEM329658', 'NONEM369769', 'NONEF369791') and ( p.code in('NONEM240026', 'NONEF240052', 'NONEM239926', 'NONEF239946', 'NONEM241734', 'NONEF241787', 'NONEM241559', 'NONEF241715', 'NONEF242421', 'NONEM2424
31fvaa2b3ym84	select distinct s.CONTRACTPRICE, p.code, p.sexid, p.name from mis_project_quotation q, mis_project_package p, mis_project_package_org s, mis_organ_project o, jkcity.hospinfo h, jkcity.city t where o.p_id = to_char(q.presaleid) and p.quotationid = q.id and p.id = s.packageid and h.hospid = s.organid and p.disallowstatus = 1 and h.state=1 --and hospname not like '%???%' and h.hospid not in ('088', '104', '115', '203', '208', '335', '336', '337', '355', '411', '685', '998') and p.code not in ('NONEM268262', 'NONEM268239', 'NONEM268254', 'NONEF268253', 'NONEF268255', 'NONEF268256', 'NONEM325433', 'NONEF325437', 'NONEM334112', 'NONEF221811', 'NONEF221831', 'NONEF329659', 'NONEM329658', 'NONEM369769', 'NONEF369791') and ( p.code in('NONEM240026', 'NONEF240052', 'NONEM239926', 'NONEF239946', 'NONEM241734', 'NONEF241787', 'NONEM241559', 'NONEF241715', 'NONEF242421', 'NONEM2424
329268pwpqw6b	BEGIN PACK_TIJIAN.proc_get_project_list_extend(:1, :2, :3); END;
34hwvu2gswrys	select miscardinf0_.CARDNUMBER as CARDNUMBER33_0_, miscardinf0_.PASSWORD as PASSWORD33_0_, miscardinf0_.BLOCKID as BLOCKID33_0_, miscardinf0_.CARDUSESTATE as CARDUSES4_33_0_, miscardinf0_.ACTIVEFLAG as ACTIVEFLAG33_0_, miscardinf0_.OPERATOR as OPERATOR33_0_, miscardinf0_.OPERATEDATE as OPERATED7_33_0_, miscardinf0_.BALANCE as BALANCE33_0_, miscardinf0_.CARDLEVEL as CARDLEVEL33_0_, miscardinf0_.NOTE as NOTE33_0_, miscardinf0_.REGISTER_WAY as REGISTER11_33_0_, miscardinf0_.STOPFLAG as STOPFLAG33_0_, miscardinf0_.STOPFLAGNOTE as STOPFLA13_33_0_, miscardinf0_.LIFECYCLE as LIFECYCLE33_0_, miscardinf0_.SALESTATE as SALESTATE33_0_ from MISNEW.MIS_CARD_INFO miscardinf0_ where miscardinf0_.CARDNUMBER=:1
35axhs7dafkrc	select count(*) from Mis_Member_Info mmi left join Mis_Member_Card mmc on mmi.memberid=mmc.memberid , MIS_CARD_INFO mci , Mis_Card_Block mcb where lower(mmi.idnumber) = '310107196103212015' and mci.cardnumber=mmc.cardnumber and mci.blockid = mcb.blockid
3pqd69ykdr15x	select distinct p.code, p.sexid, p.name from mis_project_quotation q, mis_project_package p, mis_organ_project o, jkcity.hospinfo h where o.p_id = to_char(q.presaleid) and p.quotationid = q.id and p.disallowstatus = 1 and h.state=1 --and hospname not like '%???%' and h.hospid not in ('088', '104', '115', '203', '208', '335', '336', '337', '355', '411', '685', '998') and p.name not like '%??%' and p.name like'????????%' and p.name not like'%vip' and p.name not like'%VIP' and p.sexid=1 and p.code not in ('NONEF252215', 'NONEF217807', 'NONEM217498', 'NONEM217833', 'NONEM217777', 'NONEM217749') and ( p.code in('NONEM240026', 'NONEF240052', 'NONEM239926', 'NONEF239946', 'NONEM241734', 'NONEF241787', 'NONEM241559', 'NONEF241715', 'NONEF242421', 'NONEM242446', 'NONEF242610', 'NONEM242550', 'NONEF239775', 'NONEM239786', 'NONEF239866', 'NONEM239771', 'NONEM238232', 'NONEF238290', 'NONEF238245', 'NONEF2
3vbrvkbn9r73b	select distinct s.CONTRACTPRICE, p.code, p.sexid, p.name from mis_project_quotation q, mis_project_package p, mis_project_package_org s, mis_organ_project o, jkcity.hospinfo h, jkcity.city t where o.p_id = to_char(q.presaleid) and p.quotationid = q.id and p.id = s.packageid and h.hospid = s.organid and p.disallowstatus = 1 and h.state=1 --and hospname not like '%???%' and h.hospid not in ('088', '104', '115', '203', '208', '335', '336', '337', '355', '411', '685', '998') and p.code not in ('NONEM268262', 'NONEM268239', 'NONEM268254', 'NONEF268253', 'NONEF268255', 'NONEF268256', 'NONEM325433', 'NONEF325437', 'NONEM334112', 'NONEF221811', 'NONEF221831', 'NONEF329659', 'NONEM329658', 'NONEM369769', 'NONEF369791') and ( p.code in('NONEM240026', 'NONEF240052', 'NONEM239926', 'NONEF239946', 'NONEM241734', 'NONEF241787', 'NONEM241559', 'NONEF241715', 'NONEF242421', 'NONEM2424
3y9uw3krsxv63	SELECT COUNT(*) AS COUNT FROM area
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
4abppf93tbgwf	select distinct p.code, p.sexid, p.name from mis_project_quotation q, mis_project_package p, mis_organ_project o, jkcity.hospinfo h where o.p_id = to_char(q.presaleid) and p.quotationid = q.id and p.disallowstatus = 1 and h.state=1 --and hospname not like '%???%' and h.hospid not in ('088', '104', '115', '203', '208', '335', '336', '337', '355', '411', '685', '998') and p.name not like '%??%' and p.name like'????-????(%' and p.name not like'%vip' and p.name not like'%VIP' and p.sexid=1 and p.code not in ('NONEF252215', 'NONEF217807', 'NONEM217498', 'NONEM217833', 'NONEM217777', 'NONEM217749') and ( p.code in('NONEM240026', 'NONEF240052', 'NONEM239926', 'NONEF239946', 'NONEM241734', 'NONEF241787', 'NONEM241559', 'NONEF241715', 'NONEF242421', 'NONEM242446', 'NONEF242610', 'NONEM242550', 'NONEF239775', 'NONEM239786', 'NONEF239866', 'NONEM239771', 'NONEM238232', 'NONEF238290', 'NONEF238245', 'NONE
4b0h3hxkawq1c	select max(s.standardprice) standardprice, p.code from mis_project_quotation q, mis_project_package p, mis_project_package_org s, mis_organ_project o, jkcity.hospinfo h, jkcity.city t where o.p_id = to_char(q.presaleid) and p.quotationid = q.id and p.id = s.packageid and h.hospid = s.organid and p.disallowstatus = 1 and h.state=1 --and hospname not like '%???%' and h.hospid not in ('088', '104', '115', '203', '208', '335', '336', '337', '355', '411', '685', '998') and p.code not in ('NONEM268262', 'NONEM268239', 'NONEM268254', 'NONEF268253', 'NONEF268255', 'NONEF268256', 'NONEM325433', 'NONEF325437', 'NONEM334112', 'NONEF221811', 'NONEF221831', 'NONEF329659', 'NONEM329658', 'NONEM369769', 'NONEF369791') and ( p.code in('NONEM240026', 'NONEF240052', 'NONEM239926', 'NONEF239946', 'NONEM241734', 'NONEF241787', 'NONEM241559', 'NONEF241715', 'NONEF242421', 'NONEM242446', 'NONEF242610', 'NONEM2
4wyhudxgbf229	SELECT COUNT(*) FROM MISNEW.MIS_PROJECT_QUOTATION WHERE PRESALEID=( SELECT MIN(P_ID) FROM MISNEW.MIS_ORGAN_PROJECT WHERE UPPER(PROJECTID) =UPPER(TRIM(:B1 )))
522jrhr4ytdwn	select max(s.standardprice) standardprice, p.code from mis_project_quotation q, mis_project_package p, mis_project_package_org s, mis_organ_project o, jkcity.hospinfo h where o.p_id = to_char(q.presaleid) and p.quotationid = q.id and p.id = s.packageid and h.hospid = s.organid and p.disallowstatus = 1 and h.state=1 and hospname not like '%???%' -- and h.hospid != '000' and ( p.code in('NONEM240026', 'NONEF240052', 'NONEM239926', 'NONEF239946', 'NONEM241734', 'NONEF241787', 'NONEM241559', 'NONEF241715', 'NONEF242421', 'NONEM242446', 'NONEF242610', 'NONEM242550', 'NONEF239775', 'NONEM239786', 'NONEF239866', 'NONEM239771', 'NONEM238232', 'NONEF238290', 'NONEF238245', 'NONEF238239', 'NONEF238308', 'NONEM238468', 'NONEM238340', 'NONEM238356', 'NONEF238406', 'NONEF238426', 'NONEM238667', 'NONEM238572', 'NONEM238588', 'NONEF238589', 'NONEF238484', 'NONEM238646', 'NONEM238668', 'NONEF238688', 'NONEF238687', 'NONEM238690'
560cmud9dwzv1	select * from ( select mcb.ikangorgid, mmi.memberid, mmi.memcitycode, mmi.name, mmi.loginname, mmi.idtype, mmi.idnumber, mmi.mobile, mmi.sex, mmi.organid, mmc.cardnumber, mmc.assocard, mmi.membertype, mmi.operatorid, mmi.operatedate, mmi.socialinsurancenumber, mmi.registereddate, mci.stopflag, mmi.passport_id from Mis_Member_Info mmi left join Mis_Member_Card mmc on mmi.memberid=mmc.memberid , MIS_CARD_INFO mci , Mis_Card_Block mcb where lower(mmi.idnumber) = '110108198405013722' and mci.cardnumber=mmc.cardnumber and mci.blockid = mcb.blockid order by mmc.binddate desc ) where rownum <= :1
5f5k32drp8mpg	UPDATE MIS_EXAM_RECORD SET CONFIRM_STATE = TO_NUMBER(:B6 ), REFUSED_CAUSE = :B5 , OPERID = :B4 , OPERNAME = SUBSTR(:B3 , 1, 10), IPADDRESS = :B2 , OPTIME = SYSDATE WHERE ID = TO_NUMBER(:B1 )
5u86qwcrjdq0b	SELECT PROJECTID , RETURNCARDTIMEFLAG, RECOMFLAG, GROUPCHECKREP, DOWNEREPORTFLAG, REOPRTFLAG FROM MIS_ORGAN_PROJECT WHERE UPPER(PROJECTID) =UPPER(TRIM(:B1 ))
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
5zmd2jy3gk7sg	select count(*) from Mis_Member_Info mmi left join Mis_Member_Card mmc on mmi.memberid=mmc.memberid , MIS_CARD_INFO mci , Mis_Card_Block mcb where mmi.name = '???' and mci.cardnumber=mmc.cardnumber and mci.blockid = mcb.blockid
68ruun532gbr2	select * from ( select misproject0_.ID as col_0_0_, misproject0_.CODE as col_1_0_, misproject0_.NAME as col_2_0_, misproject0_.OPERATORID as col_3_0_, misproject1_.STATUS as col_4_0_, misproject0_.MODIFIEDON as col_5_0_, misproject1_.CONTRACTID as col_6_0_ from MISNEW.MIS_PROJECT_PRESALE misproject0_, MISNEW.MIS_PROJECT_QUOTATION misproject1_ where misproject0_.ID=misproject1_.PRESALEID and (misproject0_.ID in (select misproject2_.FID from MISNEW.MIS_PROJECT_MEMBER misproject2_, MISNEW.MIS_PROJECT_PERSON misproject3_ where misproject2_.PERSONID=misproject3_.ID and misproject3_.USERLEVEL=8 and misproject3_.TYPE=1 and (misproject3_.FID=0 or misproject3_.FID in (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 ,
6hsgqzp4ywb24	select distinct p.code, p.sexid, p.name from mis_project_quotation q, mis_project_package p, mis_organ_project o, jkcity.hospinfo h where o.p_id = to_char(q.presaleid) and p.quotationid = q.id and p.disallowstatus = 1 and h.state=1 --and hospname not like '%???%' and h.hospid not in ('088', '104', '115', '203', '208', '335', '336', '337', '355', '411', '685', '998') and p.name not like '%??%' and p.name like'??????%' and p.name not like'%vip' and p.name not like'%VIP' and p.sexid=0 and p.code not in ('NONEF252215', 'NONEF217807', 'NONEM217498', 'NONEM217833', 'NONEM217777', 'NONEM217749') and ( p.code in('NONEM240026', 'NONEF240052', 'NONEM239926', 'NONEF239946', 'NONEM241734', 'NONEF241787', 'NONEM241559', 'NONEF241715', 'NONEF242421', 'NONEM242446', 'NONEF242610', 'NONEM242550', 'NONEF239775', 'NONEM239786', 'NONEF239866', 'NONEM239771', 'NONEM238232', 'NONEF238290', 'NONEF238245', 'NONEF238
6mr2gc0kqh5j5	select vwmisproje0_.ID as ID247_, vwmisproje0_.QUOTATIONID as QUOTATIO2_247_, vwmisproje0_.ACTION as ACTION247_, vwmisproje0_.NAME as NAME247_, vwmisproje0_.CODE as CODE247_, vwmisproje0_.NOTE as NOTE247_, vwmisproje0_.OPERATORID as OPERATORID247_, vwmisproje0_.MODIFIEDON as MODIFIEDON247_, vwmisproje0_.VERSION as VERSION247_ from MISNEW.VW_MIS_PROJECT_TRACE vwmisproje0_ where vwmisproje0_.CODE in (select misproject1_.CODE from MISNEW.MIS_PROJECT_PACKAGE misproject1_ where misproject1_.QUOTATIONID=:1) or vwmisproje0_.QUOTATIONID=:2 and (vwmisproje0_.CODE is null)
6xvaj7rn4n0gr	select distinct s.CONTRACTPRICE, p.code, p.sexid, p.name from mis_project_quotation q, mis_project_package p, mis_project_package_org s, mis_organ_project o, jkcity.hospinfo h where o.p_id = to_char(q.presaleid) and p.quotationid = q.id and p.id = s.packageid and h.hospid = s.organid and p.disallowstatus = 1 and h.state=1 and hospname not like '%???%' and ( p.code in('NONEM240026', 'NONEF240052', 'NONEM239926', 'NONEF239946', 'NONEM241734', 'NONEF241787', 'NONEM241559', 'NONEF241715', 'NONEF242421', 'NONEM242446', 'NONEF242610', 'NONEM242550', 'NONEF239775', 'NONEM239786', 'NONEF239866', 'NONEM239771', 'NONEM238232', 'NONEF238290', 'NONEF238245', 'NONEF238239', 'NONEF238308', 'NONEM238468', 'NONEM238340', 'NONEM238356', 'NONEF238406', 'NONEF238426', 'NONEM238667', 'NONEM238572', 'NONEM238588', 'NONEF238589', 'NONEF238484', 'NONEM238646', 'NONEM238668', 'NONEF238688', 'NONEF238687', 'NONEM238690', 'NO
78qnqfudkns3s	select cartlinein0_.CART_LINE_ID as CART15_1_, cartlinein0_.ID as ID1_, cartlinein0_.ID as ID384_0_, cartlinein0_.CART_ID as CART2_384_0_, cartlinein0_.CHECK_ITEM_ID as CHECK3_384_0_, cartlinein0_.CHECK_ITEM_CODE as CHECK4_384_0_, cartlinein0_.CHECK_ITEM_NAME as CHECK5_384_0_, cartlinein0_.MONEY as MONEY384_0_, cartlinein0_.SALE_PRICE as SALE7_384_0_, cartlinein0_.MARKET_PRICE as MARKET8_384_0_, cartlinein0_.ITEM_STATUS as ITEM9_384_0_, cartlinein0_.P_ITEM_ID as P10_384_0_, cartlinein0_.P_ITEM_CODE as P11_384_0_, cartlinein0_.NOTE as NOTE384_0_, cartlinein0_.ORDER_ID as ORDER13_384_0_, cartlinein0_.ORDER_STATE as ORDER14_384_0_, cartlinein0_.CART_LINE_ID as CART15_384_0_ from MISNEW.MIS_SALES_CART_LINE_INFO cartlinein0_ where cartlinein0_.CART_LINE_ID=:1
7axdbwnjtmfnk	SELECT CONTRACTID FROM MIS_CARD_BLOCK WHERE BLOCKID =( SELECT BLOCKID FROM MIS_CARD_INFO WHERE CARDNUMBER=:B1 )
7fj9vpm2zhgpg	select s.* from (select t.*, rownum as limi from (select x.ID, x.CREATOR, to_char(x.REGDATE, 'YYYY-mm-dd') as REGDATE, x.HOSPID, x.HOSPNAME, x.SOURCEID, x.SOURCENAME, x.MARKET_PRICE, x.REAL_PRICE, x.PAYWAY, to_char(x.CHECKDATE, 'YYYY-mm-dd') as CHECKDATE, x.FEEFLAG, x.PROJECTID, a.PROJECTNAME, x.CONFIRM_STATE, x.CARDID, x.USERNAME, x.OTHERCARDID, to_char(x.CREATOR_TIME, 'YYYY-mm-dd HH24:mi:ss') as CREATOR_TIME, x.EXAM_USER_BELONG, x.ORGAN_NAME, x.CONTACTTEL, x.CONTACTT
7g6j5xugpz8cc	select * from (select id, mobile, pipeid, sms_content, send_time from sms_wait_queue where pipeid='3' and (SEND_TIME <sysdate or SEND_TIME is null ) and (sysdate-createdon)*24<=24 and ishandle=1 and COMMIT_FLAG=0 and (length(mobile)>=11 and length(mobile)<=13) and sms_content is not null and ( MSGID <>'-1' or msgid is null) order by PRIORITY, sms_content) smsq where rownum<=50
7s35bdm0ykcqd	BEGIN PACK_TIJIAN.proc_get_project_list_formis(:1, :2, :3); END;
7tjmhydpck4um	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN proc_update_checkstatus; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
85dwygnxypaw7	select s.* from (select t.*, rownum as limi from (select x.ID, x.CREATOR, to_char(x.REGDATE, 'YYYY-mm-dd') as REGDATE, x.HOSPID, x.HOSPNAME, x.SOURCEID, x.SOURCENAME, x.MARKET_PRICE, x.REAL_PRICE, x.PAYWAY, to_char(x.CHECKDATE, 'YYYY-mm-dd') as CHECKDATE, x.FEEFLAG, x.PROJECTID, a.PROJECTNAME, x.CONFIRM_STATE, x.CARDID, x.USERNAME, x.OTHERCARDID, to_char(x.CREATOR_TIME, 'YYYY-mm-dd HH24:mi:ss') as CREATOR_TIME, x.EXAM_USER_BELONG, x.ORGAN_NAME, x.CONTACTTEL, x.CONTACTT
8ag935mnx8t1k	select distinct s.CONTRACTPRICE, p.code, p.sexid, p.name from mis_project_quotation q, mis_project_package p, mis_project_package_org s, mis_organ_project o, jkcity.hospinfo h, jkcity.city t where o.p_id = to_char(q.presaleid) and p.quotationid = q.id and p.id = s.packageid and h.hospid = s.organid and p.disallowstatus = 1 and h.state=1 --and hospname not like '%???%' and h.hospid not in ('088', '104', '115', '203', '208', '335', '336', '337', '355', '411', '685', '998') and p.code not in ('NONEM268262', 'NONEM268239', 'NONEM268254', 'NONEF268253', 'NONEF268255', 'NONEF268256', 'NONEM325433', 'NONEF325437', 'NONEM334112', 'NONEF221811', 'NONEF221831', 'NONEF329659', 'NONEM329658', 'NONEM369769', 'NONEF369791') and ( p.code in('NONEM240026', 'NONEF240052', 'NONEM239926', 'NONEF239946', 'NONEM241734', 'NONEF241787', 'NONEM241559', 'NONEF241715', 'NONEF242421', 'NONEM2424
8gzgz872gvyzv	select * from ( select mcb.ikangorgid, mmi.memberid, mmi.memcitycode, mmi.name, mmi.loginname, mmi.idtype, mmi.idnumber, mmi.mobile, mmi.sex, mmi.organid, mmc.cardnumber, mmc.assocard, mmi.membertype, mmi.operatorid, mmi.operatedate, mmi.socialinsurancenumber, mmi.registereddate, mci.stopflag, mmi.passport_id from Mis_Member_Info mmi left join Mis_Member_Card mmc on mmi.memberid=mmc.memberid , MIS_CARD_INFO mci , Mis_Card_Block mcb where lower(mmi.idnumber) = '150302197901194011' and mci.cardnumber=mmc.cardnumber and mci.blockid = mcb.blockid order by mmc.binddate desc ) where rownum <= :1
8jwscu286dww2	select distinct p.code, p.sexid, p.name from mis_project_quotation q, mis_project_package p, mis_organ_project o, jkcity.hospinfo h where o.p_id = to_char(q.presaleid) and p.quotationid = q.id and p.disallowstatus = 1 and h.state=1 --and hospname not like '%???%' and h.hospid not in ('088', '104', '115', '203', '208', '335', '336', '337', '355', '411', '685', '998') and p.name not like '%??%' and p.name like'????????%' and p.name not like'%vip' and p.name not like'%VIP' and p.sexid=0 and p.code not in ('NONEF252215', 'NONEF217807', 'NONEM217498', 'NONEM217833', 'NONEM217777', 'NONEM217749') and ( p.code in('NONEM240026', 'NONEF240052', 'NONEM239926', 'NONEF239946', 'NONEM241734', 'NONEF241787', 'NONEM241559', 'NONEF241715', 'NONEF242421', 'NONEM242446', 'NONEF242610', 'NONEM242550', 'NONEF239775', 'NONEM239786', 'NONEF239866', 'NONEM239771', 'NONEM238232', 'NONEF238290', 'NONEF238245', 'NONEF2
8ngb7t9u2ptr2	select count(*) from Mis_Member_Info mmi left join Mis_Member_Card mmc on mmi.memberid=mmc.memberid , MIS_CARD_INFO mci , Mis_Card_Block mcb where mci.cardnumber=mmc.cardnumber and mci.blockid = mcb.blockid
8phznb5fhhagj	select * from ( select misproject0_.ID as col_0_0_, misproject0_.CODE as col_1_0_, misproject0_.NAME as col_2_0_, misproject0_.OPERATORID as col_3_0_, misproject1_.STATUS as col_4_0_, misproject0_.MODIFIEDON as col_5_0_, misproject1_.CONTRACTID as col_6_0_ from MISNEW.MIS_PROJECT_PRESALE misproject0_, MISNEW.MIS_PROJECT_QUOTATION misproject1_ where misproject0_.ID=misproject1_.PRESALEID and (misproject0_.ID in (select misproject2_.FID from MISNEW.MIS_PROJECT_MEMBER misproject2_, MISNEW.MIS_PROJECT_PERSON misproject3_ where misproject2_.PERSONID=misproject3_.ID and misproject3_.USERLEVEL=8 and misproject3_.TYPE=1 and (misproject3_.FID=0 or misproject3_.FID in (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 ,
8ww248sdsna8f	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN proc_execute_group_job; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
8xkkzgtdxkugw	select distinct p.code, p.sexid, p.name from mis_project_quotation q, mis_project_package p, mis_organ_project o, jkcity.hospinfo h where o.p_id = to_char(q.presaleid) and p.quotationid = q.id and p.disallowstatus = 1 and h.state=1 --and hospname not like '%???%' and h.hospid not in ('088', '104', '115', '203', '208', '335', '336', '337', '355', '411', '685', '998') and p.name not like '%??%' and p.name like'???????%' and p.name not like'%vip' and p.name not like'%VIP' and p.sexid=0 and p.code not in ('NONEF252215', 'NONEF217807', 'NONEM217498', 'NONEM217833', 'NONEM217777', 'NONEM217749') and ( p.code in('NONEM240026', 'NONEF240052', 'NONEM239926', 'NONEF239946', 'NONEM241734', 'NONEF241787', 'NONEM241559', 'NONEF241715', 'NONEF242421', 'NONEM242446', 'NONEF242610', 'NONEM242550', 'NONEF239775', 'NONEM239786', 'NONEF239866', 'NONEM239771', 'NONEM238232', 'NONEF238290', 'NONEF238245', 'NONEF23
8xx4ad8g0545u	SELECT TO_CHAR(NVL(ENDDATE, SYSDATE+90), 'yyyy-mm-dd') FROM MISNEW.MIS_PROJECT_QUOTATION WHERE PRESALEID=( SELECT MIN(P_ID) FROM MISNEW.MIS_ORGAN_PROJECT WHERE UPPER(PROJECTID) =UPPER(TRIM(:B1 )))
97d1v1020vjzw	SELECT NVL(T7.CODE, T2.ID) AS PACKAGE_ID, T4.PROJECTID, PACKAGE_NAME, T7.ID, T7.VERSION, T3.HOSPID, T3.MEDPROP, 0 AS MARKET_PRICE, 0 AS REAL_PRICE, T3.HOSPNAME, T3.AREAID, T5.AREANAME, T7.AGE, T7.SEXID, T7.MARRY, T3.ORDER_ID, SUM(DECODE(T4.MAX_NUM, -1, 0, T4.MAX_NUM)-NVL(T4.USED_NUM, 0)) NUM FROM MIS_CHECKORGAN_CONSTRAIN T, MIS_BLOCK_PACKAGE T2, JKCITY.HOSPINFO T3, MIS_EXAM_CENTER_ALLOCATE T4, JKCITY.AREA T5, MIS_SERVICE_HOSPTYPE_CONN T6, (SELECT * FROM MIS_PROJECT_PACKAGE WHERE DISALLOWSTATUS=1) T7 WHERE T.BLOCK_PACKAGE_ID = T2.ID AND T3.STATE = 1 AND T3.REMOTEOPEN = T6.HOSPTYPE_ID AND T3.HOSPID = CHECKORGAN_ID AND T3.HOSPID = T4.HOSPID AND T4.PROJECTID = '000' AND T3.AREAID = T5.AREAID AND BLOCK_ID = :B2 AND T2.SERVICE_TYPE=T6.SERVICE_CATEGORY_ID AND T6.SERVICE_CATEGORY_ID=TO_NUMBER(:B1 ) AND T7.ID(+)=T2.PACKAGE_ID GROUP BY NVL(T7.CODE, T2.ID) , T4.PROJECTID, PACKAGE_NAME, T7.ID, T7.VERSION, T3.HOSPID, T3.HOSPNAME, T3.MEDPROP, T3.AREAID, T5.AREANAME, T7.AGE, T7.SEXID, T7.MARRY, T3.ORDER_ID ORDER BY T3.
99sw64ccytg0r	update sms_wait_queue set ISHANDLE=1 , COMMIT_FLAG=4 where pipeid='3' and (SEND_TIME <sysdate or SEND_TIME is null ) and (sysdate-createdon)*24<=24 and ishandle=1 and COMMIT_FLAG=0 and (length(mobile)>=11 and length(mobile)<=13) and sms_content is not null and ( MSGID <>'-1' or msgid is null) and rownum<=50
9h1mcyjubdpa6	SELECT AREAID, AREANAME FROM area ORDER BY AREAID ASC
9kbsvfyrr07bb	SELECT MAX(ID), TO_CHAR(CREATEDON, 'yyyymmddhh24miss') FROM MIS_XML_INFO WHERE KEYWORDS=:B2 AND TYPE=:B1 GROUP BY TO_CHAR(CREATEDON, 'yyyymmddhh24miss')
9kq8avh3jmh55	select count(*) as col_0_0_ from MISNEW.MIS_PROJECT_PRESALE misproject0_, MISNEW.MIS_PROJECT_QUOTATION misproject1_ where misproject0_.ID=misproject1_.PRESALEID and (misproject0_.ID in (select misproject2_.FID from MISNEW.MIS_PROJECT_MEMBER misproject2_, MISNEW.MIS_PROJECT_PERSON misproject3_ where misproject2_.PERSONID=misproject3_.ID and misproject3_.USERLEVEL=8 and misproject3_.TYPE=1 and (misproject3_.FID=0 or misproject3_.FID in (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 ,
9vcb3vz56q8fa	SELECT TO_CHAR(STARTDATE, 'yyyy-mm-dd'), TO_CHAR(ENDDATE, 'yyyy-mm-dd') FROM MISNEW.MIS_PROJECT_QUOTATION WHERE PRESALEID=( SELECT MIN(P_ID) FROM MISNEW.MIS_ORGAN_PROJECT WHERE UPPER(PROJECTID) =UPPER(TRIM(:B1 )))
a96uffqrkdds0	select max(s.standardprice) standardprice, p.code from mis_project_quotation q, mis_project_package p, mis_project_package_org s, mis_organ_project o, jkcity.hospinfo h, jkcity.city t where o.p_id = to_char(q.presaleid) and p.quotationid = q.id and p.id = s.packageid and h.hospid = s.organid and p.disallowstatus = 1 and h.state=1 --and hospname not like '%???%' and h.hospid not in ('088', '104', '115', '203', '208', '335', '336', '337', '355', '411', '685', '998') and p.code not in ('NONEM268262', 'NONEM268239', 'NONEM268254', 'NONEF268253', 'NONEF268255', 'NONEF268256', 'NONEM325433', 'NONEF325437', 'NONEM334112', 'NONEF221811', 'NONEF221831', 'NONEF329659', 'NONEM329658', 'NONEM369769', 'NONEF369791') and ( p.code in('NONEM240026', 'NONEF240052', 'NONEM239926', 'NONEF239946', 'NONEM241734', 'NONEF241787', 'NONEM241559', 'NONEF241715', 'NONEF242421', 'NONEM242446', 'NONEF242610', 'NONEM2
ap2p5ynujmq4t	select distinct p.code, p.sexid, p.name from mis_project_quotation q, mis_project_package p, mis_organ_project o, jkcity.hospinfo h where o.p_id = to_char(q.presaleid) and p.quotationid = q.id and p.disallowstatus = 1 and h.state=1 --and hospname not like '%???%' and h.hospid not in ('088', '104', '115', '203', '208', '335', '336', '337', '355', '411', '685', '998') and p.name not like '%??%' and p.name like'?????-???????%' and p.name not like'%vip' and p.name not like'%VIP' and p.sexid=1 and p.code not in ('NONEF252215', 'NONEF217807', 'NONEM217498', 'NONEM217833', 'NONEM217777', 'NONEM217749') and ( p.code in('NONEM240026', 'NONEF240052', 'NONEM239926', 'NONEF239946', 'NONEM241734', 'NONEF241787', 'NONEM241559', 'NONEF241715', 'NONEF242421', 'NONEM242446', 'NONEF242610', 'NONEM242550', 'NONEF239775', 'NONEM239786', 'NONEF239866', 'NONEM239771', 'NONEM238232', 'NONEF238290', 'NONEF238245', 'N
arudmm3d3hpap	select * from ( select mcb.ikangorgid, mmi.memberid, mmi.memcitycode, mmi.name, mmi.loginname, mmi.idtype, mmi.idnumber, mmi.mobile, mmi.sex, mmi.organid, mmc.cardnumber, mmc.assocard, mmi.membertype, mmi.operatorid, mmi.operatedate, mmi.socialinsurancenumber, mmi.registereddate, mci.stopflag, mmi.passport_id from Mis_Member_Info mmi left join Mis_Member_Card mmc on mmi.memberid=mmc.memberid , MIS_CARD_INFO mci , Mis_Card_Block mcb where lower(mmi.idnumber) = '310107196103212015' and mci.cardnumber=mmc.cardnumber and mci.blockid = mcb.blockid order by mmc.binddate desc ) where rownum <= :1
as2k26rrgtmr5	select distinct p.code, p.sexid, p.name from mis_project_quotation q, mis_project_package p, mis_organ_project o, jkcity.hospinfo h where o.p_id = to_char(q.presaleid) and p.quotationid = q.id and p.disallowstatus = 1 and h.state=1 --and hospname not like '%???%' and h.hospid not in ('088', '104', '115', '203', '208', '335', '336', '337', '355', '411', '685', '998') and p.name not like '%??%' and p.name like'????-???(%' and p.name not like'%vip' and p.name not like'%VIP' and p.sexid=1 and p.code not in ('NONEF252215', 'NONEF217807', 'NONEM217498', 'NONEM217833', 'NONEM217777', 'NONEM217749') and ( p.code in('NONEM240026', 'NONEF240052', 'NONEM239926', 'NONEF239946', 'NONEM241734', 'NONEF241787', 'NONEM241559', 'NONEF241715', 'NONEF242421', 'NONEM242446', 'NONEF242610', 'NONEM242550', 'NONEF239775', 'NONEM239786', 'NONEF239866', 'NONEM239771', 'NONEM238232', 'NONEF238290', 'NONEF238245', 'NONEF
au7f6hpnhxpkx	select ts# from ts$ where dflmaxext =:1 and bitand(flags, 1024) =1024 and online$=1
auzyz75gq7tr4	select miscorpora0_.ORGAN_ID as col_0_0_, miscorpora0_.ORGAN_NAME as col_1_0_, miscorpora0_.ORGAN_TYPE as col_2_0_, miscorpora0_.CITY_ID as col_3_0_ from MIS2.ORGAN miscorpora0_ where ( miscorpora0_.ENABLED=1 AND miscorpora0_.ORGAN_TYPE=6) order by nlssort(miscorpora0_.ORGAN_NAME, 'NLS_SORT=SCHINESE_PINYIN_M')
c79qvpru8cxt8	update sms_wait_queue set ISHANDLE=1 where pipeid='3' and (SEND_TIME <sysdate or SEND_TIME is null ) and (sysdate-createdon)*24<=24 and ishandle=0 and COMMIT_FLAG=0 and (length(mobile)>=11 and length(mobile)<=13) and sms_content is not null and ( MSGID <>'-1' or msgid is null) and rownum<=50
cm5vu20fhtnq1	select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cv8c4fb0sjq1t	select max(s.standardprice) standardprice, p.code from mis_project_quotation q, mis_project_package p, mis_project_package_org s, mis_organ_project o, jkcity.hospinfo h, jkcity.city t where o.p_id = to_char(q.presaleid) and p.quotationid = q.id and p.id = s.packageid and h.hospid = s.organid and p.disallowstatus = 1 and h.state=1 --and hospname not like '%???%' and h.hospid not in ('088', '104', '115', '203', '208', '335', '336', '337', '355', '411', '685', '998') and p.code not in ('NONEM268262', 'NONEM268239', 'NONEM268254', 'NONEF268253', 'NONEF268255', 'NONEF268256', 'NONEM325433', 'NONEF325437', 'NONEM334112', 'NONEF221811', 'NONEF221831', 'NONEF329659', 'NONEM329658', 'NONEM369769', 'NONEF369791') and ( p.code in('NONEM240026', 'NONEF240052', 'NONEM239926', 'NONEF239946', 'NONEM241734', 'NONEF241787', 'NONEM241559', 'NONEF241715', 'NONEF242421', 'NONEM242446', 'NONEF242610', 'NONEM2
czmc517zm276u	select * from ( select row_.*, rownum rownum_ from ( select mcb.ikangorgid, mmi.memberid, mmi.memcitycode, mmi.name, mmi.loginname, mmi.idtype, mmi.idnumber, mmi.mobile, mmi.sex, mmi.organid, mmc.cardnumber, mmc.assocard, mmi.membertype, mmi.operatorid, mmi.operatedate, mmi.socialinsurancenumber, mmi.registereddate, mci.stopflag, mmi.passport_id from Mis_Member_Info mmi left join Mis_Member_Card mmc on mmi.memberid=mmc.memberid , MIS_CARD_INFO mci , Mis_Card_Block mcb where mci.cardnumber=mmc.cardnumber and mci.blockid = mcb.blockid order by mmc.binddate desc ) row_ where rownum <= :1) where rownum_ > :2
d0tr0bwmq27f5	select distinct p.code, p.sexid, p.name from mis_project_quotation q, mis_project_package p, mis_organ_project o, jkcity.hospinfo h where o.p_id = to_char(q.presaleid) and p.quotationid = q.id and p.disallowstatus = 1 and h.state=1 --and hospname not like '%???%' and h.hospid not in ('088', '104', '115', '203', '208', '335', '336', '337', '355', '411', '685', '998') and p.name not like '%??%' and p.name like'????-???(%' and p.name not like'%vip' and p.name not like'%VIP' and p.sexid=0 and p.code not in ('NONEF252215', 'NONEF217807', 'NONEM217498', 'NONEM217833', 'NONEM217777', 'NONEM217749') and ( p.code in('NONEM240026', 'NONEF240052', 'NONEM239926', 'NONEF239946', 'NONEM241734', 'NONEF241787', 'NONEM241559', 'NONEF241715', 'NONEF242421', 'NONEM242446', 'NONEF242610', 'NONEM242550', 'NONEF239775', 'NONEM239786', 'NONEF239866', 'NONEM239771', 'NONEM238232', 'NONEF238290', 'NONEF238245', 'NONEF
da5dnrcph8pmg	SELECT P.NAME, P.CODE, C.STANDARDPRICE, C.RECOMMENDPRICE, C.COSTPRICE FROM MISNEW.MIS_PROJECT_PACKAGEDETAIL O, MISNEW.PHYS_CHECKITEM_ORG C, MISNEW.PHYS_CHECKITEM P, MISNEW.MIS_PROJECT_PACKAGE MP WHERE O.PACKAGEID=MP.ID AND O.CHECKITEMID = C.CHECKITEMID AND P.ID = O.CHECKITEMID AND O.CHECKITEMID = C.CHECKITEMID AND P.ID = O.CHECKITEMID AND P.STATUS != 2 AND C.ORGANID =:B2 AND MP.CODE=:B1 AND C.STATUS != 2 AND O.CHECKITEMID||'|'||ORGANID||'|'||PACKAGEID NOT IN (SELECT I.CHECKITEMID||'|'||ORGANID||'|'||PACKAGEID FROM MISNEW.MIS_PROJECT_ORG_ITEM I WHERE I.ORGANID =:B2 AND I.OPERATORTYPE = 0 ) UNION SELECT P.NAME, P.CODE, C.STANDARDPRICE, C.RECOMMENDPRICE, C.COSTPRICE FROM MISNEW.MIS_PROJECT_ORG_ITEM OI, MISNEW.PHYS_CHECKITEM_ORG C, MISNEW.PHYS_CHECKITEM P, MISNEW.MIS_PROJECT_PACKAGE MP WHERE OI.CHECKITEMID=C.CHECKITEMID AND OI.ORGANID=C.ORGANID AND OI.PACKAGEID=MP.ID AND OI.OPERATORTYPE = 1 AND OI.CHECKITEMID = P.ID AND P.STATUS != 2 AND P.ID = OI.CHECKITEMID AND OI.ORGANID = :B2 AND MP.CODE=:B1
daa5ag6wb5ugf	select mismemberc0_.MEMCARDID as MEMCARDID115_, mismemberc0_.BINDOPERATOR as BINDOPER2_115_, mismemberc0_.BINDDATE as BINDDATE115_, mismemberc0_.MEMBERID as MEMBERID115_, mismemberc0_.CARDNUMBER as CARDNUMBER115_, mismemberc0_.ASSOCARDTYPE as ASSOCARD6_115_, mismemberc0_.ASSOCARD as ASSOCARD115_ from MISNEW.MIS_MEMBER_CARD mismemberc0_ where mismemberc0_.MEMBERID=:1
dp7ss1m235jd0	select distinct s.CONTRACTPRICE, p.code, p.sexid, p.name from mis_project_quotation q, mis_project_package p, mis_project_package_org s, mis_organ_project o, jkcity.hospinfo h, jkcity.city t where o.p_id = to_char(q.presaleid) and p.quotationid = q.id and p.id = s.packageid and h.hospid = s.organid and p.disallowstatus = 1 and h.state=1 --and hospname not like '%???%' and h.hospid not in ('088', '104', '115', '203', '208', '335', '336', '337', '355', '411', '685', '998') and p.code not in ('NONEM268262', 'NONEM268239', 'NONEM268254', 'NONEF268253', 'NONEF268255', 'NONEF268256', 'NONEM325433', 'NONEF325437', 'NONEM334112', 'NONEF221811', 'NONEF221831', 'NONEF329659', 'NONEM329658', 'NONEM369769', 'NONEF369791') and ( p.code in('NONEM240026', 'NONEF240052', 'NONEM239926', 'NONEF239946', 'NONEM241734', 'NONEF241787', 'NONEM241559', 'NONEF241715', 'NONEF242421', 'NONEM2424
dt1a4gnw2bky0	select max(s.standardprice) standardprice, p.code from mis_project_quotation q, mis_project_package p, mis_project_package_org s, mis_organ_project o, jkcity.hospinfo h where o.p_id = to_char(q.presaleid) and p.quotationid = q.id and p.id = s.packageid and h.hospid = s.organid and p.disallowstatus = 1 and h.state=1 and hospname not like '%???%' and ( p.code in('NONEM240026', 'NONEF240052', 'NONEM239926', 'NONEF239946', 'NONEM241734', 'NONEF241787', 'NONEM241559', 'NONEF241715', 'NONEF242421', 'NONEM242446', 'NONEF242610', 'NONEM242550', 'NONEF239775', 'NONEM239786', 'NONEF239866', 'NONEM239771', 'NONEM238232', 'NONEF238290', 'NONEF238245', 'NONEF238239', 'NONEF238308', 'NONEM238468', 'NONEM238340', 'NONEM238356', 'NONEF238406', 'NONEF238426', 'NONEM238667', 'NONEM238572', 'NONEM238588', 'NONEF238589', 'NONEF238484', 'NONEM238646', 'NONEM238668', 'NONEF238688', 'NONEF238687', 'NONEM238690', 'NONEM238768', 'NONEM238692'
dxv5fc4yft52x	SELECT COUNT(*) FROM MIS_XML_INFO WHERE KEYWORDS=:B2 AND TYPE=:B1
dyy32jxzaxmzv	SELECT SUM(DECODE(CANCLESTATE, 3, -1, 1) ) FROM MIS_CHECK_DATA_BACK WHERE ORDERID=:B1
f4j3k90mv96f2	UPDATE MIS_XML_INFO SET CON=:B3 , CREATEDON=SYSDATE WHERE KEYWORDS=:B2 AND TYPE=:B1
f57d4rk8g9s7m	select max(miscardinf0_.CARDNUMBER) as col_0_0_ from MISNEW.MIS_CARD_INFO miscardinf0_ where miscardinf0_.CARDNUMBER like :1 order by miscardinf0_.CARDNUMBER desc
f6d8gxvqnyn77	select distinct s.CONTRACTPRICE, p.code, p.sexid, p.name from mis_project_quotation q, mis_project_package p, mis_project_package_org s, mis_organ_project o, jkcity.hospinfo h, jkcity.city t where o.p_id = to_char(q.presaleid) and p.quotationid = q.id and p.id = s.packageid and h.hospid = s.organid and p.disallowstatus = 1 and h.state=1 --and hospname not like '%???%' and h.hospid not in ('088', '104', '115', '203', '208', '335', '336', '337', '355', '411', '685', '998') and p.code not in ('NONEM268262', 'NONEM268239', 'NONEM268254', 'NONEF268253', 'NONEF268255', 'NONEF268256', 'NONEM325433', 'NONEF325437', 'NONEM334112', 'NONEF221811', 'NONEF221831', 'NONEF329659', 'NONEM329658', 'NONEM369769', 'NONEF369791') and ( p.code in('NONEM240026', 'NONEF240052', 'NONEM239926', 'NONEF239946', 'NONEM241734', 'NONEF241787', 'NONEM241559', 'NONEF241715', 'NONEF242421', 'NONEM2424
ffdm70ws1019q	select distinct s.CONTRACTPRICE, p.code, p.sexid, p.name from mis_project_quotation q, mis_project_package p, mis_project_package_org s, mis_organ_project o, jkcity.hospinfo h, jkcity.city t where o.p_id = to_char(q.presaleid) and p.quotationid = q.id and p.id = s.packageid and h.hospid = s.organid and p.disallowstatus = 1 and h.state=1 --and hospname not like '%???%' and h.hospid not in ('088', '104', '115', '203', '208', '335', '336', '337', '355', '411', '685', '998') and p.code not in ('NONEM268262', 'NONEM268239', 'NONEM268254', 'NONEF268253', 'NONEF268255', 'NONEF268256', 'NONEM325433', 'NONEF325437', 'NONEM334112', 'NONEF221811', 'NONEF221831', 'NONEF329659', 'NONEM329658', 'NONEM369769', 'NONEF369791') and ( p.code in('NONEM240026', 'NONEF240052', 'NONEM239926', 'NONEF239946', 'NONEM241734', 'NONEF241787', 'NONEM241559', 'NONEF241715', 'NONEF242421', 'NONEM2424
fpddhh1u3wmy4	SELECT column_name, data_type, data_length, nullable FROM user_tab_columns WHERE table_name='AREA' ORDER BY column_id
fqmpmkfr6pqyk	select s.synonym_name object_name, o.object_type from sys.all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', user) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
fsw3qguchrdsp	SELECT DISTINCT ORDERID, T.CARDID, T2.CONFIRM_STATE, T2.CANCELFLAG, T2.BATCHID, T2.SERVICEID, T2.SERV_SERIAL, T2.HOSPID FROM MIS_CHECK_DATA_BACK T, MIS_EXAM_RECORD T2 WHERE T2.CONFIRM_STATE<>2 AND T.ORDERID=T2.ID AND T.CANCLESTATE='0' AND SCRQ>=SYSDATE-30
g0pat549t9pkg	select count(*) as col_0_0_ from MISNEW.MIS_PROJECT_PRESALE misproject0_, MISNEW.MIS_PROJECT_QUOTATION misproject1_ where misproject0_.ID=misproject1_.PRESALEID and (misproject0_.ID in (select misproject2_.FID from MISNEW.MIS_PROJECT_MEMBER misproject2_, MISNEW.MIS_PROJECT_PERSON misproject3_ where misproject2_.PERSONID=misproject3_.ID and misproject3_.USERLEVEL=8 and misproject3_.TYPE=1 and (misproject3_.FID=0 or misproject3_.FID in (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 ,
g116c9xbq63f2	select distinct p.code, p.sexid, p.name from mis_project_quotation q, mis_project_package p, mis_organ_project o, jkcity.hospinfo h where o.p_id = to_char(q.presaleid) and p.quotationid = q.id and p.disallowstatus = 1 and h.state=1 --and hospname not like '%???%' and h.hospid not in ('088', '104', '115', '203', '208', '335', '336', '337', '355', '411', '685', '998') and p.name not like '%??%' and p.name like'????-????(%' and p.name not like'%vip' and p.name not like'%VIP' and p.sexid=0 and p.code not in ('NONEF252215', 'NONEF217807', 'NONEM217498', 'NONEM217833', 'NONEM217777', 'NONEM217749') and ( p.code in('NONEM240026', 'NONEF240052', 'NONEM239926', 'NONEF239946', 'NONEM241734', 'NONEF241787', 'NONEM241559', 'NONEF241715', 'NONEF242421', 'NONEM242446', 'NONEF242610', 'NONEM242550', 'NONEF239775', 'NONEM239786', 'NONEF239866', 'NONEM239771', 'NONEM238232', 'NONEF238290', 'NONEF238245', 'NONE
ga607wtr0v74m	SELECT column_name, data_type, data_length, nullable FROM user_tab_columns WHERE table_name='HOSPINFO' ORDER BY column_id
gmb67r9w59b7m	select distinct p.code, p.sexid, p.name from mis_project_quotation q, mis_project_package p, mis_organ_project o, jkcity.hospinfo h where o.p_id = to_char(q.presaleid) and p.quotationid = q.id and p.disallowstatus = 1 and h.state=1 --and hospname not like '%???%' and h.hospid not in ('088', '104', '115', '203', '208', '335', '336', '337', '355', '411', '685', '998') and p.name not like '%??%' and p.name like'??????%' and p.name not like'%vip' and p.name not like'%VIP' and p.sexid=1 and p.code not in ('NONEF252215', 'NONEF217807', 'NONEM217498', 'NONEM217833', 'NONEM217777', 'NONEM217749') and ( p.code in('NONEM240026', 'NONEF240052', 'NONEM239926', 'NONEF239946', 'NONEM241734', 'NONEF241787', 'NONEM241559', 'NONEF241715', 'NONEF242421', 'NONEM242446', 'NONEF242610', 'NONEM242550', 'NONEF239775', 'NONEM239786', 'NONEF239866', 'NONEM239771', 'NONEM238232', 'NONEF238290', 'NONEF238245', 'NONEF238
gqdn6jz8pbg4q	select distinct s.CONTRACTPRICE, p.code, p.sexid, p.name from mis_project_quotation q, mis_project_package p, mis_project_package_org s, mis_organ_project o, jkcity.hospinfo h, jkcity.city t where o.p_id = to_char(q.presaleid) and p.quotationid = q.id and p.id = s.packageid and h.hospid = s.organid and p.disallowstatus = 1 and h.state=1 --and hospname not like '%???%' and h.hospid not in ('088', '104', '115', '203', '208', '335', '336', '337', '355', '411', '685', '998') and p.code not in ('NONEM268262', 'NONEM268239', 'NONEM268254', 'NONEF268253', 'NONEF268255', 'NONEF268256', 'NONEM325433', 'NONEF325437', 'NONEM334112', 'NONEF221811', 'NONEF221831', 'NONEF329659', 'NONEM329658', 'NONEM369769', 'NONEF369791') and ( p.code in('NONEM240026', 'NONEF240052', 'NONEM239926', 'NONEF239946', 'NONEM241734', 'NONEF241787', 'NONEM241559', 'NONEF241715', 'NONEF242421', 'NONEM2424
gvg7gqk6139b3	INSERT INTO MIS_EXAM_RECORD (ID, CREATOR_ID, CREATOR, CREATOR_TIME, REGDATE, AMPM, TIMEDESC, HOSPID, HOSPNAME, SOURCEID, SOURCENAME, MARKET_PRICE, REAL_PRICE, PAYWAY, FEEFLAG, PROJECTID, CARDID, MEMBERID, USERNAME, ORGAN_ID, OTHERCARDID, EXAM_USER_BELONG, CONTACTTEL, CONTACTTEL2, CARD_LEVEL, EXAM_USER, RELATION, EXAM_USER_SEX, EXAM_USER_MARRIED, EXAM_USER_BIRTH, CER_TYPE, EXAM_USER_IDCARD, EXAM_USER_ADDR, EXAM_SERIAL, SERV_SERIAL, COMEFROM, IPADDRESS, MEMO, EMPLOYEEID, SERVICEID, SERVICENAME, PACKAGEVERSION, SETT_PRICE, TIMESPAN_ID, REPORT_SEND_WAY) VALUES (:B43 , :B42 , :B41 , SYSDATE, TO_DATE(:B40 , 'yyyymmdd'), TO_NUMBER(:B39 ), :B38 , :B37 , :B36 , :B35 , :B34 , TO_NUMBER(:B33 ), TO_NUMBER(:B32 ), TO_NUMBER(:B31 ), :B30 , :B29 , :B28 , TO_NUMBER(:B27 ), :B26 , TO_NUMBER(:B25 ), :B24 , REPLACE(:B23 , '''', '*'), :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , 0, REPLACE(SUBSTRB(:B14 , 1, 20), '''', '*'), REPLACE(:B13 , '''', '*'), TO_NUMBER(:B12 ), :B11 , :B10 , REPLACE(:B9 , ''''

Back to SQL Statistics
Back to Top

Instance Activity Statistics

• Instance Activity Stats
• Instance Activity Stats - Absolute Values
• Instance Activity Stats - Thread Activity

Instance Activity Stats

• Ordered by statistic name