[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
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/267265/viewspace-3092915/ ,如需转载,请注明出处,否则将追究法律责任。