表TEST 有两列 分别为 name,omr其中OMR为ABCDBADDDDDDADDDDADBCADCDADCD
ABCDBADDDDDDADDDDADBCADCDADCD
ABCDBADDDDDDADDDDADBCADCDADCDCDADA
ABCDBADDDDDDADDDDADBCADCDADCDADCADDFA请问,有什么办法可以在所有OMR字母后面加上';'
ABCDBADDDDDDADDDDADBCADCDADCD
ABCDBADDDDDDADDDDADBCADCDADCDCDADA
ABCDBADDDDDDADDDDADBCADCDADCDADCADDFA请问,有什么办法可以在所有OMR字母后面加上';'
UPDATE TEST SET OMR=REPLACE(OMR,'B','B;');
...
UPDATE TEST SET OMR=REPLACE(OMR,'Z','Z;');
AS
rtVal VARCHAR2(4000):=NULL;
BEGIN
FOR i IN 1..LENGTH(theStr) LOOP
rtVal:=rtVal || SUBSTR(theStr,i,1) || ';';
END LOOP;
RETURN rtVal;
EXCEPTION WHEN OTHERS THEN RETURN NULL;
END;
/
SQL> SELECT ADD_SEMICOLON ('ASDF') FROM DUAL;ADD_SEMICOLON('ASDF')
--------------------------------------------------
A;S;D;F;SQL> SELECT ADD_SEMICOLON ('ASDF1234') FROM DUAL;ADD_SEMICOLON('ASDF1234')
--------------------------------------------------
A;S;D;F;1;2;3;4;