???????????????????????????????????????????
????SELECT *
????FROM B MM
????WHERE MM.CATEGORY_NAME IN
????(SELECT CATEGORY_NAME FROM B
????GROUP BY CATEGORY_NAME
????HAVING COUNT(1) >1)
????FOR UPDATE
????Ч?????￡?

???????????????????????
????????????????2????Σ??????????group by?????浽???????????????????????????????
???????????????????1????ζ???????????2????????????????????????ο???????????????????
????????2??
???????B??????????????????????±??У???????????:
????select * into new_table from old_table
????????????????顣???????????????????????????е????????????new_table?С?
???????????????????????

??????????
???????
???????select into??PL/SQL????????????????????????????????μ??
???????????ORA-00905????
?????????
?????????PL/SQL????ν??????????????
??????????create table????????￡?
????--????????????
????CREATE TABLE B1 AS SELECT * FROM B;
????AS????????????