Thursday, January 5, 2012

DESC user_triggers

Name              Null Type
----------------- ---- --------------
TRIGGER_NAME           VARCHAR2(30)
TRIGGER_TYPE           VARCHAR2(16)
TRIGGERING_EVENT       VARCHAR2(227)
TABLE_OWNER            VARCHAR2(30)
BASE_OBJECT_TYPE       VARCHAR2(16)
TABLE_NAME             VARCHAR2(30)
COLUMN_NAME            VARCHAR2(4000)
REFERENCING_NAMES      VARCHAR2(128)
WHEN_CLAUSE            VARCHAR2(4000)
STATUS                 VARCHAR2(8)
DESCRIPTION            VARCHAR2(4000)
ACTION_TYPE            VARCHAR2(11)
TRIGGER_BODY           LONG()

No comments:

Post a Comment