摘要：delete hpas_index_data_source s where s.id in (select id FROM ( SELECT t1.*, ROW_NUMBER() OVER(PARTITION BY t1.indexid, t1.doctor_id, t1.start_date, t 阅读全文

摘要：create materialized view VIEW_DEMO refresh force on demand start with to_date('17-06-2023 05:00:00', 'dd-mm-yyyy hh24:mi:ss') next TO_DATE(CONCAT(TO_C 阅读全文

摘要：--查询锁表select s.sid, s.machine, l.oracle_username, l.locked_mode, S.osuser, 'ALTER SYSTEM KILL SESSION ''' || s.sid || ', ' || s.serial# || ''';' Comma 阅读全文

摘要：CREATE OR REPLACE FUNCTION "F_GETRANGE" (inpar_sex peis_item.forsex%Type,inpar_itemid peis_item.itemid%Type,inpar_hosnum peis_item.hosnum%Type)return 阅读全文