oracle “;” 提示无效字符的问题

小宇倔强 2011-05-30 10:03:00



CREATE TABLE DIPS_USER(

    USER_ID          VARCHAR2(20)     NOT NULL,

    USER_NAME        VARCHAR2(50)     NOT NULL,

    POST_NAME        VARCHAR2(100)    NOT NULL,

    SEX              VARCHAR2(1),

    BRANCH_ID        VARCHAR2(20)     NOT NULL,

    DEPART_ID        VARCHAR2(20)     NOT NULL,

    PHONE            VARCHAR2(20),

    EMAIL            VARCHAR2(50),

    ADDRESS          VARCHAR2(200),

    PASSWORD         VARCHAR2(100)    NOT NULL,

    LAST_LOGIN_TIME  DATE,

    START_TIME       DATE,

    END_TIME         DATE,

    UPDATE_TIME      DATE,

    UPDATE_USERID    VARCHAR2(20),

    CREATE_TIME      DATE,

    CREATE_USERID    VARCHAR2(20),

    EXCLUSIVEKEY     VARCHAR2(100)    NOT NULL,

    CONSTRAINT DIPS_USER_PK PRIMARY KEY (USER_ID)

)

;//这里提示无效字符

COMMENT ON TABLE DIPS_USER IS '用户表'

;

COMMENT ON COLUMN DIPS_USER.USER_ID IS '用户ID'

;

COMMENT ON COLUMN DIPS_USER.USER_NAME IS '姓名'

;

COMMENT ON COLUMN DIPS_USER.POST_NAME IS '职务名称'

;

COMMENT ON COLUMN DIPS_USER.SEX IS '性别(F:女性 M:男性)'

;

COMMENT ON COLUMN DIPS_USER.BRANCH_ID IS '所属公司ID'

;

COMMENT ON COLUMN DIPS_USER.DEPART_ID IS '部门ID'

;

COMMENT ON COLUMN DIPS_USER.PHONE IS '联系电话'

;

COMMENT ON COLUMN DIPS_USER.EMAIL IS 'E-Mail'

;

COMMENT ON COLUMN DIPS_USER.ADDRESS IS '联系地址'

;

COMMENT ON COLUMN DIPS_USER.PASSWORD IS '密码'

;

COMMENT ON COLUMN DIPS_USER.LAST_LOGIN_TIME IS '最后登录时间'

;

COMMENT ON COLUMN DIPS_USER.START_TIME IS '开始时间'

;

COMMENT ON COLUMN DIPS_USER.END_TIME IS '结束时间'

;

COMMENT ON COLUMN DIPS_USER.UPDATE_TIME IS '更新时间'

;

COMMENT ON COLUMN DIPS_USER.UPDATE_USERID IS '更新者'

;

COMMENT ON COLUMN DIPS_USER.CREATE_TIME IS '创建时间'

;

COMMENT ON COLUMN DIPS_USER.CREATE_USERID IS '创建者'

;

COMMENT ON COLUMN DIPS_USER.EXCLUSIVEKEY IS '排他键(使用UUID进行排他)'

...全文

808 6 打赏收藏转发到动态举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

小宇倔强 2011-05-30

打赏
举报

[Quote=引用 1 楼 tangren 的回复:]

正确的，你在什么环境执行的？
[/Quote]

感谢提示。。问题已解决了。。。

源于：http://topic.csdn.net/u/20070704/09/ef6d37fc-e975-4b5c-befa-34de2e4bcc1d.html