文档解释 ORA-01912: ROW keyWord expected Cause: keyword missing Action: supply missing keyword 官方解释 当一个表的列的行元素未被正确指定时,将报告此错
ORA-01912: ROW keyWord expected
Cause: keyword missing
Action: supply missing keyword
当一个表的列的行元素未被正确指定时,将报告此错误。
1. 在执行INSERT语句时,在VALUES子句中缺少ROW关键字:
INSERT INTO orders (order_id, customer_name) VALUES (100, ‘John Smith’);
2. 在执行MERGE语句时,在USING子句中缺少ROW关键字:
MERGE INTO orders t
USING new_orders s
ON (t.order_id = s.order_id)
WHEN MATCHED THEN
UPDATE SET t.customer_name = s.customer_name
WHEN NOT MATCHED THEN
INSERT(order_id, customer_name) VALUES (s.order_id, s.customer_name);
1. 检查INSERT或MERGE语句,确认每一行是否指定行元素。
2. 为每一行添加ROW关键字,例如:
INSERT INTO orders (order_id, customer_name) VALUES ROW (100, ‘John Smith’);
MERGE INTO orders t
USING new_orders s
ON (t.order_id = s.order_id)
WHEN MATCHED THEN
UPDATE SET t.customer_name = s.customer_name
WHEN NOT MATCHED THEN
INSERT(order_id, customer_name) VALUES ROW (s.order_id, s.customer_name);
--结束END--
本文标题: ORA-01912: ROW keyword expected ORACLE 报错 故障修复 远程处理
本文链接: https://www.lsjlt.com/news/527286.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0