allpackages

Syntax

allpackages [[owner_name_pattern.] table_name_pattern]

Description

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

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

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

Examples

Command> allpackages;
  SYS.DBMS_LOB
  SYS.DBMS_LOCK
  SYS.DBMS_OUTPUT
  SYS.DBMS_PREPROCESSOR
  SYS.DBMS_RANDOM
  SYS.DBMS_SQL
  SYS.DBMS_STANDARD
  SYS.DBMS_SYS_ERROR
  SYS.DBMS_SYS_SQL
  SYS.DBMS_UTILITY
  SYS.PLITBLM
  SYS.STANDARD
  SYS.SYS_STUB_FOR_PURITY_ANALYSIS
  SYS.TT_DB_VERSION
  SYS.TT_STATS
  SYS.TT_STATS2
  SYS.UTL_FILE
  SYS.UTL_IDENT
  SYS.UTL_RAW
  SYS.UTL_RECOMP
20 packages found.