oracle - regex to replace the last digit with a hyphen and a digit -


Is there a way to replace the last digit with hyphen and one digit?

  The original requirements must be changed from File 01 file 01-01 file02 file02-02  

I resolved it with AmarGhosh

< Select all names of the Dual Union with the name of the pre-> names (select '/ file01 / some / file 01'), name regexp_replace (name, 'name /' / file02 / another / file02) ^ / File0 ([1-9] +) ',' / file0 \ 1- \ 1 ') New name NEW ------------------------ -------------------- Thank you - Thanks

Comments