文档解释 ORA-02252: check constraint condition not properly ended Cause: The specified search condition for the check constr
ORA-02252: check constraint condition not properly ended
Cause: The specified search condition for the check constraint is not properly ended.
Action: End the condition properly.
这是一个由oracle数据库触发的错误,用户尝试为表创建或修改一个检查约束,但在语句结尾处丢失了结束运算符(例如括号)。
sql> ALTER TABLE customers
2 ADD CONSTRAINT customers_city_ck CHECK(city = ‘New York’
SQL> ALTER TABLE customers
2 ADD CONSTRAINT customers_city_ck CHECK (city = ‘New York’);
建议修改后,确保已使用正确的语法指定检查约束的完整语句:
SQL> ALTER TABLE customers
2 ADD CONSTRAINT customers_city_ck CHECK(city = ‘New York’);
--结束END--
本文标题: ORA-02252: check constraint condition not properly ended ORACLE 报错 故障修复 远程处理
本文链接: https://www.lsjlt.com/news/540126.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0