VIEW: SYS.USER_PROCEDURES

Source

View Text - Preformatted

select OBJECT_NAME, PROCEDURE_NAME, OBJECT_ID, SUBPROGRAM_ID,
       OVERLOAD, OBJECT_TYPE,
       AGGREGATE, PIPELINED,
       IMPLTYPEOWNER, IMPLTYPENAME, PARALLEL,
       INTERFACE, DETERMINISTIC, AUTHID, ORIGIN_CON_ID
  from NO_ROOT_SW_FOR_LOCAL(INT$DBA_PROCEDURES)
 where OWNER = SYS_CONTEXT('USERENV', 'CURRENT_USER')

View Text - HTML Formatted

SELECT OBJECT_NAME
, PROCEDURE_NAME
, OBJECT_ID
, SUBPROGRAM_ID
, OVERLOAD
, OBJECT_TYPE
, AGGREGATE
, PIPELINED
, IMPLTYPEOWNER
, IMPLTYPENAME
, PARALLEL
, INTERFACE
, DETERMINISTIC
, AUTHID
, ORIGIN_CON_ID
FROM NO_ROOT_SW_FOR_LOCAL(INT$DBA_PROCEDURES)
WHERE OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER')