[20260116]建立完善descv.sql脚本.txt

--//解决参数2等于*时重复输出的问题，执行效率不是很高。暂时先这样处理。

$ cat descv.sql
set linesize 80
set term off

def _desc_tmpfile=&_tpt_tempdir/desc_&_tpt_tempfile..tmp

spool &_desc_tmpfile
desc &1
spool off
set term on
set linesize 269
--host sed -n '1,/----------/p;/&2/Ip' tmpdesc.txt
--host sed -n '1,/----------/p' &_desc_tmpfile ; egrep -i "&2" &_desc_tmpfile
host sed -n '0,/----------/p' &_desc_tmpfile ; sed -n '/----------/,$p' &_desc_tmpfile | grep -v -- "----------"| egrep -i "&2"
--host &_DELETE tmpdesc.txt
host &_DELETE &_desc_tmpfile

--//简单测试：
SYS@book> @ descv dba_hist_sqltext sql
           Name                            Null?    Type
           ------------------------------- -------- ----------------------------
    2      SQL_ID                          NOT NULL VARCHAR2(13)
    3      SQL_TEXT                                 CLOB


SYS@book> @ descv dba_hist_sqltext *
           Name                            Null?    Type
           ------------------------------- -------- ----------------------------
    1      DBID                            NOT NULL NUMBER
    2      SQL_ID                          NOT NULL VARCHAR2(13)
    3      SQL_TEXT                                 CLOB
    4      COMMAND_TYPE                             NUMBER
    5      CON_DBID                                 NUMBER
    6      CON_ID                                   NUMBER