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';
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'