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.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset