折雨的天空
oracle字段名包含中划线“-”,修改字段名报错的问题
2021-6-2 我好笨
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#]


发表评论:
昵称

邮件地址 (选填)

个人主页 (选填)

内容