Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

TRIM Leading and Trailing Zeroes

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