Query dba_procedure table
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> --
Related examples in the same category