Details
Grants
References
Dependencies
Code
Details
Grants
References
Dependencies
Code
NAME | VALUE |
---|---|
OWNER | TFC |
OBJECT_NAME | IDTIPOGASTO |
SUBOBJECT_NAME | null |
OBJECT_ID | 42312 |
DATA_OBJECT_ID | null |
OBJECT_TYPE | TRIGGER |
CREATED | 13/06/14 |
LAST_DDL_TIME | 13/06/14 |
TIMESTAMP | 2014-06-13:15:02:03 |
STATUS | VALID |
TEMPORARY | N |
GENERATED | N |
SECONDARY | N |
NAMESPACE | 3 |
EDITION_NAME | null |
PRIVILEGE | GRANTEE | GRANTABLE | GRANTOR | OBJECT_NAME |
---|
NAME | OWNER | TYPE | OBJECT_ID | STATUS | TYPE_LINK |
---|
NAME | OWNER | TYPE | OBJECT_ID | STATUS | TYPE_LINK |
---|---|---|---|---|---|
IDTIPOGASTO_SQ | TFC | SEQUENCE | 42311 | VALID | SEQUENCE |
TIPOGASTO | TFC | TABLE | 42277 | VALID | TABLE |
TRIGGER idTipoGasto BEFORE INSERT ON TipoGasto FOR EACH ROW WHEN ( NEW.idTipoGasto IS NULL ) BEGIN :NEW.idTipoGasto := idTipoGasto_SQ.NEXTVAL; END;