How can I add Tab and new line symbol to a string without using UDF?
Tab and new line are only charcters. So you can concat them as other chars...
select ' '!! 'text' !! '
' !! 'new line text';
Der Beginn aller Wissenschaften ist das Erstaunen, dass die Dinge sind, wie sie sind.-Aristoteles
Thanks, but I was asking about following:
Select '$' || x'0A' || '$';
So I gues you need to be more specific on your question
The answer is concat.
What is the ascii number for LF and TAB?
The answer is '0A' and '09'
or for unicode
'000A' and '0009'