oracle字段名包含中划线“-”，修改字段名报错的问题

alter table PHY_EXAM_CHARGE rename column 'PAID-IN_AMOUNT' to PAID_IN_AMOUNT;

或者

alter table PHY_EXAM_CHARGE rename column PAID-IN_AMOUNT to PAID_IN_AMOUNT;

均会报错。

解决方案：

[#zeyu#]

alter table PHY_EXAM_CHARGE rename column "PAID-IN_AMOUNT" to PAID_IN_AMOUNT;

[/#zeyu#]