WB_MEASURE 返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | CODE | VARCHAR2 | 255 | | | | √ | | |
2 | CREATE_TIME | TIMESTAMP(6) | 11 | 6 | | | √ | | |
3 | CREATOR | VARCHAR2 | 255 | | | | √ | | |
4 | DATA_COL_FLAG | VARCHAR2 | 255 | | | | √ | | |
5 | DATA_LEN | NUMBER | 38 | 0 | | | √ | | |
6 | DATA_ROW_FLAG | VARCHAR2 | 255 | | | | √ | | |
7 | DATA_TYPE | VARCHAR2 | 255 | | | | √ | | |
8 | DEC_LEN | NUMBER | 38 | 0 | | | √ | | |
9 | DEF_1 | VARCHAR2 | 255 | | | | √ | | |
10 | DEF_10 | VARCHAR2 | 255 | | | | √ | | |
11 | DEF_2 | VARCHAR2 | 255 | | | | √ | | |
12 | DEF_3 | VARCHAR2 | 255 | | | | √ | | |
13 | DEF_4 | VARCHAR2 | 255 | | | | √ | | |
14 | DEF_5 | VARCHAR2 | 255 | | | | √ | | |
15 | DEF_6 | VARCHAR2 | 255 | | | | √ | | |
16 | DEF_7 | VARCHAR2 | 255 | | | | √ | | |
17 | DEF_8 | VARCHAR2 | 255 | | | | √ | | |
18 | DEF_9 | VARCHAR2 | 255 | | | | √ | | |
19 | DIM_CODE | VARCHAR2 | 255 | | | | √ | | |
20 | ID | VARCHAR2 | 64 | | √ | | | | |
21 | IS_FLOAT | NUMBER | 38 | 0 | | | √ | | |
22 | IS_QRY | NUMBER | 38 | 0 | | | √ | | |
23 | IS_USE | NUMBER | 38 | 0 | | | √ | | |
24 | MEA_TYPE_CODE | VARCHAR2 | 255 | | | | √ | | |
25 | MEA_UNIT_CODE | VARCHAR2 | 255 | | | | √ | | |
26 | MODIFIED_TIME | TIMESTAMP(6) | 11 | 6 | | | √ | | |
27 | MODIFIER | VARCHAR2 | 255 | | | | √ | | |
28 | NAME | VARCHAR2 | 255 | | | | √ | | |
29 | PID | VARCHAR2 | 36 | | | | √ | | |
30 | SOURCE_ID | VARCHAR2 | 255 | | | | √ | | |
31 | TS | TIMESTAMP(6) | 11 | 6 | | | √ | cast(sysdate as timestamp) | |
|