Re: Code for breaking the line in stored procedure.

From: dombrooks <dombrooks_at_hotmail.com>
Date: 10 Jan 2007 02:37:55 -0800
Message-ID: <1168425475.229842.112690@i39g2000hsf.googlegroups.com>

Sakthi wrote:
> Hi,
>
> I am having one variable in the for loop condition of the stored
> procedure code. For each and every loop execution, the same variable
> will be getting appended with different texts. Once the For loop is
> getting over, I am sending mail with the value of that variable.
>
> I want to break the line for each and every loop execution inside the
> for loop in order to make the mail meaningful. Help needed regarding
> this issue.
>
> Thanks & Regards,
> Sakthivel.S

If you want to append a line break into some text, concatenate CHR(10) onto your text.

e.g.
select 'try this', 'try'||chr(10)||'this' from dual Received on Wed Jan 10 2007 - 04:37:55 CST