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','') 

Answer 2

select substr('abcdef_fhj_viji.dvc',instr('abcdef_fhj_viji.dvc','_')+1) from dual

So, Its all depends on INSTR function, define from which position and which occurrence, you will get the index and pass that index to SUBSTR to get your string.