Details

Grants

References

Dependencies

Code


NAME VALUE
OWNER TFC
OBJECT_NAME IDTIPOPARLAMENTO
SUBOBJECT_NAME null
OBJECT_ID 42316
DATA_OBJECT_ID null
OBJECT_TYPE TRIGGER
CREATED 13/06/14
LAST_DDL_TIME 13/06/14
TIMESTAMP 2014-06-13:15:02:04
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
IDTIPOPARLAMENTO_SQ TFC SEQUENCE 42315 VALID SEQUENCE
TIPOPARLAMENTO TFC TABLE 42281 VALID TABLE
TRIGGER idTipoParlamento BEFORE
	INSERT ON TipoParlamento FOR EACH ROW WHEN
		(
			NEW.idTipoParlamento IS NULL
		)
		BEGIN :NEW.idTipoParlamento := idTipoParlamento_SQ.NEXTVAL;
END;