Query dba_procedure table : dba_procedure « System Tables Views « Oracle PL / SQL






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