Padding spaces precede and follow character (') literals.

Spaces precede and follow character (') literals.

SELECT first_name || ' ' || middle_name || ' ' || last_name
         'student_name'
  FROM   STUDENTS
  WHERE  ssn = 999999999;

Reference: http://www.dba-oracle.com/t_plsql_coding_spacing_standards.htm