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

Similarly we can use the UPPER function.
Example:
SELECT LPAD('Page 1',15,'*+') "LPAD example"
FROM DUAL;
Output:
LPAD example
---------------
*+*+*+*+*Page 1
Similarly we can use RPAD.
Example:
SELECT LTRIM('121SPIDERMAN','12') "Result"
FROM DUAL;
Output:
Result
--------
SPIDERMAN
Similarly we can use RTRIM.
Example:
SELECT TRIM (0 FROM 001234567000) Result"
FROM DUAL;
Output:
Result
--------
1234567