- 博客(2)
- 资源 (1)
- 收藏
- 关注
原创 ORACLE 查询SQL执行时间
ORACLE 查询SQL执行时间: SELECT C.sample_time 执行时间, A.ELAPSED_TIME_DELTA / 1000000 "执行耗时(S)", B.sql_text SQL文本, to_char(SUBSTR(B.sql_text,1,400)) SQL文本截取 FROM dba_hist_sqlstat A LEFT JOIN dba_hist_sqltex...
2020-01-18 14:07:28 8849
原创 PLSQL 自动替换快捷键参考
PLSQL自动替换快捷键参考: c = COUNT(*) df = DELETE FROM WHERE g = GROUP BY o = ORDER BY ro = RANK()OVER(ORDER BY DESC) sc = SELECT COUNT(*) FROM sd = SELECT DISTINCT * FROM sf = SELECT * FROM 如何设置自动...
2020-01-18 12:04:00 593
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人