?????????????????У????????????????????????????????????????и???ε???????е??
????????????????????????и???ε?????μ????????????
????SQL Server???????????????????Oracle?в???????????
????SQL Server?????????????????
?????????????????????
???????????????????Excel????????????????A--?????????
???????????????н??????A??????B??????????????????????????B?????????????????????Σ?

????? ??B??????
??????????PL SQL??????????Щ?????????B?У??????B?????????A?????????
????????????????????B????????μ????????????????У??????????D??
?????????????oracle?е?Merge into??
????SQL Code???￡?
????MERGE INTO D
????USING B
????ON (D.CATEGORY_NAME = B.CATEGORY_NAME /*AND B IS NULL*/)
????WHEN MATCHED THEN
????UPDATE SET
????RELAVANCE_PROPETY = B.RELAVANCE_PROPETY
????????MERGE INTO?????????
????????????????з????????
????????1??

?????????MERGE INTO???????????????ORA-30926????
?????????????????????ν?????
???????
???????????￡???????????????B?????????Key???????Key???????е?CATEGORY_NAME??????????
????D.CATEGORY_NAME = B.CATEGORY_NAME
?????????????
????????
?????????
??????????????????????????????????CATEGORY_NAME?????????
???????????SQL?????ЩCATEGORY_NAME?????????
????SELECT CATEGORY_NAME??COUNT(1) FROM B
????GROUP BY CATEGORY_NAME
????HAVING COUNT(1) >1
????Ч?????￡?