Oracle PL/SQL/System Tables Views/dba procedure
Query dba_procedure table
<source lang="sql">
SQL> SQL> select procedure_name,aggregate,pipelined,parallel,deterministic,authid
2 from dba_procedures 3 where rownum < 50 4 /
PROCEDURE_NAME AGG PIP PAR DET AUTHID
--- --- --- --- ------------
SET NO NO NO NO CURRENT_USER CARDINALITY NO NO NO NO CURRENT_USER LEAST NO NO NO NO CURRENT_USER GREATEST NO NO NO NO CURRENT_USER SIGN NO NO NO NO CURRENT_USER ROUND NO NO NO NO CURRENT_USER TRUNC NO NO NO NO CURRENT_USER NVL NO NO NO NO CURRENT_USER ABS NO NO NO NO CURRENT_USER LEAST NO NO NO NO CURRENT_USER LEAST NO NO NO NO CURRENT_USER GREATEST NO NO NO NO CURRENT_USER GREATEST NO NO NO NO CURRENT_USER NANVL NO NO NO NO CURRENT_USER NANVL NO NO NO NO CURRENT_USER NANVL NO NO NO NO CURRENT_USER POWER NO NO NO NO CURRENT_USER ROUND NO NO NO NO CURRENT_USER TRUNC NO NO NO NO CURRENT_USER LOG NO NO NO NO CURRENT_USER LN NO NO NO NO CURRENT_USER EXP NO NO NO NO CURRENT_USER TANH NO NO NO NO CURRENT_USER SINH NO NO NO NO CURRENT_USER COSH NO NO NO NO CURRENT_USER TAN NO NO NO NO CURRENT_USER SIN NO NO NO NO CURRENT_USER COS NO NO NO NO CURRENT_USER SIGN NO NO NO NO CURRENT_USER SQRT NO NO NO NO CURRENT_USER CEIL NO NO NO NO CURRENT_USER FLOOR NO NO NO NO CURRENT_USER ATAN2 NO NO NO NO CURRENT_USER ATAN NO NO NO NO CURRENT_USER ASIN NO NO NO NO CURRENT_USER ACOS NO NO NO NO CURRENT_USER ABS NO NO NO NO CURRENT_USER NVL NO NO NO NO CURRENT_USER ROUND NO NO NO NO CURRENT_USER TRUNC NO NO NO NO CURRENT_USER SQRT NO NO NO NO CURRENT_USER SIGN NO NO NO NO CURRENT_USER CEIL NO NO NO NO CURRENT_USER FLOOR NO NO NO NO CURRENT_USER ABS NO NO NO NO CURRENT_USER NVL NO NO NO NO CURRENT_USER REMAINDER NO NO NO NO CURRENT_USER REMAINDER NO NO NO NO CURRENT_USER REMAINDER NO NO NO NO CURRENT_USER 49 rows selected. SQL> SQL> --
</source>