包括隐含参数[@more@]
SQL> col KSPPINM for a40
SQL> col KSPPSTVL for a40
SQL> set lines 100
SQL> set pages 200
SQL> list
1 Select a.ksppinm, b.ksppstvl
2 from x$ksppi a, x$ksppsv b
3 where a.indx = b.indx
4 order by 1
比如 _kghdsidx_count
SQL> Select a.ksppinm, b.ksppstvl
from x$ksppi a, x$ksppsv b
where a.indx = b.indx
and a.ksppinm = '_kghdsidx_count'; 2 3 4
KSPPINM
-------------------------------------------------------------------------
KSPPSTVL
-------------------------------------------------------------------------
_kghdsidx_count
5
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/207/viewspace-1005571/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
