SQL: Structured Query Language - Oracle 10g Database Administration Concepts and Implementation Made Simple - page 25

SELECT TRIM (LEADING 0
FROM 001234567000) Result"
FROM DUAL;
Output:
Result
--------
1234567000
Similarly we can replace LEADING with TRAILING to omit
trailing zeros in 001234567000 and the output will then be
001234567.
Example:
SELECT REPLACE('KING KONG','KI','HO') Result"
FROM DUAL;
Output:
Changes
--------------
HONG KONG
Example:
SELECT ename
FROM emp
WHERE SOUNDEX(ename) =
SOUNDEX('SMYTHE');
Output:
ENAME
----------
SMITH