oracle用sql创建表

CREATE TABLE table
(
PK_ID NUMBER(10) NOT NULL  constraint PK_T_ZK_TEMPLATE primary key ,
T_PK NUMBER(10) DEFAULT 0  NOT NULL,
FID NUMBER(3) NOT NULL,
VALID NUMBER(3) NOT NULL,
FNAME char(100)  DEFAULT '??' NOT NULL,
PINDATA CLOB ,
VTYPE  NUMBER(10) NOT NULL,
DATASIZE  NUMBER(10) NOT NULL,
CREATE_TIME char(19) NOT NULL,
UPDATE_TIME char(19) NOT NULL,
DR NUMBER(10) NOT NULL
);