Columnas

Restricciones

Permisos

Estadísticas

Disparadores

Dependencias

Detalles

Particiones

Índices


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS
ORDENINVERSIONID NUMBER No null 1 null
ISINID CHAR(12 BYTE) No null 2 null
TIPOORDENID CHAR(1 BYTE) No null 3 null
TIPOORIGENID CHAR(1 BYTE) No null 4 null
FECHAINTRODUCCION DATE No null 5 null
ESTADOID CHAR(1 BYTE) No null 6 null
FECHAEJECUCION DATE No null 7 null
CANTIDAD NUMBER(38,0) No null 8 null
PRECIOMINIMO NUMBER(10,3) Yes null 9 null
EJECUCIONPRECIO NUMBER(10,3) Yes null 10 null
SIGNOTIPOORDEN NUMBER(38,0) No null 11 null
CARTERAID NUMBER No null 12 null
CLIENTEID NUMBER No null 13 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
ORDENINVERSION_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
ORDENINVERSION_CARTERA_FK Foreign_Key null CARTERAINVERSION_USER CARTERA CARTERA_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 11/06/15 null null null null
ORDENINVERSION_ORDENESTADO_FK Foreign_Key null CARTERAINVERSION_USER ORDENESTADO ORDENESTADO_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 11/06/15 null null null null
ORDENINVERSION_PK Primary_Key null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 11/06/15 null ORDENINVERSION_PK null null
ORDENINVERSION_TIPOORDEN_FK Foreign_Key null CARTERAINVERSION_USER TIPOORDEN TIPOORDEN_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 11/06/15 null null null null
ORDENINVERSION_TIPOORIGEN_FK Foreign_Key null CARTERAINVERSION_USER TIPOORIGEN TIPOORIGEN_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 11/06/15 null null null null
RES_CANTIDAD_ORDEN Check  Cantidad BETWEEN 0 AND 999999999 null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 11/06/15 null null null null
SYS_C0022768 Check "ORDENINVERSIONID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 11/06/15 null null null null
SYS_C0022769 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_C0022770 Check "TIPOORDENID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 11/06/15 null null null null
SYS_C0022771 Check "TIPOORIGENID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 11/06/15 null null null null
SYS_C0022772 Check "FECHAINTRODUCCION" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 11/06/15 null null null null
SYS_C0022773 Check "ESTADOID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 11/06/15 null null null null
SYS_C0022774 Check "FECHAEJECUCION" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 11/06/15 null null null null
SYS_C0022775 Check "CANTIDAD" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 11/06/15 null null null null
SYS_C0022776 Check "SIGNOTIPOORDEN" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 11/06/15 null null null null
SYS_C0022777 Check "CARTERAID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 11/06/15 null null null null
SYS_C0022778 Check "CLIENTEID" 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
CARTERAID 1
CLIENTEID 2
COLUMN_NAME COLUMN_POSITION
ESTADOID 1
COLUMN_NAME COLUMN_POSITION
ORDENINVERSIONID 1
CARTERAID 2
CLIENTEID 3
COLUMN_NAME COLUMN_POSITION
TIPOORDENID 1
COLUMN_NAME COLUMN_POSITION
TIPOORIGENID 1
COLUMN_NAME COLUMN_POSITION
CANTIDAD null
COLUMN_NAME COLUMN_POSITION
ORDENINVERSIONID null
COLUMN_NAME COLUMN_POSITION
ISINID null
COLUMN_NAME COLUMN_POSITION
TIPOORDENID null
COLUMN_NAME COLUMN_POSITION
TIPOORIGENID null
COLUMN_NAME COLUMN_POSITION
FECHAINTRODUCCION null
COLUMN_NAME COLUMN_POSITION
ESTADOID null
COLUMN_NAME COLUMN_POSITION
FECHAEJECUCION null
COLUMN_NAME COLUMN_POSITION
CANTIDAD null
COLUMN_NAME COLUMN_POSITION
SIGNOTIPOORDEN null
COLUMN_NAME COLUMN_POSITION
CARTERAID null
COLUMN_NAME COLUMN_POSITION
CLIENTEID 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
INSORDENINVERSION BEFORE EACH ROW CARTERAINVERSION_USER INSERT OR UPDATE ENABLED ORDENINVERSION




TRIGGER insOrdenInversion BEFORE INSERT OR UPDATE ON OrdenInversion
FOR EACH ROW
BEGIN
IF :new.OrdenInversionId IS NULL THEN
	SELECT SEQ_OrdenInversion.NEXTVAL INTO :NEW.OrdenInversionId
	FROM DUAL;
END IF;

IF(:old.EstadoId <> 'P') THEN
 RAISE_APPLICATION_ERROR (-20000, 'Orden de Inversión no puede ser modificada');
END IF ;

END insOrdenInversion ;
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
CARTERAINVERSION_USER GESTIONTEST PACKAGE CARTERAINVERSION_USER ORDENINVERSION TABLE
CARTERAINVERSION_USER GESTIONTEST PACKAGE BODY CARTERAINVERSION_USER ORDENINVERSION TABLE
CARTERAINVERSION_USER CONSULTAS PACKAGE BODY CARTERAINVERSION_USER ORDENINVERSION TABLE
CARTERAINVERSION_USER INSORDENINVERSION TRIGGER CARTERAINVERSION_USER ORDENINVERSION 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
NAME VALUE
CREATED 11/06/15
LAST_DDL_TIME 11/06/15
OWNER CARTERAINVERSION_USER
TABLE_NAME ORDENINVERSION
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 ORDENINVERSION_PK UNIQUE VALID NORMAL N NO null NO ORDENINVERSIONID, CARTERAID, CLIENTEID null
CARTERAINVERSION_USER ORDENINVERSION__IDX NONUNIQUE VALID NORMAL N NO null NO TIPOORDENID null
CARTERAINVERSION_USER ORDENINVERSION__IDXV1 NONUNIQUE VALID NORMAL N NO null NO ESTADOID null
CARTERAINVERSION_USER ORDENINVERSION__IDXV2 NONUNIQUE VALID NORMAL N NO null NO TIPOORIGENID null
CARTERAINVERSION_USER ORDENINVERSION__IDXV3 NONUNIQUE VALID NORMAL N NO null NO ISINID null




INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
CARTERAINVERSION_USER ORDENINVERSION_PK CARTERAINVERSION_USER ORDENINVERSION ORDENINVERSIONID 1 22 0 ASC
CARTERAINVERSION_USER ORDENINVERSION_PK CARTERAINVERSION_USER ORDENINVERSION CARTERAID 2 22 0 ASC
CARTERAINVERSION_USER ORDENINVERSION_PK CARTERAINVERSION_USER ORDENINVERSION CLIENTEID 3 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
CARTERAINVERSION_USER ORDENINVERSION__IDX CARTERAINVERSION_USER ORDENINVERSION TIPOORDENID 1 1 1 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
CARTERAINVERSION_USER ORDENINVERSION__IDXV1 CARTERAINVERSION_USER ORDENINVERSION ESTADOID 1 1 1 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
CARTERAINVERSION_USER ORDENINVERSION__IDXV2 CARTERAINVERSION_USER ORDENINVERSION TIPOORIGENID 1 1 1 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
CARTERAINVERSION_USER ORDENINVERSION__IDXV3 CARTERAINVERSION_USER ORDENINVERSION ISINID 1 12 12 ASC