2.19. Pohled "UNI_SEZNAM_VW"
Předcházející Kapitola 2. Pohledy Další

2.19. Pohled "UNI_SEZNAM_VW"

Nadřízené objekty
Pohledy - UNI_CLASS_VW - UNI_ENUMVAL_VW - UNI_PROPERTY_VW - UNI_PROPSET_VW
název sloupceTypvýchozíupravitelný
RADDRNUMBER ( 22 ) Ne
TPCHAR ( 1 ) Ne
PARENT_TPCHAR ( 1 ) Ne
IDNUMBER ( 22 ) Ne
PARENT_IDNUMBER ( 22 ) Ne
VISIBLEVARCHAR2 ( 20 ) Ne
CLASSTYPECHAR ( 4 ) Ne
OBJLVLNUMBER ( 22 ) Ne
OBJTYPEVARCHAR2 ( 14 ) Ne
NAMEVARCHAR2 ( 400 ) Ne
DEFVARCHAR2 ( 4000 ) Ne
DEF50VARCHAR2 ( 4000 ) Ne
DEF100VARCHAR2 ( 4000 ) Ne
IFCIDENTVARCHAR2 ( 50 ) Ne
DATAUNITVARCHAR2 ( 80 ) Ne
DATATYPESPECVARCHAR2 ( 6 ) Ne
DATATYPEVARCHAR2 ( 200 ) Ne
IFCTYPEVARCHAR2 ( 200 ) Ne
LINK_URLVARCHAR2 ( 800 ) Ne

select "RADDR","TP","PARENT_TP","ID","PARENT_ID","VISIBLE","CLASSTYPE","OBJLVL","OBJTYPE","NAME","DEF","DEF50","DEF100","IFCIDENT","DATAUNIT","DATATYPESPEC","DATATYPE","IFCTYPE","LINK_URL" from UNI_Class_VW
  union all
  select "RADDR","TP","PARENT_TP","ID","PARENT_ID","VISIBLE","CLASSTYPE","OBJLVL","OBJTYPE","NAME","DEF","DEF50","DEF100","IFCIDENT","DATAUNIT","DATATYPESPEC","DATATYPE","IFCTYPE","LINK_URL" from UNI_PropSet_VW
  union all
  select "RADDR","TP","PARENT_TP","ID","PARENT_ID","VISIBLE","CLASSTYPE","OBJLVL","OBJTYPE","NAME","DEF","DEF50","DEF100","IFCIDENT","DATAUNIT","DATATYPESPEC","DATATYPE","IFCTYPE","LINK_URL" from UNI_Property_VW
  union all
  select "RADDR","TP","PARENT_TP","ID","PARENT_ID","VISIBLE","CLASSTYPE","OBJLVL","OBJTYPE","NAME","DEF","DEF50","DEF100","IFCIDENT","DATAUNIT","DATATYPESPEC","DATATYPE","IFCTYPE","LINK_URL" from UNI_EnumVal_VW

Předcházející Nahoru Další
2.18. Pohled "UNI_PROPSET_VW" Domů Kapitola 3. Procedury