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.
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.
posted by Ranjith at
3:07 pm
1 Comments
