Hello, Does anyone know how to i 3

[codehead]

Hello,

Does anyone know how to insert a carriage return into a field on Oracle. For example:
'This is the first sentence.

This is the second sentence, which comes after a blank line.'

We have an application that can do it (only on the fields included in the app), but I can't figure out the syntax to do it in straight SQL.

Thanks.

Codehead

 

[SpiritOfLennon]

To insert a CR into a field you can use concat('TEXT',CHR(015)).Does this help? SOL
The best thing about banging your head against a wall is when you stop.

 

[sem]

Use chr() function: chr(10)

 

[SpiritOfLennon]

Sorry mine should of been CHR(013) I was in octal. 10 is line feed isn't it? SOL
The best thing about banging your head against a wall is when you stop.

 

[codehead]

Thanks everyone.

I had to modify it some to get what I needed:

concat(concat(concat('TEXT',CHR(10)),CHR(10)),'TEXT').

Any ideas on how to simplify this (I have to put in about 10 of these breaks into a page of text)?

Thanks again.

Codehead

 

[carp]

Use the double pipe:

'text'||chr(10)||'text'||chr(10).....