简介:
oralce建表示例,基础建表语句,经常用,放在这里以备使用时获取
CREATE TABLE TABLE_NAME (
"ID" VARCHAR2(100) DEFAULT sys_guid() NOT NULL ENABLE,
"CREATE_BY" VARCHAR2(100) NOT NULL ENABLE,
"CREATE_DATE" DATE DEFAULT sysdate NOT NULL ENABLE,
"UPDATE_BY" VARCHAR2(100) NOT NULL ENABLE,
"UPDATE_DATE" DATE DEFAULT sysdate NOT NULL ENABLE,
"IS_DELETE" VARCHAR2(1) DEFAULT 'N',
"IS_VALID" VARCHAR2(1) DEFAULT 'Y',
"ATTRIBUTE1" VARCHAR2(100),
"ATTRIBUTE2" VARCHAR2(100),
"ATTRIBUTE3" VARCHAR2(100),
"ATTRIBUTE4" VARCHAR2(100),
"ATTRIBUTE5" VARCHAR2(100),
"ATTRIBUTE6" VARCHAR2(100)
);
COMMENT ON COLUMN TABLE_NAME.ID IS '主键';
COMMENT ON COLUMN TABLE_NAME.CREATE_BY IS '创建人';
COMMENT ON COLUMN TABLE_NAME.CREATE_DATE IS '创建时间';
COMMENT ON COLUMN TABLE_NAME.UPDATE_BY IS '修改人';
COMMENT ON COLUMN TABLE_NAME.UPDATE_DATE IS '修改时间';
COMMENT ON COLUMN TABLE_NAME.IS_DELETE IS '删除:N:否,Y:是';
COMMENT ON COLUMN TABLE_NAME.IS_VALID IS '是否有效:N:否,Y:是';
COMMENT ON COLUMN TABLE_NAME.ATTRIBUTE1 IS '预留字段1';
COMMENT ON COLUMN TABLE_NAME.ATTRIBUTE2 IS '预留字段2';
COMMENT ON COLUMN TABLE_NAME.ATTRIBUTE3 IS '预留字段3';
COMMENT ON COLUMN TABLE_NAME.ATTRIBUTE4 IS '预留字段4';
COMMENT ON COLUMN TABLE_NAME.ATTRIBUTE5 IS '预留字段5';
COMMENT ON COLUMN TABLE_NAME.ATTRIBUTE6 IS '预留字段6';