Columnas

Restricciones

Permisos

Estadísticas

Disparadores

Dependencias

Detalles

Particiones

Índices


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS
ISINID CHAR(12 BYTE) No null 1 null
FECHACIERRE DATE No null 2 null
VALORCIERRE NUMBER(10,3) No null 3 null
CONSTRAINT_NAME CONSTRAINT_TYPE SEARCH_CONDITION R_OWNER R_TABLE_NAME R_CONSTRAINT_NAME DELETE_RULE STATUS DEFERRABLE VALIDATED GENERATED BAD RELY LAST_CHANGE INDEX_OWNER INDEX_NAME INVALID VIEW_RELATED
ACCIONHISTORICO_ACCION_FK Foreign_Key null CARTERAINVERSION_USER ACCION ACCION_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 11/06/15 null null null null
ACCIONHISTORICO_PK Primary_Key null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 11/06/15 null ACCIONHISTORICO_PK null null
SYS_C0022721 Check "ISINID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 11/06/15 null null null null
SYS_C0022722 Check "FECHACIERRE" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 11/06/15 null null null null
SYS_C0022723 Check "VALORCIERRE" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 11/06/15 null null null null



Columnas


COLUMN_NAME COLUMN_POSITION
ISINID 1
COLUMN_NAME COLUMN_POSITION
FECHACIERRE 1
ISINID 2
COLUMN_NAME COLUMN_POSITION
ISINID null
COLUMN_NAME COLUMN_POSITION
FECHACIERRE null
COLUMN_NAME COLUMN_POSITION
VALORCIERRE null
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
NAME VALUE
NUM_ROWS null
BLOCKS null
AVG_ROW_LEN null
SAMPLE_SIZE null
LAST_ANALYZED null
LAST_ANALYZED_SINCE null



Estadísticas de Columna


TRIGGER_NAME TRIGGER_TYPE TRIGGER_OWNER TRIGGERING_EVENT STATUS TABLE_NAME
INSBEFOREACCIONHISTORICO BEFORE EACH ROW CARTERAINVERSION_USER INSERT ENABLED ACCIONHISTORICO
INSACCIONHISTORICO AFTER EACH ROW CARTERAINVERSION_USER INSERT ENABLED ACCIONHISTORICO




TRIGGER insBEFOREAccionHistorico BEFORE INSERT  ON ACCIONHISTORICO
FOR EACH ROW
DECLARE
maximaFechaCierre date;
BEGIN

SELECT MAX(FechaCierre) INTO maximaFechaCierre
	FROM AccionHistorico;

	/* no podemos pasar cotizaciones anteriores a la última fecha introducida */
	IF (maximaFechaCierre > :new.FechaCierre) THEN
		RAISE_APPLICATION_ERROR (-20020, 'La fecha de cierre ' || :new.FechaCierre ||
								' es inferior a la última introducida ' || maximaFechaCierre );
	END IF;
END insBEFOREAccionHistorico ;
TRIGGER INSACCIONHISTORICO
AFTER INSERT ON ACCIONHISTORICO
FOR EACH ROW
DECLARE
BEGIN
	UPDATE SituacionCartera SET ValorCotizacionUlt = :new.ValorCierre, FechaCotizacionUlt = :new.FechaCierre
    WHERE ISINID = :new.ISINId;
END;
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
CARTERAINVERSION_USER UTILIDADES PACKAGE BODY CARTERAINVERSION_USER ACCIONHISTORICO TABLE
CARTERAINVERSION_USER GESTIONTEST PACKAGE CARTERAINVERSION_USER ACCIONHISTORICO TABLE
CARTERAINVERSION_USER GESTIONTEST PACKAGE BODY CARTERAINVERSION_USER ACCIONHISTORICO TABLE
CARTERAINVERSION_USER CONSULTAS PACKAGE CARTERAINVERSION_USER ACCIONHISTORICO TABLE
CARTERAINVERSION_USER CONSULTAS PACKAGE BODY CARTERAINVERSION_USER ACCIONHISTORICO TABLE
CARTERAINVERSION_USER INSBEFOREACCIONHISTORICO TRIGGER CARTERAINVERSION_USER ACCIONHISTORICO TABLE
CARTERAINVERSION_USER INSACCIONHISTORICO TRIGGER CARTERAINVERSION_USER ACCIONHISTORICO TABLE



Referencias


OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
NAME VALUE
CREATED 11/06/15
LAST_DDL_TIME 11/06/15
OWNER CARTERAINVERSION_USER
TABLE_NAME ACCIONHISTORICO
TABLESPACE_NAME CARTERAINVERSION
CLUSTER_NAME null
IOT_NAME null
STATUS VALID
PCT_FREE 10
PCT_USED null
INI_TRANS 1
MAX_TRANS 255
INITIAL_EXTENT 65536
NEXT_EXTENT 1048576
MIN_EXTENTS 1
MAX_EXTENTS 2147483645
PCT_INCREASE null
FREELISTS null
FREELIST_GROUPS null
LOGGING YES
BACKED_UP N
NUM_ROWS null
BLOCKS null
EMPTY_BLOCKS null
AVG_SPACE null
CHAIN_CNT null
AVG_ROW_LEN null
AVG_SPACE_FREELIST_BLOCKS null
NUM_FREELIST_BLOCKS null
DEGREE 1
INSTANCES 1
CACHE N
TABLE_LOCK ENABLED
SAMPLE_SIZE null
LAST_ANALYZED null
PARTITIONED NO
IOT_TYPE null
OBJECT_ID_TYPE null
TABLE_TYPE_OWNER null
TABLE_TYPE null
TEMPORARY N
SECONDARY N
NESTED NO
BUFFER_POOL DEFAULT
ROW_MOVEMENT DISABLED
GLOBAL_STATS NO
USER_STATS NO
DURATION null
SKIP_CORRUPT DISABLED
MONITORING YES
CLUSTER_OWNER null
DEPENDENCIES DISABLED
COMPRESSION DISABLED
COMPRESS_FOR null
DROPPED NO
COMMENTS null
PARTITION_NAME LAST_ANALYZED NUM_ROWS BLOCKS SAMPLE_SIZE HIGH_VALUE




INDEX_OWNER INDEX_NAME UNIQUENESS STATUS INDEX_TYPE TEMPORARY PARTITIONED FUNCIDX_STATUS JOIN_INDEX COLUMNS COLUMN_EXPRESSION
CARTERAINVERSION_USER ACCIONHISTORICO_PK UNIQUE VALID NORMAL N NO null NO FECHACIERRE, ISINID null




INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
CARTERAINVERSION_USER ACCIONHISTORICO_PK CARTERAINVERSION_USER ACCIONHISTORICO FECHACIERRE 1 7 0 ASC
CARTERAINVERSION_USER ACCIONHISTORICO_PK CARTERAINVERSION_USER ACCIONHISTORICO ISINID 2 12 12 ASC