数据库的正则，用于PQ端口拆分

对带 扩-X 的进行拆分

update RMS_TRANSCIR_USER
set SOURCE_TRANS_PORT=substr(SOURCE_TRANS_PORT,instr(SOURCE_TRANS_PORT,'-',1)+1,instr(SOURCE_TRANS_PORT,'PQ',1)-instr(SOURCE_TRANS_PORT,'-',1)-1)||'-'||substr(SOURCE_TRANS_PORT,instr(SOURCE_TRANS_PORT,'PQ',1))
where regexp_like(SOURCE_TRANS_PORT,'\d+\-\d+PQ*')

不带扩的

update RMS_TRANSCIR_USER
set REMOTE_TRANS_PORT=substr(REMOTE_TRANS_PORT,1,instr(REMOTE_TRANS_PORT,'PQ',1)-1)||'PQ'||substr(REMOTE_TRANS_PORT,instr(REMOTE_TRANS_PORT,'PQ',1)+2)
where regexp_like(REMOTE_TRANS_PORT,'\d+PQ*')