SYS_ROUTINE_USAGE

Information on the tables and columns which are addressed in routines (procedures and UDFs).

Column name	Data type	Contents
SPECIFIC_SCHEMA	CHAR(31)	Name of the schema to which the routine belongs
SPECIFIC_NAME	CHAR(31)	Specific name of the routine
TABLE_SCHEMA	CHAR(31)	Name of the schema to which the table which is addressed in the routine belongs
TABLE_NAME	CHAR(31)	Name of the table used in the routine
COLUMN_NAME	CHAR(31)	Column name used in the routine Blanks if information on a table
OBJECT_INDICATOR	CHAR(1)	T Row contains informations on table C Row contains informations on column

Table 128: SYS_ROUTINE_USAGE view of the SYS_INFO_SCHEMA