Example 3-14 Using the Function RTRIM

DECLARE
   v_empid NUMBER(6);
   v_last_name VARCHAR2(25);
   v_first_name VARCHAR2(20);
BEGIN
   v_empid := 300;
   v_last_name := 'Lee   ';  -- note trailing blanks
   v_first_name := 'Brenda';
   DBMS_OUTPUT.PUT_LINE ( 'Employee Id: ' || v_empid || ' Name: ' 
                         || RTRIM(v_last_name) || ', ' || v_first_name );
END;
/