merge t as target
using (select p_id, row_number() over (order by p_id)  as pc_id_seq from t ) as source
on (target.p_id = source.p_id)
when matched then
update set target.pc_id = source.pc_id_seq;