WB_SCHEDULE_MATERIALIZATION 返回目录
| 序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
| 1 | CREATED_BY | VARCHAR2 | 255 | | | | √ | | |
| 2 | CREATED_DATE | TIMESTAMP(6) | 11 | 6 | | | √ | | |
| 3 | DATA_SET_ID | VARCHAR2 | 255 | | | | | | |
| 4 | ID | VARCHAR2 | 64 | | √ | | | | |
| 5 | LAST_MODIFIED_BY | VARCHAR2 | 255 | | | | √ | | |
| 6 | LAST_MODIFIED_DATE | TIMESTAMP(6) | 11 | 6 | | | √ | | |
| 7 | MATERIALIZATION_SQL | CLOB | 4000 | | | | √ | | |
| 8 | MATERIALIZATION_TYPE | NUMBER | 38 | 0 | | | | ((-1)) | |
| 9 | PK_COL_NAME | VARCHAR2 | 255 | | | | √ | | |
| 10 | SCHEDULE_TASK_ID | VARCHAR2 | 255 | | | | | | |
| 11 | SYS_TENANT_ID | VARCHAR2 | 255 | | | | | | |
| 12 | TARGET_DATA_SOURCE_ID | VARCHAR2 | 255 | | | | | | |
| 13 | TARGET_DATA_SOURCE_TYPE | NUMBER | 38 | 0 | | | | | |
| 14 | TARGET_TABLE_DISCRIPTION | VARCHAR2 | 255 | | | | √ | | |
| 15 | TARGET_TABLE_NAME | VARCHAR2 | 255 | | | | √ | | |
| 16 | TENANT_ID | VARCHAR2 | 255 | | | | | | |
| 17 | TIME_COL_NAME | VARCHAR2 | 255 | | | | √ | | |
| 18 | TS | TIMESTAMP(6) | 11 | 6 | | | √ | cast(sysdate as timestamp) | |
|