Existing string 18, A 16 bit is 0, 16th to 0 for A, now should be how to write the replace statements, trouble for A few days... O great god teach

CodePudding user response:

Regular can't think of don't persistent, using substr ten minutes are not

 select decode (substr (t1) STR, 16, 1), 
'0', 
Substr (t1. STR, 1, 15) | | 'A' | | substr (t1) STR, 17, 2), 
T1. STR) 
The from (select '123456789012345078' STR from dual) t1 
;