SyntaxFix
Write A Post
Hire A Developer
Questions
Chr(Number) should work for you.
select 'Hello' || chr(10) ||' world' from dual
Remember different platforms expect different new line characters: