oracle判断某一个存储是否存在

2015-01-22 21:58:02 · 作者: · 浏览: 14

用如下sql语句即可:

SELECT distinct name
  FROM USER_SOURCE
 WHERE TYPE = 'PROCEDURE'
   and name = 'CONTINUEHISORDERPROCESS';