08 2023 档案

oracle 物化视图定时每天刷新
摘要：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 阅读全文
posted @ 2023-08-16 14:43 iamwhy 阅读(476) 评论(0) 推荐(0)
oracle查询锁表-表空间-物化视图-创建用户sql
摘要：--查询锁表select s.sid, s.machine, l.oracle_username, l.locked_mode, S.osuser, 'ALTER SYSTEM KILL SESSION ''' || s.sid || ', ' || s.serial# || ''';' Comma 阅读全文
posted @ 2023-08-08 16:20 iamwhy 阅读(73) 评论(0) 推荐(0)
layui穿梭框实现上下移动
摘要：.layuiTransformBtns{ float: right; width: 20px; margin-top: 158px;} <fieldset class="table-search-fieldset2" > <legend>体检项目</legend> <div class="layui 阅读全文
posted @ 2023-08-08 15:01 iamwhy 阅读(598) 评论(0) 推荐(0)
CREATE OR REPLACE FUNCTION
摘要：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 阅读全文
posted @ 2023-08-08 14:50 iamwhy 阅读(56) 评论(0) 推荐(0)