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>