去除左右指定的字符
SELECT TRIM ('a' FROM 'aaa0009872348900aa') "TRIM Example" FROM DUAL;
TRIM Example
--------------------------------------------------------------------
0009872348900
去除左右指定的字符
SELECT TRIM ('a' FROM 'aaa0009872348900aa') "TRIM Example" FROM DUAL;
TRIM Example
--------------------------------------------------------------------
0009872348900