当嵌套表包含多个值时,调用过程低于错误。ORA-01422:确切的fetch返回超过请求的行数 P_EMP employees_ntas Insert into test (val_1) values (P_EMP(i)) RETURNING new_id into NEW_ID;
Insert into test2 (val_2)
我有两个MYSQL表:在表1中,“COLORNAME”字段为空,两个表中的字段“PRODUCTID”和“BRAND”必须匹配。我需要将“COLORNAME”行从table2移到表1。
INSERT INTO tablel (COLORNAME) SELECT COLORNAME FROM table2 WHERE table1.PRODUCTID = table2.PRODUCTID AND table1.B