oracle常用语句（建表、添加字段）

 建表：

CREATE TABLE ae_table(
  id NUMBER(20,0) NOT NULL,
	"TENANT_ID" NVARCHAR2(12), 
	"CREATE_TIME" DATE, 
	"CREATE_USER" NUMBER(20,0), 
	"UPDATE_TIME" DATE, 
	"CREATE_ORG" NUMBER(20,0), 
	"UPDATE_USER" NUMBER(20,0), 
	"DR" NUMBER(11,0), 
	"STATUS" NUMBER(11,0), 
	"TS" TIMESTAMP (0) DEFAULT SYSTIMESTAMP NOT NULL ENABLE, 
	 PRIMARY KEY ("ID"),
     vcode NVARCHAR2(50)
);


COMMENT ON COLUMN ae_table.id IS '主键';
COMMENT ON COLUMN ae_table.TENANT_ID IS '租户id';
COMMENT ON COLUMN ae_table.CREATE_TIME IS '创建时间';
COMMENT ON COLUMN ae_table.CREATE_USER IS '创建人ID';
COMMENT ON COLUMN ae_table.UPDATE_TIME IS '修改时间';
COMMENT ON COLUMN ae_table.CREATE_ORG IS '创建组织';
COMMENT ON COLUMN ae_table.UPDATE_USER IS '修改人ID';
COMMENT ON COLUMN ae_table.DR IS '删除标识';
COMMENT ON COLUMN ae_table.STATUS IS '业务状态';
COMMENT ON COLUMN ae_table.TS IS '时间戳';
COMMENT ON COLUMN ae_table.vcode IS '编码';
COMMENT ON TABLE ae_table IS '表名';


ALTER TABLE ae_table ADD PRIMARY KEY (id);

字符串：NVARCHAR2(200)
大整型： NUMBER(11,0)
浮点型: NUMBER(32,8)

新增字段：

alter table ae_table add (field_1 number(1,0),field_2 Varchar2(2));