| SQL Id | SQL Text |
|---|
| 0k8522rmdzg4k | select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0 |
| 0v3dvmc22qnam | insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time) |
| 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') |
| 0x3t4hpmty459 | select vitalsigni0_.id as id70_, vitalsigni0_.age as age70_, vitalsigni0_.bed_no as bed3_70_, vitalsigni0_.custom_type_seq as custom4_70_, vitalsigni0_.is_custom as is5_70_, vitalsigni0_.is_valid as is6_70_, vitalsigni0_.measure_type as measure7_70_, vitalsigni0_.mrn as mrn70_, vitalsigni0_.nursing_level as nursing9_70_, vitalsigni0_.patient_id as patient10_70_, vitalsigni0_.patient_name as patient11_70_, vitalsigni0_.patient_uid as patient12_70_, vitalsigni0_.plan_time as plan13_70_, vitalsigni0_.record_nurse_id as record14_70_, vitalsigni0_.record_nurse_name as record15_70_, vitalsigni0_.record_time as record16_70_, vitalsigni0_.reference_form_id as reference17_70_, vitalsigni0_.reference_id as reference18_70_, vitalsigni0_.reference_template_code as reference19_70_, vitalsigni0_.reference_template_name as reference20_70_, vitalsigni0_.remark as remark70_, vitalsigni0_.series as series70_, vitalsigni0_.sex as sex70_, vitalsigni0_.source as source70_, vitalsigni0_.syn_to_others as syn25_70_, vitalsigni0_.unit as unit70_, vitalsigni0_.vitalsign_nval1 as vitalsign27_70_, vitalsigni0_.vitalsign_nval2 as vitalsign28_70_, vitalsigni0_.vitalsign_nval3 as vitalsign29_70_, vitalsigni0_.vitalsign_name as vitalsign30_70_, vitalsigni0_.vitalsign_sval1 as vitalsign31_70_, vitalsigni0_.vitalsign_sval2 as vitalsign32_70_, vitalsigni0_.vitalsign_type as vitalsign33_70_, vitalsigni0_.ward_code as ward34_70_, vitalsigni0_.ward_name as ward35_70_ from mcs_vital_info vitalsigni0_ where (vitalsigni0_.patient_uid in (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13)) and vitalsigni0_.plan_time>=:14 and vitalsigni0_.plan_time<=:15 and (vitalsigni0_.vitalsign_type in (:16)) order by vitalsigni0_.patient_uid, vitalsigni0_.plan_time |
| 1219zh1b6hm00 | select * from mcs_doc_template where code=:1 order by version desc |
| 1cq3qr774cu45 | insert into WRH$_IOSTAT_FILETYPE (snap_id, dbid, instance_number, filetype_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, small_sync_read_reqs, large_read_reqs, large_write_reqs, small_read_servicetime, small_write_servicetime, small_sync_read_latency, large_read_servicetime, large_write_servicetime, retries_on_error) (select :snap_id, :dbid, :instance_number, filetype_id, sum(small_read_megabytes) small_read_megabytes, sum(small_write_megabytes) small_write_megabytes, sum(large_read_megabytes) large_read_megabytes, sum(large_write_megabytes) large_write_megabytes, sum(small_read_reqs) small_read_reqs, sum(small_write_reqs) small_write_reqs, sum(small_sync_read_reqs) small_sync_read_reqs, sum(large_read_reqs) large_read_reqs, sum(large_write_reqs) large_write_reqs, sum(small_read_servicetime) small_read_servicetime, sum(small_write_servicetime) small_write_servicetime, sum(small_sync_read_latency) small_sync_read_latency, sum(large_read_servicetime) large_read_servicetime, sum(large_write_servicetime) large_write_servicetime, sum(retries_on_error) retries_on_error from v$iostat_file group by filetype_id) |
| 25k1hgvf0qch6 | select vitalsigni0_.id as id70_, vitalsigni0_.age as age70_, vitalsigni0_.bed_no as bed3_70_, vitalsigni0_.custom_type_seq as custom4_70_, vitalsigni0_.is_custom as is5_70_, vitalsigni0_.is_valid as is6_70_, vitalsigni0_.measure_type as measure7_70_, vitalsigni0_.mrn as mrn70_, vitalsigni0_.nursing_level as nursing9_70_, vitalsigni0_.patient_id as patient10_70_, vitalsigni0_.patient_name as patient11_70_, vitalsigni0_.patient_uid as patient12_70_, vitalsigni0_.plan_time as plan13_70_, vitalsigni0_.record_nurse_id as record14_70_, vitalsigni0_.record_nurse_name as record15_70_, vitalsigni0_.record_time as record16_70_, vitalsigni0_.reference_form_id as reference17_70_, vitalsigni0_.reference_id as reference18_70_, vitalsigni0_.reference_template_code as reference19_70_, vitalsigni0_.reference_template_name as reference20_70_, vitalsigni0_.remark as remark70_, vitalsigni0_.series as series70_, vitalsigni0_.sex as sex70_, vitalsigni0_.source as source70_, vitalsigni0_.syn_to_others as syn25_70_, vitalsigni0_.unit as unit70_, vitalsigni0_.vitalsign_nval1 as vitalsign27_70_, vitalsigni0_.vitalsign_nval2 as vitalsign28_70_, vitalsigni0_.vitalsign_nval3 as vitalsign29_70_, vitalsigni0_.vitalsign_name as vitalsign30_70_, vitalsigni0_.vitalsign_sval1 as vitalsign31_70_, vitalsigni0_.vitalsign_sval2 as vitalsign32_70_, vitalsigni0_.vitalsign_type as vitalsign33_70_, vitalsigni0_.ward_code as ward34_70_, vitalsigni0_.ward_name as ward35_70_ from mcs_vital_info vitalsigni0_ where (vitalsigni0_.patient_uid in (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17)) and vitalsigni0_.plan_time>=:18 and vitalsigni0_.plan_time<=:19 and (vitalsigni0_.vitalsign_type in (:20)) order by vitalsigni0_.patient_uid, vitalsigni0_.plan_time |
| 285vh3201qbzb | select * from mcs_doc_nodes_data_source where template_id=:1 |
| 2acvpyfu857mc | select sequence_next_hi_value from mcs_hibernate_seq where sequence_name = 'schedule_process_id' for update |
| 2j0fw19fph49j | SELECT dbin.instance_number, dbin.db_name, dbin.instance_name, dbin.host_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = s2.instance_number AND dbin.instance_number = s1.instance_number AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.startup_time = s1.startup_time |
| 2t2xgcv961xwj | update mcs_hibernate_seq set sequence_next_hi_value=sequence_next_hi_value+1 where sequence_name=:1 |
| 2w1xfjb0a2z26 | insert into mcs_order_schedule_process (bar_code, checker_id, checker_name, drop_speed, process_type, record_time, recorder_id, recorder_name, remark, id) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10) |
| 3085jbf2u3vmw | select vitalsigni0_.id as id70_, vitalsigni0_.age as age70_, vitalsigni0_.bed_no as bed3_70_, vitalsigni0_.custom_type_seq as custom4_70_, vitalsigni0_.is_custom as is5_70_, vitalsigni0_.is_valid as is6_70_, vitalsigni0_.measure_type as measure7_70_, vitalsigni0_.mrn as mrn70_, vitalsigni0_.nursing_level as nursing9_70_, vitalsigni0_.patient_id as patient10_70_, vitalsigni0_.patient_name as patient11_70_, vitalsigni0_.patient_uid as patient12_70_, vitalsigni0_.plan_time as plan13_70_, vitalsigni0_.record_nurse_id as record14_70_, vitalsigni0_.record_nurse_name as record15_70_, vitalsigni0_.record_time as record16_70_, vitalsigni0_.reference_form_id as reference17_70_, vitalsigni0_.reference_id as reference18_70_, vitalsigni0_.reference_template_code as reference19_70_, vitalsigni0_.reference_template_name as reference20_70_, vitalsigni0_.remark as remark70_, vitalsigni0_.series as series70_, vitalsigni0_.sex as sex70_, vitalsigni0_.source as source70_, vitalsigni0_.syn_to_others as syn25_70_, vitalsigni0_.unit as unit70_, vitalsigni0_.vitalsign_nval1 as vitalsign27_70_, vitalsigni0_.vitalsign_nval2 as vitalsign28_70_, vitalsigni0_.vitalsign_nval3 as vitalsign29_70_, vitalsigni0_.vitalsign_name as vitalsign30_70_, vitalsigni0_.vitalsign_sval1 as vitalsign31_70_, vitalsigni0_.vitalsign_sval2 as vitalsign32_70_, vitalsigni0_.vitalsign_type as vitalsign33_70_, vitalsigni0_.ward_code as ward34_70_, vitalsigni0_.ward_name as ward35_70_ from mcs_vital_info vitalsigni0_ where (vitalsigni0_.patient_uid 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)) and vitalsigni0_.plan_time>=:58 and vitalsigni0_.plan_time<=:59 and (vitalsigni0_.vitalsign_type in (:60)) order by vitalsigni0_.patient_uid, vitalsigni0_.plan_time |
| 317v5hnvvd49h | UPDATE wrh$_seg_stat_obj ob SET (snap_id, owner, object_name, subobject_name, tablespace_name, object_type, index_type, base_obj#, base_object_name, base_object_owner) = (SELECT so.snap_id + 1, so.oj.owner_name, so.oj.object_name, so.oj.subobject_name, so.oj.tablespace_name, so.oj.object_type, index_type, coalesce(io.base_obj#, so.base_obj#), coalesce(io.base_object_name, so.base_object_name), coalesce(io.base_object_owner, so.base_object_owner) FROM (SELECT dbid, ts#, obj#, dataobj#, object_type, base_obj#, base_object_name, base_object_owner, snap_id, dbms_swrf_internal.awr_get_object_info( ts#, obj#, dataobj#, AWR_OBJECT_INFO_TYPE(owner, object_name, subobject_name, tablespace_name, object_type)) oj FROM wrh$_seg_stat_obj) so LEFT OUTER JOIN (SELECT decode(ind.type#, 1, 'NORMAL'|| decode(bitand(ind.property, 4), 0, '', 4, '/REV'), 2, 'BITMAP', 3, 'CLUSTER', 4, 'IOT - TOP', 5, 'IOT - NESTED', 6, 'SECONDARY', 7, 'ANSI', 8, 'LOB', 9, 'DOMAIN') as index_type, base_obj.obj# as base_obj#, base_obj.name as base_object_name, base_owner.name as base_object_owner, ind.bo# as ind_base_obj#, ind.obj# as ind_obj#, ind.dataobj# as ind_dataobj# FROM ((sys.ind$ ind JOIN sys.obj$ base_obj ON (ind.bo# = base_obj.obj#)) JOIN sys.user$ base_owner ON (base_obj.owner# = base_owner.user#))) io ON (so.oj.object_type = 'INDEX' AND so.obj# = io.ind_obj# AND so.dataobj# = io.ind_dataobj#) WHERE ob.dbid = so.dbid AND ob.ts# = so.ts# AND ob.obj# = so.obj# AND ob.dataobj# = so.dataobj#) WHERE dbid = :dbid AND object_name NOT LIKE '%MISSING%' AND object_name NOT LIKE '%TRANSIENT%' AND (object_name, NVL(subobject_name, '!')) NOT IN (SELECT name, nvl(subname, '!') FROM obj$ WHERE ob.obj# = obj$.obj#) AND (ts#, obj#, dataobj#) in (SELECT tsn_kewrseg, objn_kewrseg, objd_kewrseg FROM x$kewrtsegstat) |
| 350f5yrnnmshs | lock table sys.mon_mods$ in exclusive mode nowait |
| 360ww9anw4r9m | select * from v_ewell_doc_form1 t |
| 3c1kubcdjnppq | update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln |
| 3htc58amvqwn5 | select * from mcs_doc_nodes_action where template_id=:1 |
| 3nv4ncycpgbq4 | select printlog0_.id as id20_, printlog0_.admission_time as admission2_20_, printlog0_.mrn as mrn20_, printlog0_.operator_id as operator4_20_, printlog0_.operator_name as operator5_20_, printlog0_.patient_id as patient6_20_, printlog0_.patient_name as patient7_20_, printlog0_.patient_uid as patient8_20_, printlog0_.print_object_name as print9_20_, printlog0_.print_time as print10_20_, printlog0_.print_type as print11_20_, printlog0_.remark as remark20_, printlog0_.series as series20_, printlog0_.time_from as time14_20_, printlog0_.time_to as time15_20_, printlog0_.ward_code as ward16_20_, printlog0_.ward_name as ward17_20_ from MCS_PRINT_LOG printlog0_ where printlog0_.time_from>=:1 and printlog0_.time_to<=:2 and printlog0_.print_type=:3 and printlog0_.ward_code=:4 order by printlog0_.print_time |
| 3utm0avdf3qy5 | select vitalsigni0_.id as id70_, vitalsigni0_.age as age70_, vitalsigni0_.bed_no as bed3_70_, vitalsigni0_.custom_type_seq as custom4_70_, vitalsigni0_.is_custom as is5_70_, vitalsigni0_.is_valid as is6_70_, vitalsigni0_.measure_type as measure7_70_, vitalsigni0_.mrn as mrn70_, vitalsigni0_.nursing_level as nursing9_70_, vitalsigni0_.patient_id as patient10_70_, vitalsigni0_.patient_name as patient11_70_, vitalsigni0_.patient_uid as patient12_70_, vitalsigni0_.plan_time as plan13_70_, vitalsigni0_.record_nurse_id as record14_70_, vitalsigni0_.record_nurse_name as record15_70_, vitalsigni0_.record_time as record16_70_, vitalsigni0_.reference_form_id as reference17_70_, vitalsigni0_.reference_id as reference18_70_, vitalsigni0_.reference_template_code as reference19_70_, vitalsigni0_.reference_template_name as reference20_70_, vitalsigni0_.remark as remark70_, vitalsigni0_.series as series70_, vitalsigni0_.sex as sex70_, vitalsigni0_.source as source70_, vitalsigni0_.syn_to_others as syn25_70_, vitalsigni0_.unit as unit70_, vitalsigni0_.vitalsign_nval1 as vitalsign27_70_, vitalsigni0_.vitalsign_nval2 as vitalsign28_70_, vitalsigni0_.vitalsign_nval3 as vitalsign29_70_, vitalsigni0_.vitalsign_name as vitalsign30_70_, vitalsigni0_.vitalsign_sval1 as vitalsign31_70_, vitalsigni0_.vitalsign_sval2 as vitalsign32_70_, vitalsigni0_.vitalsign_type as vitalsign33_70_, vitalsigni0_.ward_code as ward34_70_, vitalsigni0_.ward_name as ward35_70_ from mcs_vital_info vitalsigni0_ where (vitalsigni0_.patient_uid 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)) and vitalsigni0_.plan_time>=:25 and vitalsigni0_.plan_time<=:26 and (vitalsigni0_.vitalsign_type in (:27)) order by vitalsigni0_.patient_uid, vitalsigni0_.plan_time |
| 3vaqhn8rfksh7 | select syshiberna0_.sequence_name as sequence1_45_, syshiberna0_.sequence_next_hi_value as sequence2_45_ from mcs_hibernate_seq syshiberna0_ where syshiberna0_.sequence_name=:1 |
| 4fxg78urchgww | select eventinfo0_.id as id64_, eventinfo0_.begin_time as begin2_64_, eventinfo0_.end_time as end3_64_, eventinfo0_.event_name as event4_64_, eventinfo0_.event_type as event5_64_, eventinfo0_.is_valid as is6_64_, eventinfo0_.mrn as mrn64_, eventinfo0_.patient_id as patient8_64_, eventinfo0_.patient_name as patient9_64_, eventinfo0_.patient_uid as patient10_64_, eventinfo0_.record_nurse_id as record11_64_, eventinfo0_.record_nurse_name as record12_64_, eventinfo0_.record_time as record13_64_, eventinfo0_.series as series64_, eventinfo0_.source as source64_, eventinfo0_.syn_to_others as syn16_64_, eventinfo0_.ward_code as ward17_64_ from mcs_event_info eventinfo0_ where (eventinfo0_.patient_uid 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)) and eventinfo0_.begin_time>=:44 and eventinfo0_.begin_time<=:45 and (eventinfo0_.event_type in (:46)) |
| 4urt5akd1p7sr | select count(id) from mcs_doc_nodes where template_id=:1 and location_style_pda=:2 |
| 4vs91dcv7u1p6 | insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :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) |
| 53dybm2ra97nm | select vitalsignc0_.id as id68_, vitalsignc0_.data_format as data2_68_, vitalsignc0_.enum_sval1 as enum3_68_, vitalsignc0_.enum_sval2 as enum4_68_, vitalsignc0_.remark as remark68_, vitalsignc0_.unit as unit68_, vitalsignc0_.name as name68_, vitalsignc0_.code as code68_ from mcs_vital_custom vitalsignc0_ order by vitalsignc0_.name |
| 5cxk360bfw3ud | select vitalsigni0_.id as id70_, vitalsigni0_.age as age70_, vitalsigni0_.bed_no as bed3_70_, vitalsigni0_.custom_type_seq as custom4_70_, vitalsigni0_.is_custom as is5_70_, vitalsigni0_.is_valid as is6_70_, vitalsigni0_.measure_type as measure7_70_, vitalsigni0_.mrn as mrn70_, vitalsigni0_.nursing_level as nursing9_70_, vitalsigni0_.patient_id as patient10_70_, vitalsigni0_.patient_name as patient11_70_, vitalsigni0_.patient_uid as patient12_70_, vitalsigni0_.plan_time as plan13_70_, vitalsigni0_.record_nurse_id as record14_70_, vitalsigni0_.record_nurse_name as record15_70_, vitalsigni0_.record_time as record16_70_, vitalsigni0_.reference_form_id as reference17_70_, vitalsigni0_.reference_id as reference18_70_, vitalsigni0_.reference_template_code as reference19_70_, vitalsigni0_.reference_template_name as reference20_70_, vitalsigni0_.remark as remark70_, vitalsigni0_.series as series70_, vitalsigni0_.sex as sex70_, vitalsigni0_.source as source70_, vitalsigni0_.syn_to_others as syn25_70_, vitalsigni0_.unit as unit70_, vitalsigni0_.vitalsign_nval1 as vitalsign27_70_, vitalsigni0_.vitalsign_nval2 as vitalsign28_70_, vitalsigni0_.vitalsign_nval3 as vitalsign29_70_, vitalsigni0_.vitalsign_name as vitalsign30_70_, vitalsigni0_.vitalsign_sval1 as vitalsign31_70_, vitalsigni0_.vitalsign_sval2 as vitalsign32_70_, vitalsigni0_.vitalsign_type as vitalsign33_70_, vitalsigni0_.ward_code as ward34_70_, vitalsigni0_.ward_name as ward35_70_ from mcs_vital_info vitalsigni0_ where (vitalsigni0_.patient_uid 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)) and vitalsigni0_.plan_time>=:27 and vitalsigni0_.plan_time<=:28 and (vitalsigni0_.vitalsign_type in (:29)) order by vitalsigni0_.patient_uid, vitalsigni0_.plan_time |
| 5ms6rbzdnq16t | select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job |
| 606ja0b8br31d | select vitalsigni0_.id as id70_, vitalsigni0_.age as age70_, vitalsigni0_.bed_no as bed3_70_, vitalsigni0_.custom_type_seq as custom4_70_, vitalsigni0_.is_custom as is5_70_, vitalsigni0_.is_valid as is6_70_, vitalsigni0_.measure_type as measure7_70_, vitalsigni0_.mrn as mrn70_, vitalsigni0_.nursing_level as nursing9_70_, vitalsigni0_.patient_id as patient10_70_, vitalsigni0_.patient_name as patient11_70_, vitalsigni0_.patient_uid as patient12_70_, vitalsigni0_.plan_time as plan13_70_, vitalsigni0_.record_nurse_id as record14_70_, vitalsigni0_.record_nurse_name as record15_70_, vitalsigni0_.record_time as record16_70_, vitalsigni0_.reference_form_id as reference17_70_, vitalsigni0_.reference_id as reference18_70_, vitalsigni0_.reference_template_code as reference19_70_, vitalsigni0_.reference_template_name as reference20_70_, vitalsigni0_.remark as remark70_, vitalsigni0_.series as series70_, vitalsigni0_.sex as sex70_, vitalsigni0_.source as source70_, vitalsigni0_.syn_to_others as syn25_70_, vitalsigni0_.unit as unit70_, vitalsigni0_.vitalsign_nval1 as vitalsign27_70_, vitalsigni0_.vitalsign_nval2 as vitalsign28_70_, vitalsigni0_.vitalsign_nval3 as vitalsign29_70_, vitalsigni0_.vitalsign_name as vitalsign30_70_, vitalsigni0_.vitalsign_sval1 as vitalsign31_70_, vitalsigni0_.vitalsign_sval2 as vitalsign32_70_, vitalsigni0_.vitalsign_type as vitalsign33_70_, vitalsigni0_.ward_code as ward34_70_, vitalsigni0_.ward_name as ward35_70_ from mcs_vital_info vitalsigni0_ where (vitalsigni0_.patient_uid 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)) and vitalsigni0_.plan_time>=:26 and vitalsigni0_.plan_time<=:27 and (vitalsigni0_.vitalsign_type in (:28)) order by vitalsigni0_.patient_uid, vitalsigni0_.plan_time |
| 60wxs21kunhy5 | select vitalsignt0_.id as id72_, vitalsignt0_.code as code72_, vitalsignt0_.data_format as data3_72_, vitalsignt0_.enum_sval1 as enum4_72_, vitalsignt0_.enum_sval2 as enum5_72_, vitalsignt0_.low_nval1 as low6_72_, vitalsignt0_.low_nval2 as low7_72_, vitalsignt0_.max_nval1 as max8_72_, vitalsignt0_.max_nval2 as max9_72_, vitalsignt0_.name as name72_, vitalsignt0_.remark as remark72_, vitalsignt0_.unit as unit72_ from mcs_dict_vitalsign_type vitalsignt0_ |
| 61tn3mam0vq0b | SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC |
| 63t3ufgq37m0c | SELECT instance_number, instance_name, host_name FROM ( SELECT dbin.instance_number as instance_number, max(dbin.instance_name) as instance_name, max(dbin.host_name) as host_name, sum(case when s.snap_id in (:bid, :eid) then 1 else 0 end) as cnt_edge FROM WRM$_SNAPSHOT s , WRM$_DATABASE_INSTANCE dbin WHERE s.dbid = :dbid AND dbin.instance_number = s.instance_number AND s.snap_id >= :bid AND s.snap_id <= :eid AND dbin.dbid = s.dbid AND dbin.startup_time = s.startup_time GROUP BY dbin.instance_number ) WHERE cnt_edge < 2 |
| 69k5bhm12sz98 | SELECT dbin.instance_number, dbin.db_name, dbin.instance_name, dbin.host_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = s2.instance_number AND dbin.instance_number = s1.instance_number AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.startup_time = s1.startup_time and dbin.instance_number = :inst |
| 6ajkhukk78nsr | begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end; |
| 6wm3n4d7bnddg | SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC |
| 772s25v1y0x8k | select shared_pool_size_for_estimate s, shared_pool_size_factor * 100 f, estd_lc_load_time l, 0 from v$shared_pool_advice |
| 7awqdn0pgc0dn | select eventinfo0_.id as id64_, eventinfo0_.begin_time as begin2_64_, eventinfo0_.end_time as end3_64_, eventinfo0_.event_name as event4_64_, eventinfo0_.event_type as event5_64_, eventinfo0_.is_valid as is6_64_, eventinfo0_.mrn as mrn64_, eventinfo0_.patient_id as patient8_64_, eventinfo0_.patient_name as patient9_64_, eventinfo0_.patient_uid as patient10_64_, eventinfo0_.record_nurse_id as record11_64_, eventinfo0_.record_nurse_name as record12_64_, eventinfo0_.record_time as record13_64_, eventinfo0_.series as series64_, eventinfo0_.source as source64_, eventinfo0_.syn_to_others as syn16_64_, eventinfo0_.ward_code as ward17_64_ from mcs_event_info eventinfo0_ where eventinfo0_.patient_id=:1 and eventinfo0_.series=:2 and eventinfo0_.begin_time>=:3 and eventinfo0_.begin_time<=:4 and (eventinfo0_.event_type in (:5 , :6 , :7 , :8 , :9 , :10 , :11 , :12)) order by eventinfo0_.begin_time desc |
| 7h35uxf5uhmm1 | select sysdate from dual |
| 7n689bzgy9xvu | select vitalsigni0_.id as id70_, vitalsigni0_.age as age70_, vitalsigni0_.bed_no as bed3_70_, vitalsigni0_.custom_type_seq as custom4_70_, vitalsigni0_.is_custom as is5_70_, vitalsigni0_.is_valid as is6_70_, vitalsigni0_.measure_type as measure7_70_, vitalsigni0_.mrn as mrn70_, vitalsigni0_.nursing_level as nursing9_70_, vitalsigni0_.patient_id as patient10_70_, vitalsigni0_.patient_name as patient11_70_, vitalsigni0_.patient_uid as patient12_70_, vitalsigni0_.plan_time as plan13_70_, vitalsigni0_.record_nurse_id as record14_70_, vitalsigni0_.record_nurse_name as record15_70_, vitalsigni0_.record_time as record16_70_, vitalsigni0_.reference_form_id as reference17_70_, vitalsigni0_.reference_id as reference18_70_, vitalsigni0_.reference_template_code as reference19_70_, vitalsigni0_.reference_template_name as reference20_70_, vitalsigni0_.remark as remark70_, vitalsigni0_.series as series70_, vitalsigni0_.sex as sex70_, vitalsigni0_.source as source70_, vitalsigni0_.syn_to_others as syn25_70_, vitalsigni0_.unit as unit70_, vitalsigni0_.vitalsign_nval1 as vitalsign27_70_, vitalsigni0_.vitalsign_nval2 as vitalsign28_70_, vitalsigni0_.vitalsign_nval3 as vitalsign29_70_, vitalsigni0_.vitalsign_name as vitalsign30_70_, vitalsigni0_.vitalsign_sval1 as vitalsign31_70_, vitalsigni0_.vitalsign_sval2 as vitalsign32_70_, vitalsigni0_.vitalsign_type as vitalsign33_70_, vitalsigni0_.ward_code as ward34_70_, vitalsigni0_.ward_name as ward35_70_ from mcs_vital_info vitalsigni0_ where (vitalsigni0_.patient_uid in (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15)) and vitalsigni0_.plan_time>=:16 and vitalsigni0_.plan_time<=:17 and (vitalsigni0_.vitalsign_type in (:18)) order by vitalsigni0_.patient_uid, vitalsigni0_.plan_time |
| 7pj60ta6kb9zj | select vitalsigni0_.id as id70_, vitalsigni0_.age as age70_, vitalsigni0_.bed_no as bed3_70_, vitalsigni0_.custom_type_seq as custom4_70_, vitalsigni0_.is_custom as is5_70_, vitalsigni0_.is_valid as is6_70_, vitalsigni0_.measure_type as measure7_70_, vitalsigni0_.mrn as mrn70_, vitalsigni0_.nursing_level as nursing9_70_, vitalsigni0_.patient_id as patient10_70_, vitalsigni0_.patient_name as patient11_70_, vitalsigni0_.patient_uid as patient12_70_, vitalsigni0_.plan_time as plan13_70_, vitalsigni0_.record_nurse_id as record14_70_, vitalsigni0_.record_nurse_name as record15_70_, vitalsigni0_.record_time as record16_70_, vitalsigni0_.reference_form_id as reference17_70_, vitalsigni0_.reference_id as reference18_70_, vitalsigni0_.reference_template_code as reference19_70_, vitalsigni0_.reference_template_name as reference20_70_, vitalsigni0_.remark as remark70_, vitalsigni0_.series as series70_, vitalsigni0_.sex as sex70_, vitalsigni0_.source as source70_, vitalsigni0_.syn_to_others as syn25_70_, vitalsigni0_.unit as unit70_, vitalsigni0_.vitalsign_nval1 as vitalsign27_70_, vitalsigni0_.vitalsign_nval2 as vitalsign28_70_, vitalsigni0_.vitalsign_nval3 as vitalsign29_70_, vitalsigni0_.vitalsign_name as vitalsign30_70_, vitalsigni0_.vitalsign_sval1 as vitalsign31_70_, vitalsigni0_.vitalsign_sval2 as vitalsign32_70_, vitalsigni0_.vitalsign_type as vitalsign33_70_, vitalsigni0_.ward_code as ward34_70_, vitalsigni0_.ward_name as ward35_70_ from mcs_vital_info vitalsigni0_ where vitalsigni0_.patient_id=:1 and vitalsigni0_.series=:2 and vitalsigni0_.plan_time>=:3 and vitalsigni0_.plan_time<=:4 and (vitalsigni0_.vitalsign_type in (: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 , :96 , :97 , :98 , :99 , :100 , :101 , :102 , :103 , :104 , :105 , :106 , :107 , :108 , :109 , :110 , :111 , :112 , :113 , :114 , :115 , :116 , :117 , :118 , :119 , :120 , :121 , :122 , :123 , :124 , :125 , :126 , :127 , :128 , :129 , :130 , :131 , :132 , :133 , :134 , :135 , :136 , :137 , :138 , :139 , :140 , :141 , :142 , :143 , :144 , :145 , :146 , :147 , :148 , :149 , :150 , :151 , :152 , :153 , :154 , :155 , :156 , :157 , :158 , :159 , :160 , :161 , :162 , :163 , :164 , :165 , :166 , :167 , :168 , :169 , :170 , :171 , :172 , :173 , :174 , :175 , :176 , :177 , :178 , :179 , :180 , :181 , :182 , :183 , :184 , :185 , :186 , :187 , :188 , :189 , :190 , :191 , :192 , :193 , :194 , :195 , :196 , :197 , :198 , :199 , :200 , :201 , :202 , :203 , :204 , :205 , :206 , :207 , :208 , :209)) and vitalsigni0_.is_valid=:210 order by vitalsigni0_.plan_time desc |
| 7tj5x46rmckxu | select inpordersc0_.id as id31_, inpordersc0_.bar_code as bar2_31_, inpordersc0_.checker_id as checker3_31_, inpordersc0_.checker_name as checker4_31_, inpordersc0_.drop_speed as drop5_31_, inpordersc0_.process_type as process6_31_, inpordersc0_.record_time as record7_31_, inpordersc0_.recorder_id as recorder8_31_, inpordersc0_.recorder_name as recorder9_31_, inpordersc0_.remark as remark31_ from mcs_order_schedule_process inpordersc0_ where inpordersc0_.bar_code=:1 order by inpordersc0_.record_time |
| 7tqxdzswb5570 | select eventinfo0_.id as id64_, eventinfo0_.begin_time as begin2_64_, eventinfo0_.end_time as end3_64_, eventinfo0_.event_name as event4_64_, eventinfo0_.event_type as event5_64_, eventinfo0_.is_valid as is6_64_, eventinfo0_.mrn as mrn64_, eventinfo0_.patient_id as patient8_64_, eventinfo0_.patient_name as patient9_64_, eventinfo0_.patient_uid as patient10_64_, eventinfo0_.record_nurse_id as record11_64_, eventinfo0_.record_nurse_name as record12_64_, eventinfo0_.record_time as record13_64_, eventinfo0_.series as series64_, eventinfo0_.source as source64_, eventinfo0_.syn_to_others as syn16_64_, eventinfo0_.ward_code as ward17_64_ from mcs_event_info eventinfo0_ where (eventinfo0_.patient_uid 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)) and eventinfo0_.begin_time>=:44 and eventinfo0_.begin_time<=:45 and (eventinfo0_.event_type in (:46 , :47)) |
| 7wwd9zjbvggmh | INSERT INTO SYS.WRI$_ADV_TASKS (ID, OWNER#, OWNER_NAME, NAME, DESCRIPTION, ADVISOR_ID, ADVISOR_NAME, CTIME, MTIME, PARENT_ID, PARENT_REC_ID, PROPERTY, VERSION, EXEC_START, EXEC_END, STATUS, STATUS_MSG_ID, PCT_COMPLETION_TIME, PROGRESS_METRIC, METRIC_UNITS, ACTIVITY_COUNTER, REC_COUNT, ERROR_MSG#, SOURCE, HOW_CREATED ) VALUES (:B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , SYSDATE, SYSDATE, :B4 , 0, :B3 , PRVT_ADVISOR.GET_DB_VERSION, NULL, NULL, :B2 , 0, 0, 0, '', 0, 0, 0, '', :B1 ) |
| 7yjzq240hcd2c | UPDATE /*+ INDEX(wrh$_seg_stat_obj wrh$_seg_stat_obj_index) */ wrh$_seg_stat_obj ob SET (snap_id, owner, object_name, subobject_name, tablespace_name, object_type, index_type, base_obj#, base_object_name, base_object_owner) = (SELECT :lah_snap_id, so.oj.owner_name, so.oj.object_name, so.oj.subobject_name, so.oj.tablespace_name, so.oj.object_type, index_type, coalesce(io.base_obj#, so.base_obj#), coalesce(io.base_object_name, so.base_object_name), coalesce(io.base_object_owner, so.base_object_owner) FROM (SELECT dbid, ts#, obj#, dataobj#, object_type, base_obj#, base_object_name, base_object_owner, dbms_swrf_internal.awr_get_object_info( ts#, obj#, dataobj#, AWR_OBJECT_INFO_TYPE(owner, object_name, subobject_name, tablespace_name, object_type)) oj FROM wrh$_seg_stat_obj) so LEFT OUTER JOIN (SELECT decode(ind.type#, 1, 'NORMAL'|| decode(bitand(ind.property, 4), 0, '', 4, '/REV'), 2, 'BITMAP', 3, 'CLUSTER', 4, 'IOT - TOP', 5, 'IOT - NESTED', 6, 'SECONDARY', 7, 'ANSI', 8, 'LOB', 9, 'DOMAIN') as index_type, base_obj.obj# as base_obj#, base_obj.name as base_object_name, base_owner.name as base_object_owner, ind.bo# as ind_base_obj#, ind.obj# as ind_obj#, ind.dataobj# as ind_dataobj# FROM ((sys.ind$ ind JOIN sys.obj$ base_obj ON (ind.bo# = base_obj.obj#)) JOIN sys.user$ base_owner ON (base_obj.owner# = base_owner.user#))) io ON (so.oj.object_type = 'INDEX' AND so.obj# = io.ind_obj# AND so.dataobj# = io.ind_dataobj#) WHERE ob.dbid = so.dbid AND ob.ts# = so.ts# AND ob.obj# = so.obj# AND ob.dataobj# = so.dataobj#) WHERE dbid = :dbid AND snap_id > :lah_snap_id - 10 AND (object_name LIKE '%UNAVAIL%' OR (object_type LIKE '%UNDEF%' AND object_name NOT LIKE '%MISSING%' AND object_name NOT LIKE '%TRANSIENT%') OR owner LIKE '%UNAVAIL%' OR tablespace_name LIKE '%UNAVAIL%') |
| 8uhg97w6smsth | select vitalsigni0_.id as id70_, vitalsigni0_.age as age70_, vitalsigni0_.bed_no as bed3_70_, vitalsigni0_.custom_type_seq as custom4_70_, vitalsigni0_.is_custom as is5_70_, vitalsigni0_.is_valid as is6_70_, vitalsigni0_.measure_type as measure7_70_, vitalsigni0_.mrn as mrn70_, vitalsigni0_.nursing_level as nursing9_70_, vitalsigni0_.patient_id as patient10_70_, vitalsigni0_.patient_name as patient11_70_, vitalsigni0_.patient_uid as patient12_70_, vitalsigni0_.plan_time as plan13_70_, vitalsigni0_.record_nurse_id as record14_70_, vitalsigni0_.record_nurse_name as record15_70_, vitalsigni0_.record_time as record16_70_, vitalsigni0_.reference_form_id as reference17_70_, vitalsigni0_.reference_id as reference18_70_, vitalsigni0_.reference_template_code as reference19_70_, vitalsigni0_.reference_template_name as reference20_70_, vitalsigni0_.remark as remark70_, vitalsigni0_.series as series70_, vitalsigni0_.sex as sex70_, vitalsigni0_.source as source70_, vitalsigni0_.syn_to_others as syn25_70_, vitalsigni0_.unit as unit70_, vitalsigni0_.vitalsign_nval1 as vitalsign27_70_, vitalsigni0_.vitalsign_nval2 as vitalsign28_70_, vitalsigni0_.vitalsign_nval3 as vitalsign29_70_, vitalsigni0_.vitalsign_name as vitalsign30_70_, vitalsigni0_.vitalsign_sval1 as vitalsign31_70_, vitalsigni0_.vitalsign_sval2 as vitalsign32_70_, vitalsigni0_.vitalsign_type as vitalsign33_70_, vitalsigni0_.ward_code as ward34_70_, vitalsigni0_.ward_name as ward35_70_ from mcs_vital_info vitalsigni0_ where (vitalsigni0_.patient_uid in (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19)) and vitalsigni0_.plan_time>=:20 and vitalsigni0_.plan_time<=:21 and (vitalsigni0_.vitalsign_type in (:22)) order by vitalsigni0_.patient_uid, vitalsigni0_.plan_time |
| 91c59xwp3zfr6 | select vitalsigni0_.id as id70_, vitalsigni0_.age as age70_, vitalsigni0_.bed_no as bed3_70_, vitalsigni0_.custom_type_seq as custom4_70_, vitalsigni0_.is_custom as is5_70_, vitalsigni0_.is_valid as is6_70_, vitalsigni0_.measure_type as measure7_70_, vitalsigni0_.mrn as mrn70_, vitalsigni0_.nursing_level as nursing9_70_, vitalsigni0_.patient_id as patient10_70_, vitalsigni0_.patient_name as patient11_70_, vitalsigni0_.patient_uid as patient12_70_, vitalsigni0_.plan_time as plan13_70_, vitalsigni0_.record_nurse_id as record14_70_, vitalsigni0_.record_nurse_name as record15_70_, vitalsigni0_.record_time as record16_70_, vitalsigni0_.reference_form_id as reference17_70_, vitalsigni0_.reference_id as reference18_70_, vitalsigni0_.reference_template_code as reference19_70_, vitalsigni0_.reference_template_name as reference20_70_, vitalsigni0_.remark as remark70_, vitalsigni0_.series as series70_, vitalsigni0_.sex as sex70_, vitalsigni0_.source as source70_, vitalsigni0_.syn_to_others as syn25_70_, vitalsigni0_.unit as unit70_, vitalsigni0_.vitalsign_nval1 as vitalsign27_70_, vitalsigni0_.vitalsign_nval2 as vitalsign28_70_, vitalsigni0_.vitalsign_nval3 as vitalsign29_70_, vitalsigni0_.vitalsign_name as vitalsign30_70_, vitalsigni0_.vitalsign_sval1 as vitalsign31_70_, vitalsigni0_.vitalsign_sval2 as vitalsign32_70_, vitalsigni0_.vitalsign_type as vitalsign33_70_, vitalsigni0_.ward_code as ward34_70_, vitalsigni0_.ward_name as ward35_70_ from mcs_vital_info vitalsigni0_ where vitalsigni0_.patient_id=:1 and vitalsigni0_.series=:2 and vitalsigni0_.plan_time>=:3 and vitalsigni0_.plan_time<=:4 and (vitalsigni0_.vitalsign_type in (:5 , :6 , :7)) order by vitalsigni0_.plan_time desc |
| 9dhn1b8d88dpf |
select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.obj# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.owner# = 0 and g.name
= 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.owner# = 0 and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID |
| 9srwq5k19jah7 | select * from mcs_doc_nodes where template_id=:1 |
| a1xgxtssv5rrp | select sum(used_blocks), ts.ts# from GV$SORT_SEGMENT gv, ts$ ts where gv.tablespace_name = ts.name and ts.bitmapped <> 0 group by ts.ts# |
| a3nd3a68xt944 | select sequence_next_hi_value from mcs_hibernate_seq where sequence_name = 'vital_info_id' for update |
| ahhbvaffm4dva | select vitalsigni0_.id as id70_, vitalsigni0_.age as age70_, vitalsigni0_.bed_no as bed3_70_, vitalsigni0_.custom_type_seq as custom4_70_, vitalsigni0_.is_custom as is5_70_, vitalsigni0_.is_valid as is6_70_, vitalsigni0_.measure_type as measure7_70_, vitalsigni0_.mrn as mrn70_, vitalsigni0_.nursing_level as nursing9_70_, vitalsigni0_.patient_id as patient10_70_, vitalsigni0_.patient_name as patient11_70_, vitalsigni0_.patient_uid as patient12_70_, vitalsigni0_.plan_time as plan13_70_, vitalsigni0_.record_nurse_id as record14_70_, vitalsigni0_.record_nurse_name as record15_70_, vitalsigni0_.record_time as record16_70_, vitalsigni0_.reference_form_id as reference17_70_, vitalsigni0_.reference_id as reference18_70_, vitalsigni0_.reference_template_code as reference19_70_, vitalsigni0_.reference_template_name as reference20_70_, vitalsigni0_.remark as remark70_, vitalsigni0_.series as series70_, vitalsigni0_.sex as sex70_, vitalsigni0_.source as source70_, vitalsigni0_.syn_to_others as syn25_70_, vitalsigni0_.unit as unit70_, vitalsigni0_.vitalsign_nval1 as vitalsign27_70_, vitalsigni0_.vitalsign_nval2 as vitalsign28_70_, vitalsigni0_.vitalsign_nval3 as vitalsign29_70_, vitalsigni0_.vitalsign_name as vitalsign30_70_, vitalsigni0_.vitalsign_sval1 as vitalsign31_70_, vitalsigni0_.vitalsign_sval2 as vitalsign32_70_, vitalsigni0_.vitalsign_type as vitalsign33_70_, vitalsigni0_.ward_code as ward34_70_, vitalsigni0_.ward_name as ward35_70_ from mcs_vital_info vitalsigni0_ where (vitalsigni0_.patient_uid 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)) and vitalsigni0_.plan_time>=:44 and vitalsigni0_.plan_time<=:45 and (vitalsigni0_.vitalsign_type in (:46)) order by vitalsigni0_.patient_uid, vitalsigni0_.plan_time |
| aq8yqxyyb40nn | update sys.job$ set this_date=:1 where job=:2 |
| axfcq597829h6 | select tablespace_id, rfno, allocated_space, file_size, file_maxsize, changescn_base, changescn_wrap, flag, inst_id from sys.ts$, GV$FILESPACE_USAGE where ts# = tablespace_id and online$ != 3 and (changescn_wrap > PITRSCNWRP or (changescn_wrap = PITRSCNWRP and changescn_base >= PITRSCNBAS)) and inst_id != :inst and (changescn_wrap > :w or (changescn_wrap = :w and changescn_base >= :b)) |
| aykvshm7zsabd | select size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3' |
| az0x7tatrnnfn | insert into mcs_vital_info (age, bed_no, custom_type_seq, is_custom, is_valid, measure_type, mrn, nursing_level, patient_id, patient_name, patient_uid, plan_time, record_nurse_id, record_nurse_name, record_time, reference_form_id, reference_id, reference_template_code, reference_template_name, remark, series, sex, source, syn_to_others, unit, vitalsign_nval1, vitalsign_nval2, vitalsign_nval3, vitalsign_name, vitalsign_sval1, vitalsign_sval2, vitalsign_type, ward_code, ward_name, id) values (: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) |
| bn4b3vjw2mj3u | SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.schedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1 |
| bunssq950snhf | insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice |
| cm5vu20fhtnq1 | select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
| cqm5cdrxgkt2t | select vitalsigni0_.id as id70_, vitalsigni0_.age as age70_, vitalsigni0_.bed_no as bed3_70_, vitalsigni0_.custom_type_seq as custom4_70_, vitalsigni0_.is_custom as is5_70_, vitalsigni0_.is_valid as is6_70_, vitalsigni0_.measure_type as measure7_70_, vitalsigni0_.mrn as mrn70_, vitalsigni0_.nursing_level as nursing9_70_, vitalsigni0_.patient_id as patient10_70_, vitalsigni0_.patient_name as patient11_70_, vitalsigni0_.patient_uid as patient12_70_, vitalsigni0_.plan_time as plan13_70_, vitalsigni0_.record_nurse_id as record14_70_, vitalsigni0_.record_nurse_name as record15_70_, vitalsigni0_.record_time as record16_70_, vitalsigni0_.reference_form_id as reference17_70_, vitalsigni0_.reference_id as reference18_70_, vitalsigni0_.reference_template_code as reference19_70_, vitalsigni0_.reference_template_name as reference20_70_, vitalsigni0_.remark as remark70_, vitalsigni0_.series as series70_, vitalsigni0_.sex as sex70_, vitalsigni0_.source as source70_, vitalsigni0_.syn_to_others as syn25_70_, vitalsigni0_.unit as unit70_, vitalsigni0_.vitalsign_nval1 as vitalsign27_70_, vitalsigni0_.vitalsign_nval2 as vitalsign28_70_, vitalsigni0_.vitalsign_nval3 as vitalsign29_70_, vitalsigni0_.vitalsign_name as vitalsign30_70_, vitalsigni0_.vitalsign_sval1 as vitalsign31_70_, vitalsigni0_.vitalsign_sval2 as vitalsign32_70_, vitalsigni0_.vitalsign_type as vitalsign33_70_, vitalsigni0_.ward_code as ward34_70_, vitalsigni0_.ward_name as ward35_70_ from mcs_vital_info vitalsigni0_ where vitalsigni0_.patient_id=:1 and vitalsigni0_.series=:2 and vitalsigni0_.plan_time>=:3 and vitalsigni0_.plan_time<=:4 and (vitalsigni0_.vitalsign_type in (:5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22)) order by vitalsigni0_.plan_time desc |
| czvnch3ya1mwc | update mcs_hibernate_seq set sequence_next_hi_value = :1 where sequence_next_hi_value = :2 and sequence_name = 'schedule_process_id' |
| d3mp6rddu5fm9 | update mcs_hibernate_seq set sequence_next_hi_value = :1 where sequence_next_hi_value = :2 and sequence_name = 'vital_info_id' |
| dqsbqnus3y1zr | select vitalsigni0_.id as id70_, vitalsigni0_.age as age70_, vitalsigni0_.bed_no as bed3_70_, vitalsigni0_.custom_type_seq as custom4_70_, vitalsigni0_.is_custom as is5_70_, vitalsigni0_.is_valid as is6_70_, vitalsigni0_.measure_type as measure7_70_, vitalsigni0_.mrn as mrn70_, vitalsigni0_.nursing_level as nursing9_70_, vitalsigni0_.patient_id as patient10_70_, vitalsigni0_.patient_name as patient11_70_, vitalsigni0_.patient_uid as patient12_70_, vitalsigni0_.plan_time as plan13_70_, vitalsigni0_.record_nurse_id as record14_70_, vitalsigni0_.record_nurse_name as record15_70_, vitalsigni0_.record_time as record16_70_, vitalsigni0_.reference_form_id as reference17_70_, vitalsigni0_.reference_id as reference18_70_, vitalsigni0_.reference_template_code as reference19_70_, vitalsigni0_.reference_template_name as reference20_70_, vitalsigni0_.remark as remark70_, vitalsigni0_.series as series70_, vitalsigni0_.sex as sex70_, vitalsigni0_.source as source70_, vitalsigni0_.syn_to_others as syn25_70_, vitalsigni0_.unit as unit70_, vitalsigni0_.vitalsign_nval1 as vitalsign27_70_, vitalsigni0_.vitalsign_nval2 as vitalsign28_70_, vitalsigni0_.vitalsign_nval3 as vitalsign29_70_, vitalsigni0_.vitalsign_name as vitalsign30_70_, vitalsigni0_.vitalsign_sval1 as vitalsign31_70_, vitalsigni0_.vitalsign_sval2 as vitalsign32_70_, vitalsigni0_.vitalsign_type as vitalsign33_70_, vitalsigni0_.ward_code as ward34_70_, vitalsigni0_.ward_name as ward35_70_ from mcs_vital_info vitalsigni0_ where (vitalsigni0_.patient_uid 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)) and vitalsigni0_.plan_time>=:37 and vitalsigni0_.plan_time<=:38 and (vitalsigni0_.vitalsign_type in (:39)) order by vitalsigni0_.patient_uid, vitalsigni0_.plan_time |
| f2rc2kkax0nmg | select vitalsigni0_.id as id70_, vitalsigni0_.age as age70_, vitalsigni0_.bed_no as bed3_70_, vitalsigni0_.custom_type_seq as custom4_70_, vitalsigni0_.is_custom as is5_70_, vitalsigni0_.is_valid as is6_70_, vitalsigni0_.measure_type as measure7_70_, vitalsigni0_.mrn as mrn70_, vitalsigni0_.nursing_level as nursing9_70_, vitalsigni0_.patient_id as patient10_70_, vitalsigni0_.patient_name as patient11_70_, vitalsigni0_.patient_uid as patient12_70_, vitalsigni0_.plan_time as plan13_70_, vitalsigni0_.record_nurse_id as record14_70_, vitalsigni0_.record_nurse_name as record15_70_, vitalsigni0_.record_time as record16_70_, vitalsigni0_.reference_form_id as reference17_70_, vitalsigni0_.reference_id as reference18_70_, vitalsigni0_.reference_template_code as reference19_70_, vitalsigni0_.reference_template_name as reference20_70_, vitalsigni0_.remark as remark70_, vitalsigni0_.series as series70_, vitalsigni0_.sex as sex70_, vitalsigni0_.source as source70_, vitalsigni0_.syn_to_others as syn25_70_, vitalsigni0_.unit as unit70_, vitalsigni0_.vitalsign_nval1 as vitalsign27_70_, vitalsigni0_.vitalsign_nval2 as vitalsign28_70_, vitalsigni0_.vitalsign_nval3 as vitalsign29_70_, vitalsigni0_.vitalsign_name as vitalsign30_70_, vitalsigni0_.vitalsign_sval1 as vitalsign31_70_, vitalsigni0_.vitalsign_sval2 as vitalsign32_70_, vitalsigni0_.vitalsign_type as vitalsign33_70_, vitalsigni0_.ward_code as ward34_70_, vitalsigni0_.ward_name as ward35_70_ from mcs_vital_info vitalsigni0_ where (vitalsigni0_.patient_uid in (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14)) and vitalsigni0_.plan_time>=:15 and vitalsigni0_.plan_time<=:16 and (vitalsigni0_.vitalsign_type in (:17)) order by vitalsigni0_.patient_uid, vitalsigni0_.plan_time |
| fn9q5nkyny0mu | insert into mcs_sys_log (client_code, client_info, log_level, log_time, message, id) values (:1, :2, :3, :4, :5, :6) |
| g00cj285jmgsw | update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn |
| ga9ky7qubq9qy | select eventinfo0_.id as id64_, eventinfo0_.begin_time as begin2_64_, eventinfo0_.end_time as end3_64_, eventinfo0_.event_name as event4_64_, eventinfo0_.event_type as event5_64_, eventinfo0_.is_valid as is6_64_, eventinfo0_.mrn as mrn64_, eventinfo0_.patient_id as patient8_64_, eventinfo0_.patient_name as patient9_64_, eventinfo0_.patient_uid as patient10_64_, eventinfo0_.record_nurse_id as record11_64_, eventinfo0_.record_nurse_name as record12_64_, eventinfo0_.record_time as record13_64_, eventinfo0_.series as series64_, eventinfo0_.source as source64_, eventinfo0_.syn_to_others as syn16_64_, eventinfo0_.ward_code as ward17_64_ from mcs_event_info eventinfo0_ where (eventinfo0_.patient_uid in (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15)) and eventinfo0_.begin_time>=:16 and eventinfo0_.begin_time<=:17 and (eventinfo0_.event_type in (:18)) |
| gs9k3b3hmrbud | select inpordersc0_.id as id29_, inpordersc0_.bar_code as bar2_29_, inpordersc0_.doctor_name as doctor3_29_, inpordersc0_.dose as dose29_, inpordersc0_.dose_unit as dose5_29_, inpordersc0_.drug_name as drug6_29_, inpordersc0_.end_time as end7_29_, inpordersc0_.execute_checker_id as execute8_29_, inpordersc0_.execute_checker_name as execute9_29_, inpordersc0_.execute_remark as execute10_29_, inpordersc0_.execute_time as execute11_29_, inpordersc0_.executer_id as executer12_29_, inpordersc0_.executer_name as executer13_29_, inpordersc0_.finish_remark as finish14_29_, inpordersc0_.finish_time as finish15_29_, inpordersc0_.finisher_id as finisher16_29_, inpordersc0_.finisher_name as finisher17_29_, inpordersc0_.frequence as frequence29_, inpordersc0_.his_group_no as his19_29_, inpordersc0_.his_order_id as his20_29_, inpordersc0_.his_order_remark as his21_29_, inpordersc0_.is_aux as is22_29_, inpordersc0_.long_once_flag as long23_29_, inpordersc0_.mrn as mrn29_, inpordersc0_.order_class as order25_29_, inpordersc0_.order_code as order26_29_, inpordersc0_.order_name as order27_29_, inpordersc0_.patient_id as patient28_29_, inpordersc0_.patient_uid as patient29_29_, inpordersc0_.plan_time as plan30_29_, inpordersc0_.print_flag as print31_29_, inpordersc0_.print_time as print32_29_, inpordersc0_.real_dose as real33_29_, inpordersc0_.series as series29_, inpordersc0_.spec as spec29_, inpordersc0_.split_time as split36_29_, inpordersc0_.start_time as start37_29_, inpordersc0_.status as status29_, inpordersc0_.supply_code as supply39_29_, inpordersc0_.supply_name as supply40_29_, inpordersc0_.times as times29_, inpordersc0_.ward_code as ward42_29_ from mcs_order_schedule inpordersc0_ where 1=1 and (inpordersc0_.bar_code in (:1)) |
| gt3j6yjqcqn5d | select vitalsigni0_.id as id70_, vitalsigni0_.age as age70_, vitalsigni0_.bed_no as bed3_70_, vitalsigni0_.custom_type_seq as custom4_70_, vitalsigni0_.is_custom as is5_70_, vitalsigni0_.is_valid as is6_70_, vitalsigni0_.measure_type as measure7_70_, vitalsigni0_.mrn as mrn70_, vitalsigni0_.nursing_level as nursing9_70_, vitalsigni0_.patient_id as patient10_70_, vitalsigni0_.patient_name as patient11_70_, vitalsigni0_.patient_uid as patient12_70_, vitalsigni0_.plan_time as plan13_70_, vitalsigni0_.record_nurse_id as record14_70_, vitalsigni0_.record_nurse_name as record15_70_, vitalsigni0_.record_time as record16_70_, vitalsigni0_.reference_form_id as reference17_70_, vitalsigni0_.reference_id as reference18_70_, vitalsigni0_.reference_template_code as reference19_70_, vitalsigni0_.reference_template_name as reference20_70_, vitalsigni0_.remark as remark70_, vitalsigni0_.series as series70_, vitalsigni0_.sex as sex70_, vitalsigni0_.source as source70_, vitalsigni0_.syn_to_others as syn25_70_, vitalsigni0_.unit as unit70_, vitalsigni0_.vitalsign_nval1 as vitalsign27_70_, vitalsigni0_.vitalsign_nval2 as vitalsign28_70_, vitalsigni0_.vitalsign_nval3 as vitalsign29_70_, vitalsigni0_.vitalsign_name as vitalsign30_70_, vitalsigni0_.vitalsign_sval1 as vitalsign31_70_, vitalsigni0_.vitalsign_sval2 as vitalsign32_70_, vitalsigni0_.vitalsign_type as vitalsign33_70_, vitalsigni0_.ward_code as ward34_70_, vitalsigni0_.ward_name as ward35_70_ from mcs_vital_info vitalsigni0_ where (vitalsigni0_.patient_uid 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)) and vitalsigni0_.plan_time>=:31 and vitalsigni0_.plan_time<=:32 and (vitalsigni0_.vitalsign_type in (:33)) order by vitalsigni0_.patient_uid, vitalsigni0_.plan_time |