june_liu1的博客

#设置sqlplus输出的最大行宽 SQL> set linesize 140 #col name format a50 ：将列name（字符型）显示最大宽度调整为50个字符 SQL> col name format a50 SQL> select * from v$dbfile;      FILE# NAME ---------- ---------------------

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...