Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Character String Functions

 

TRIM Leading and Trailing Zeroes

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