Code:
SQL> select 'No space at beginning'||chr(10)||
  2         chr(32)||'One space at beginning'||chr(10)||
  3         chr(32)||chr(32)||'Two spaces at beginning'
  4         Spaces
  5         from dual;

SPACES
---------------------------------------------------------
No space at beginning
 One space at beginning
  Two spaces at beginning