![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle
文章平均质量分 54
june_liu1
这个作者很懒,什么都没留下…
展开
-
SQLPlus Set常用设置
#设置sqlplus输出的最大行宽SQL> set linesize 140#col name format a50 :将列name(字符型)显示最大宽度调整为50个字符SQL> col name format a50SQL> select * from v$dbfile; FILE# NAME---------- ---------------------原创 2017-06-28 11:05:36 · 868 阅读 · 0 评论 -
SQL Tuning advisor
GRANT ADVISOR TO WMS;DECLARE my_task_name VARCHAR2(30); my_sqltext CLOB; BEGIN my_sqltext := 'select count(1) as TYPE_NUM, TYPE_DESC from WMS.VW_WMS_OUT_WAREHOUSE_TASK_t t1 WHERE...原创 2018-03-09 10:56:00 · 242 阅读 · 0 评论