dws
LONG RAW
更新时间:2020/04/21 GMT+08:00
CREATE TABLE不支持“Data type LONG RAW”,需要用Bytea来替换Long Raw数据类型。
输入
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | CREATE TABLE SAD.HW_WORKFLOWDEFS
( ID NUMBER(*,0),
WF_NAME VARCHAR2(200),
WF_DEFINITION LONG RAW,
WF_VERSION NUMBER(*,0),
WF_PUBLISH CHAR(1),
WF_MAINFLOW CHAR(1),
WF_APP_NAME VARCHAR2(20),
CREATED_BY NUMBER,
CREATION_DATE DATE,
LAST_UPDATED_BY NUMBER,
LAST_UPDATE_DATE DATE,
WFDESC VARCHAR2(2000)
);
|
输出
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | CREATE TABLE sad.hw_workflowdefs
(
id NUMBER (38, 0),
wf_name VARCHAR2 (200),
wf_definition BYTEA,
wf_version NUMBER (38, 0),
wf_publish CHAR(1),
wf_mainflow CHAR(1),
wf_app_name VARCHAR2 (20),
created_by NUMBER,
creation_date DATE,
last_updated_by NUMBER,
last_update_date DATE,
wfdesc VARCHAR2 (2000)
);
|
