oracle生成表语句,oracle创建表语句

以下是两个简单的创建案例：

create table "pc_pp_product"

(

"phone_id" VARCHAR2(32 BYTE) NOT NULL ENABLE, --主键

"color" VARCHAR2(32 BYTE),

"phone_type" VARCHAR2(32 BYTE),

"weidth" VARCHAR2(32 BYTE),

"length" VARCHAR2(32 BYTE),

"price" VARCHAR2(32 BYTE),

"category" VARCHAR2(32 BYTE),

CONSTRAINT "phone_id1445" PRIMARY KEY ("phone_id")

);

COMMENT ON COLUMN "pc_pp_product"."phone_id" IS '产品表主键';

COMMENT ON COLUMN "pc_pp_product"."color" IS '颜色';

COMMENT ON COLUMN "pc_pp_product"."phone_type" IS '型号';

COMMENT ON COLUMN "pc_pp_product"."weidth" IS '宽度';

COMMENT ON COLUMN "pc_pp_product"."length" IS '大小';

COMMENT ON COLUMN "pc_pp_product"."price" IS '价格';

COMMENT ON COLUMN "pc_pp_product"."category" IS '类别';

/**  ===================================================  */

create table "pc_pp_product_class"

(

"pc_pp_product_class_id" VARCHAR2(32 BYTE) NOT NULL ENABLE, --主键

"pc_pp_product_class_code" VARCHAR2(32 BYTE),

"pc_pp_product_class_name" VARCHAR2(32 BYTE),

CONSTRAINT "pc_pp_product_class_id123" PRIMARY KEY ("pc_pp_product_class_id")

);

COMMENT ON COLUMN "pc_pp_product_class"."pc_pp_product_class_id" IS '产品类型表主键';

COMMENT ON COLUMN "pc_pp_product_class"."pc_pp_product_class_id" IS '编号';

COMMENT ON COLUMN "pc_pp_product_class"."pc_pp_product_class_id" IS '名称';