Oracle how to add a character figures with you-CodePudding

Such as LV1 LV2 becomes

CodePudding user response:

The

refer to the original poster weixin_43977573 response:

as LV1 into LV2

Is varchar2 type

CodePudding user response:

LV12 is becoming LV13? In addition can have multiple digital LV12LV12

CodePudding user response:

Select regexp_replace (' LV1 ', '[^ a-z]') | | to_char (regexp_replace (' LV1 ', '[^ 0-9]) + 1) from dual;

CodePudding user response:

SELECT the replace (' 10 o LV LV, REGEXP_replace (' 10 o LV LV ', '[^ 0-9]), REGEXP_replace (' 10 o LV LV', '[^ 0-9]) + 1)
The FROM DUAL

CodePudding user response:

LV1 to LV2 is an example of the modified data is more than one, and LV3 LV5 these

CodePudding user response:

You change in single quotes to the fields, back into tables