17,377
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE Deparment
(
id number primary key,
businessid number,
communicateid number,
time date,
title varchar2 (300),
contents varchar2 (4000)
);
--contents如果不超过4000,最好用varchar2吧,如果超过,可用clob
create sequence seq_id start with 1 increment by 1;
INSERT INTO Deparment
(id, businessid, communicateid, TIME, title, contents)
VALUES
(seq_id.nextval, 1, 1, SYSDATE, 'test', 'hello world!');