The score is too high. Let me continue to answer. No problem. Take it.

The second column kcmc can use regexp_replace(kcmc,' (. +)','').

That bracket should be all-angle. Note that the parentheses in the function are also full-angle.

If there is a full angle or a half angle, it can be replaced by [\ (| (]). +[\) |)]

Select regexp_replace ('graduation thesis (2)',' [\ (|]]. +[\) |)]','') comes from dual.

alliance

Select regexp_replace ('Half of graduation thesis (2)',' [\ (| (]). +[\) |)]','') comes from dual.