[Home] [Help] [Dependency Information]
Object Name: | TRIGGER$ |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_TRIGGER2 | NORMAL | UNIQUE | SYSTEM | OBJ# |
I_TRIGGER1 | NORMAL | NONUNIQUE | SYSTEM | BASEOBJECT |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJ# | NUMBER | Yes | ||
TYPE# | NUMBER | Yes | ||
UPDATE$ | NUMBER | Yes | ||
INSERT$ | NUMBER | Yes | ||
DELETE$ | NUMBER | Yes | ||
BASEOBJECT | NUMBER | Yes | ||
REFOLDNAME | VARCHAR2 | (128) | ||
REFNEWNAME | VARCHAR2 | (128) | ||
DEFINITION | VARCHAR2 | (4000) | ||
WHENCLAUSE | VARCHAR2 | (4000) | ||
ACTION# | LONG | (0) | ||
ACTIONSIZE | NUMBER | |||
ENABLED | NUMBER | |||
PROPERTY | NUMBER | Yes | ||
SYS_EVTS | NUMBER | |||
NTTRIGCOL | NUMBER | |||
NTTRIGATT | NUMBER | |||
REFPRTNAME | VARCHAR2 | (128) | ||
ACTIONLINENO | NUMBER | |||
TRIGNAMELINE | NUMBER | |||
TRIGNAMECOL | NUMBER | |||
TRIGNAMECOLOFS | NUMBER | |||
ACTIONCOLNO | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT OBJ#
, TYPE#
, UPDATE$
, INSERT$
, DELETE$
, BASEOBJECT
, REFOLDNAME
, REFNEWNAME
, DEFINITION
, WHENCLAUSE
, ACTION#
, ACTIONSIZE
, ENABLED
, PROPERTY
, SYS_EVTS
, NTTRIGCOL
, NTTRIGATT
, REFPRTNAME
, ACTIONLINENO
, TRIGNAMELINE
, TRIGNAMECOL
, TRIGNAMECOLOFS
, ACTIONCOLNO
FROM SYS.TRIGGER$;
SYS.TRIGGER$ does not reference any database object
SYS.TRIGGER$ is referenced by following:
|
|
|