Create Table Sql转换
CREATE TABLE "DBSPACE"."STD_USER" ( "USER_ID" NUMBER(20,0) NOT NULL, "USER_PHONE" VARCHAR2(20) NOT NULL, "VERSION" NUMBER(10,0), "CREATE_TIME" DATE, "CREATE_USER" VARCHAR2(50), "UPDATE_TIME" DATE, "UPDATE_USER" VARCHAR2(50), "USER_STATUS" VARCHAR2(1) DEFAULT 1, CONSTRAINT "PK_USER_ID" PRIMARY KEY ("USER_ID") ); COMMENT ON TABLE DBSPACE.STD_USER IS '举例说明，用户表'; COMMENT ON COLUMN DBSPACE.STD_USER.USER_ID IS '用户ID主键'; COMMENT ON COLUMN DBSPACE.STD_USER.USER_PHONE IS '用户手机号'; COMMENT ON COLUMN DBSPACE.STD_USER.VERSION IS '记录版本号，修改加1'; COMMENT ON COLUMN DBSPACE.STD_USER.USER_STATUS IS '用户状态，1可用'; CREATE UNIQUE INDEX "DBSPACE"."U_USER_PHONE" ON "DBSPACE"."STD_USER" ("USER_PHONE"); CREATE INDEX "DBSPACE"."I_CREATE_TIME_STATUS" ON "DBSPACE"."STD_USER" ("CREATE_TIME", "USER_STATUS");