如何获取本机 Oracle 函数(如 NVL、ABS 等)的列表 [英] How to get a list of native Oracle Functions Like (NVL, ABS etc)

问题描述

我已经尝试使用下面的这个命令，但没有按我预期的那样工作:

I've trying with this command bellow, but does not work as i expected:

select OBJECT_NAME, OWNER from SYS.ALL_OBJECTS where upper(OBJECT_TYPE) = upper('FUNCTION') order by OWNER, OBJECT_NAME 

有什么办法可以实现吗?

is there any way to achieve that?

推荐答案

检查这个:

select distinct PROCEDURE_NAME
from ALL_PROCEDURES
where OWNER = 'SYS'
    and OBJECT_NAME = 'STANDARD';

这篇关于如何获取本机 Oracle 函数(如 NVL、ABS 等)的列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！