Tab and new line symbols

Database
Enthusiast

Tab and new line symbols

Hi all,

How can I add Tab and new line symbol to a string without using UDF?

Thanks.

3 REPLIES
Supporter

Re: Tab and new line symbols

Tab and new line are only charcters. So you can concat them as other chars...


select ' '!! 'text' !! '

' !! 'new line text';

Enthusiast

Re: Tab and new line symbols

Thanks, but I was asking about following:

Select '$' || x'0A' || '$';

Supporter

Re: Tab and new line symbols

So I gues you need to be more specific on your question

How can I add Tab and new line symbol to a string without using UDF?

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'