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

来源:这里教程网 时间:2026-03-03 22:36:00 作者:

[20250805]建立完善descv.sql脚本.txt --//遇到一点点小问题做一个改动。 SCOTT@book01p> @ descv sys.getlong '' FUNCTION sys.getlong RETURNS VARCHAR2  Argument Name                  Type                    In/Out Default? FUNCTION sys.getlong RETURNS VARCHAR2  Argument Name                  Type                    In/Out Default?  ------------------------------ ----------------------- ------ --------  OPCODE                         NUMBER                  IN  P_ROWID                        ROWID                   IN SCOTT@book01p> @ descv sys.getlong rowid FUNCTION sys.getlong RETURNS VARCHAR2  Argument Name                  Type                    In/Out Default?  P_ROWID                        ROWID                   IN --//丢失了分割线,修改如下: $ cat descv.sql set linesize 80 set term off spool tmpdesc.txt desc &1 spool off set term on set linesize 269 host sed -n '1,/----------/p' tmpdesc.txt ; egrep -i "&2" tmpdesc.txt --host &_DELETE tmpdesc.txt SCOTT@book01p> @ descv sys.getlong rowid FUNCTION sys.getlong RETURNS VARCHAR2  Argument Name                  Type                    In/Out Default?  ------------------------------ ----------------------- ------ --------  P_ROWID                        ROWID                   IN SCOTT@book01p> @ descv sys.getlong '' FUNCTION sys.getlong RETURNS VARCHAR2  Argument Name                  Type                    In/Out Default?  ------------------------------ ----------------------- ------ -------- FUNCTION sys.getlong RETURNS VARCHAR2  Argument Name                  Type                    In/Out Default?  ------------------------------ ----------------------- ------ --------  OPCODE                         NUMBER                  IN  P_ROWID                        ROWID                   IN

相关推荐