Code:
SQL> select 'abc' || chr(10) || 'def' from dual;

'ABC'||
-------
abc
def

SQL>