Inserting NewLine char !!

We had a requirement to insert newline char as line separators, we used the hexadecimal string '0D'XC for this.

eg:
SELECT 'ABC' || '0D'XC || 'DEF' ;

When you execute this in queryman you will see the title in two lines. But the result will be in a line, just copy/paste the result in Dos or windows or notepad or textpad it will appear in two lines.