SELECT OBJECT_NAME FROM ALL_OBJECTS
WHERE
    OWNER = 'PINO93'
    AND OBJECT_TYPE = 'FUNCTION'

##############################################################

GRANT EXECUTE, DEBUG ON [OBJECT NAME] TO [USER NAME]

'DB/ETL > Oracle' 카테고리의 다른 글

[Oracle] 동적쿼리를 받아서 커서 처리  (0) 2010.10.04
[ORACLE] REGEXP_SUBSTR, REGEXP_REPLACE  (0) 2010.09.28
[Oracle] Function, Procedure Grant...  (0) 2010.09.11
[Oracle] Procedure  (0) 2010.08.11
[Oracle] Temporary Table 생성  (0) 2010.07.30
[Oracle] 예외처리 Procedure Test  (0) 2010.07.29
Posted by pino93