Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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> --