ORACLE去掉某个字段后面的指定内容

--查询要更新的数据

SELECT 
    r.CFPayReqNumber,
    REGEXP_REPLACE(r.CFPayReqNumber, 'FDMFKS00168593$', '') AS new_col
FROM T_NT_ReceivableBill r
WHERE r.CFPayReqNumber LIKE '%FDMFKS00168593'

--进行更新
UPDATE T_NT_ReceivableBill r
SET r.CFPayReqNumber = REGEXP_REPLACE(r.CFPayReqNumber, 'FDMFKS00168593$', '')
WHERE r.CFPayReqNumber LIKE '%FDMFKS00168593'

效果