ALL_WARNING_SETTINGS

ALL_WARNING_SETTINGS displays information about the warning parameter settings for the objects accessible to the current user.

Related Views

DBA_WARNING_SETTINGS displays information about the warning parameter settings for all objects in the database.
USER_WARNING_SETTINGS displays information about the warning parameter settings for the objects owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the object
`OBJECT_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the object
`OBJECT_ID`	`NUMBER`	`NOT NULL`	Object number of the object
`OBJECT_TYPE`	`VARCHAR2(12)`		Type of the object: `PROCEDURE` `FUNCTION` `PACKAGE` `PACKAGE BODY` `TRIGGER` `TYPE` `TYPE BODY`
`WARNING`	`VARCHAR2(40)`		Warning number or category: `INFORMATIONAL` `PERFORMANCE` `SEVERE` `ALL`
`SETTING`	`VARCHAR2(7)`		Value of the warning setting: `DISABLE` `ENABLE` `ERROR`