How to enter newline character in Oracle?

Chr(Number) should work for you.

select 'Hello' || chr(10) ||' world' from dual

Remember different platforms expect different new line characters:

• CHR(10) => LF, line feed (unix)
• CHR(13) => CR, carriage return (windows, together with LF)