Details

Grants

References

Dependencies

Code


NAME VALUE
OWNER CARTERAINVERSION_USER
OBJECT_NAME INSTIPOORDEN
SUBOBJECT_NAME null
OBJECT_ID 28318
DATA_OBJECT_ID null
OBJECT_TYPE TRIGGER
CREATED 11/06/15
LAST_DDL_TIME 11/06/15
TIMESTAMP 2015-06-11:22:56:09
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
TIPOORDEN CARTERAINVERSION_USER TABLE 28284 VALID TABLE
TRIGGER insTipoOrden BEFORE INSERT  ON TipoOrden
FOR EACH ROW
BEGIN
 -- normalizar formato de los datos introducidos
  :NEW.TipoOrdenId := UPPER(TRIM(:new.TipoOrdenId));
  :NEW.TipoOrdenDescripcion := UPPER(TRIM(:new.TipoOrdenDescripcion));
END insTipoOrden ;