Oracle创建索引sql语句

CREATE INDEX POLICYIMPART_INDEX ON ROOTE.W_POLICYIMPART(
POLICYID ASC,
IMPARTCODE ASC,
CUSTOMERTYPE ASC

)POLICYIMPART_INDEX索引名称 ROOTE.W_POLICYIMPART表名

oracle新增表字段
ALTER TABLE “ROOTE”.“T_BANK_MAINTAIN” ADD (
“WORK_ACC_NAME” VARCHAR2 (100) DEFAULT ‘操作收费额度用户’ NULL
);