sql - How to remove part of the string in oracle

Question

Input data:

abcdef_fhj_viji.dvc

Expected output:

fhj_viji.dvc

The part to be trimmed is not constant.

Answer 1

Use the REPLACE method

Select REPLACE('abcdef_fhj_viji.dvc','abcde','')

If you want this query for your table :

Select REPLACE(column,'abcde','') from myTable

For update :

UPDATE TABLE
   SET column = REPLACE(column,'abcde','')