Using the LTRIM() and RTRIM() Oracle Functions

Using RTRIM() to remove trailing spaces

SELECT FIRSTNAME || ' ' || RTRIM(LASTNAME) AS "With RTRIM" FROM STUDENTS WHERE RowNum < 11

Using LTRIM() to remove leading spaces

SELECT  
   LTRIM(FIRSTNAME) AS "LTRIM"        
FROM    STUDENTS
WHERE RowNum < 11 

• Basic DML
  • SQL Select
  • SQL Update
  • SQL Insert
  • SQL Delete
• Functions
  • Substring function
  • Upper and Lower functions
  • RTRIM and LTRIM functions

Oracle Information and Resources