allfunctions

Syntax

allfunctions [[owner_name_pattern.] table_name_pattern]

Description

Lists, in a single column, the names of all the PL/SQL functions 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 functions matching the pattern in the Oracle database.

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

Examples

Command> allfunctions;
  SYS.ORA_STRING_DISTANCE
  SYS.TT_COMPLEXITY_CHECK
  SYS.TT_STIG_VERIFY_FUNCTION
  SYS.TT_STRONG_VERIFY_FUNCTION
  SYS.TT_VERIFY_FUNCTION
  USER.F
6 functions found.

This example displays the functions that matches the given pattern.

Command> allfunctions %TT%;
  SYS.TT_COMPLEXITY_CHECK
  SYS.TT_STIG_VERIFY_FUNCTION
  SYS.TT_STRONG_VERIFY_FUNCTION
  SYS.TT_VERIFY_FUNCTION
4 functions found.