ORA-01427: 单行子查询返回多个行

报错：单行子查询返回多个行

update BUSINESS_BRAND t set t.MEDIUMCLASSCODE=(select x.code from BUSINESS_BRANDCLASS x where x.name = t.MEDIUMCLASS )

修改添加rownum后:可以正常执行

update BUSINESS_BRAND t set t.MEDIUMCLASSCODE=(select x.code from BUSINESS_BRANDCLASS x where x.name = t.MEDIUMCLASS and ROWNUM <2 )

参考：https://www.cnblogs.com/zqyanywn/p/5856133.html