TRIM Leading and Trailing Zeroes
SQL> SELECT TRIM (0 FROM 067270676800) "TRIM Example" 2 FROM DUAL; TRIM Exam --------- 672706768 1 row selected. SQL> --