CREATE TABLE pr_order_exp_rela ( id DECIMAL(9, 0) NOT NULL, order_id DECIMAL(32), exp_id VARCHAR(50), PRIMARY KEY (id) ); COMMENT ON COLUMN pr_order_exp_rela.id IS '主键id'; COMMENT ON COLUMN pr_order_exp_rela.order_id IS '定单标识'; COMMENT ON COLUMN pr_order_exp_rela.exp_id IS '经验标识'; alter table pr_order add column is_exp_packaged varchar(3) default 'N';改成oracle的语法

CREATE TABLE pr_order_exp_rela (
id NUMBER(9, 0) NOT NULL,
order_id NUMBER(32),
exp_id VARCHAR2(50),
PRIMARY KEY (id)
);
COMMENT ON COLUMN pr_order_exp_rela.id IS '主键id';
COMMENT ON COLUMN pr_order_exp_rela.order_id IS '定单标识';
COMMENT ON COLUMN pr_order_exp_rela.exp_id IS '经验标识';
ALTER TABLE pr_order ADD is_exp_packaged VARCHAR2(3) DEFAULT 'N';