博客

查隐含参数的sql语句

  • Post author:
  • Post category:其他


SELECT x.ksppinm "Parameter", Y.ksppstvl "Session Value", Z.ksppstvl "Instance Value"
FROM  x$ksppi X,x$ksppcv Y,x$ksppsv Z
WHERE  x.indx = Y.indx
AND    x.indx = z.indx
AND    x.ksppinm LIKE '/_%' escape '/'
order by x.ksppinm;


版权声明：本文为wgz7747147820原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。