摘要:
declare smyl_hxjob number;begin dbms_job.submit(smyl_hxjob, 'pro_autowriteoffToday_smyl;', next_date => to_date('2019-07-09 00:00:00', 'yyyy-mm-dd hh2 阅读全文
摘要:
方案一:清理Oracle服务端目录下,diag日志目录下,的各种日志 如:E:\app\Administrator\diag 方案二:缩放临时表空间select file#,name from v$datafile;获得目录结果:E:\APP\ADMINISTRATOR\ORADATA\CLOTAD 阅读全文
摘要:
本工具用于解决teamviewr误报商用问题使用方法:将AlterID.exe文件复制到teamviewr安装目录根目录下,双击运行,选择free,start即可。 阅读全文
摘要:
CREATE TEMPORARY TABLESPACE CLOTA_22316TEMP TEMPFILE 'F:\oracle\CLOTA_22316TEMP.DBF' SIZE 50M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED EXTENT MANAGEME 阅读全文
摘要:
原文:https://fly.layui.com/extend/treeSelect/#doc演示地址: https://wujiawei0926.gitee.io/treeselect/ 阅读全文
摘要:
WITH dataSource AS ( SELECT 1 a,'A' b,'X' c,10 d FROM DUAL UNION ALL SELECT 1 a,'A' b,'Y' c,11 d FROM DUAL UNION ALL SELECT 2 a,'B' b,'Y' 阅读全文
摘要:
SELECT S.SQL_TEXT, S.SQL_FULLTEXT, S.SQL_ID, ROUND(ELAPSED_TIME / 1000000 / (CASE WHEN (EXECUTIONS = 0 OR NVL(EXECUTIONS, 1) = 1) THEN 1 ELSE EXECUTIO 阅读全文