Live ORACLE

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;

/

Using the Function RTRIM