列的重命名
Mapper
void renameTableColumn(@Param("tableName") String tableName, @Param("oldColumn") String oldColumn, @Param("newColumn") String newColumn);
Mapper.xml
<update id="renameTableColumn">
ALTER TABLE ${tableName}
RENAME COLUMN "${oldColumn}" to "${newColumn}"
</update>
修改列
Mapper
void relengthTableColumn(@Param("tableName") String tableName, @Param("column") String column, @Param("type") String cType, @Param("length") String cLength, @Param("precision") String precision);
Mapper.xml
<update id="relengthTableColumn">
ALTER TABLE ${tableName}
MODIFY ("${column}"
<choose>
<when test="type=='STRING'">
VARCHAR2(${length} BYTE)
</when>
<when test="type=='NUMBER'">
NUMBER(${length},${precision})
</when>
<otherwise>
TIMESTAMP(${length})
</otherwise>
</choose>
)
</update>