SELECT TRIM (0 FROM 0009872348900) "TRIM Example" FROM DUAL; TRIM Example ------------ 98723489
楼上正确。trim([ leading | trailing | both [ trim_character ] ] from string1 )============================================================================trim( both '0' from '0009872348900')
FROM DUAL;
TRIM Example
------------
98723489