分类： Linux

plutus#rac1>ALTER TABLE loan_order add
2 (order_source VARCHAR2(32) ,
3 money_arrived DATE );

Table altered.

plutus#rac1>COMMENT ON COLUMN loan_order.order_source IS '订单的创建来源';

Comment created.

plutus#rac1>COMMENT ON COLUMN loan_order.money_arrived IS '订单到款时间';
ERROR:
ORA-01756: quoted string not properly terminated

再次遇到了 ORA-01756错误，记录一下：我的解决办法
在SECURECRT--选项--会话选项--外观：选择UTF8，报错时为DEFAULT。

plutus#rac1>COMMENT ON COLUMN loan_order.money_arrived IS '订单到款时间';
Comment created.

ITPub博客

ORA-01756: quoted string not properly terminated