allprocedures

Syntax

allprocedures [[owner_name_pattern.] procedure_name_ pattern]

Description

Lists, in a single column, the names of all the PL/SQL procedures that match the given pattern selected from SYS.ALL_OBJECTS. When a pattern is missing, the pattern defaults to "%".

If passthrough is enabled, lists PL/SQL procedures matching the pattern in the Oracle database.

For more details, see List Database Objects by Object Type.

Examples

Command> allprocedures;
TERRY.PROC1
HERRY.PROC2
2 procedures found.