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

来源:这里教程网 时间:2026-03-03 23:10:58 作者:

[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

相关推荐

热文推荐