You can also use:
utl_tcp.CRLF

instead of chr(13)||chr(10)


send_email('[Email address protected] process has completed' || utl_tcp.CRLF||
'oradba.DATA_TAPE_APPLICANT: ' || l_app_count || utl_tcp.CRLF ||
'oradba.DATA_TAPE_TXN_CODES: ' || l_app_count ||utl_tcp.CRLF ||
'oradba.DATA_TAPE_ASSET: ' || l_app_count || utl_tcp.CRLF)||
'oradba.DATA_TAPE_LOANINFO: ' || l_app_count);


Stacy

On Wednesday 31 August 2005 7:53 pm, Chris Hagemaier wrote:
> Just to clarify (Insert <CR><LF>):
>
> send_email('[Email address protected] process has completed' ||
> chr(13)||chr(10) ||
> 'oradba.DATA_TAPE_APPLICANT: ' || l_app_count ||
> chr(13)||chr(10) ||
> 'oradba.DATA_TAPE_TXN_CODES: ' || l_app_count ||
> chr(13)||chr(10) ||
> 'oradba.DATA_TAPE_ASSET: '|| l_app_count ||
> chr(13)||chr(10)||
> 'oradba.DATA_TAPE_LOANINFO: '||
> l_app_count);
>
> The process has completed
> oradba.DATA_TAPE_APPLICANT : 19659
> oradba.DATA_TAPE_TXN_CODES : 19659
> oradba.DATA_TAPE_ASSET : 19659
> oradba.DATA_TAPE_LOANINFO : 19659
> This is how it currently looks in the email.
>
> The process has completedoradba.DATA_TAPE_APPLICANT:
> 19659oradba.DATA_TAPE_TXN_CODES: 19659oradba.DATA_TAPE_ASSET:
> 19659oradba.DATA_TAPE_LOANINFO:19659
>
>
> -----Original Message-----
> From: Armstrong Richard
> [mailto:oracledba-ezmlmshield-x15441091.[Email address protected]
> Sent: Wednesday, August 31, 2005 4:43 PM
> To: LazyDBA Discussion
> Subject: RE: SQL Format Help
>
> There is really nothing inherent in pure naked SQL to do formatting on
> result sets. You have to rely upon whatever formatting features are
> provided in the tool you are using to execute the SQL. It's a
> tool-dependent thing.
>
> In your situation, you could use some carriage return characters similar
> to how you are doing it below with the string concatenation. Just
> concatenate some return characters in the right places.
>
> -Richard
>
>
>
> -----Original Message-----
> From: Derrick Pitts
> [mailto:oracledba-ezmlmshield-x12295303.[Email address protected]
> Sent: Wednesday, August 31, 2005 8:51 AM
> To: LazyDBA Discussion
> Subject: SQL Format Help
>
> Gurus,
>
> I have a prodecure that runs and sends out an email with counts on the
> number of records entered. I need some help figuring out how to get the
> format more clear.
>
> send_email('[Email address protected] process has completed' ||
> 'oradba.DATA_TAPE_APPLICANT: ' || l_app_count ||
> 'oradba.DATA_TAPE_TXN_CODES: ' || l_app_count ||
> 'oradba.DATA_TAPE_ASSET: '
>
> || l_app_count || 'oradba.DATA_TAPE_LOANINFO: ');
>
> This is how it currently looks in the email.
>
> The process has completedoradba.DATA_TAPE_APPLICANT:
> 19659oradba.DATA_TAPE_TXN_CODES: 19659oradba.DATA_TAPE_ASSET:
> 19659oradba.DATA_TAPE_LOANINFO:19659
>
> How do I format this to put each sentence on a separate line, like this
> for instance?
>
> The process has completed
> oradba.DATA_TAPE_APPLICANT : 19659
> oradba.DATA_TAPE_TXN_CODES : 19659
> oradba.DATA_TAPE_ASSET : 19659
> oradba.DATA_TAPE_LOANINFO : 19659
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
> see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com By using this list you agree
> to these terms:http://www.lazydba.com/legal.html
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html

--
Stacy Gaddy
W-(919)321-0855
C-(910)376-1256
stacy.[Email address protected]

Oracle LazyDBA home page