PL/SQL
These views provide information about PL/SQL functions, procedures, packages, and triggers:
- ALL_ARGUMENTS
Lists all valid arguments for stored procedures and functions.
- DBA_ERRORS
Shows all errors from compiling objects.
- DBA_LIBRARIES
Lists the external libraries that can be called from PL/SQL packages, procedures, and functions.
- DBA_OBJECT_SIZE
Shows the size of the compiled code for each PL/SQL package, procedure, function, and trigger.
- DBA_SOURCE
Shows PL/SQL source for packages, procedures, and functions.
- DBA_TRIGGER_COLS
Lists columns that are referenced in triggers.
- DBA_TRIGGERS
Shows PL/SQL code for database triggers.
- PUBLIC_DEPENDENCY
Lists dependencies using only object numbers.
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
